This is my favorite, and it works in all Microsoft 365 apps. Tap the ALT Zkey and notice your ribbon lights up. Keep tapping the letters to activate the commands on the ribbon.
For example, ALT A E activates Text to Columns.
This is my favorite, and it works in all Microsoft 365 apps. Tap the ALT Zkey and notice your ribbon lights up. Keep tapping the letters to activate the commands on the ribbon.
For example, ALT A E activates Text to Columns.
Day 1 - Use ALT = beneath a column of numbers to sum them.
Day 1 - Use ALT = beneath a column of numbers to sum them.
Have you heard of the navigation pane? It opens on the right, showing worksheets and objects, making it easy to navigate larger worksbooks.
To open it, hold down the ALT key and tap W, then K.
Make column B a helper column, so
Put 0 in B2 (assuming header row)
In B3 add "=IF(A3=A2,B2,ABS(B2-1))"
Copy this down to end
Select all except header row & in conditional formatting use =$B2=1
Make column B a helper column, so
Put 0 in B2 (assuming header row)
In B3 add "=IF(A3=A2,B2,ABS(B2-1))"
Copy this down to end
Select all except header row & in conditional formatting use =$B2=1
💡 Použij funkci FILTER! Ušetří ti čas a zvládne to za tebe. Jak na to? To ti ukážu v dnešním videu! 🎥👇
#ExcelTip #FiltrujChytře #DataBezChaosu
💡 Použij funkci FILTER! Ušetří ti čas a zvládne to za tebe. Jak na to? To ti ukážu v dnešním videu! 🎥👇
#ExcelTip #FiltrujChytře #DataBezChaosu