Skip to content

Latest commit

 

History

History
40 lines (29 loc) · 702 Bytes

Excel.md

File metadata and controls

40 lines (29 loc) · 702 Bytes
Enter : Down
Shift + Enter: Up
Tab : Right
Shift + Tab: Left

Ctrl + Home: First Row
Ctrl + Page Down: Last Row

Ctrl + Space: Select Column:
Shift + Space: Select Row:

Ctrl + A: Select Range Data:
Ctrl + Page Down: Move between sheet

Ctrl + Click : get Position of cell

AutoFill
FlashFill
AutoFilter
SubTotal

Relative Reference  C4
Absolute Reference  $C$4 (Shortkey: F4)

Range: C4:C9
Ex: =SUM(C4:C9)
Ex: =SUM(Named_Preferened)
Ex: =SUM('SheetName1:SheetName2'!B5)

Alt + Enter: Insert a line break

Select all a column: Ctrl + Shift + Down (Up)
Select all a row: Ctrl + Shift + Left (Right)

Ctrl + Q: Quick Analys

F11: Show chart in new worksheet
Alt + F1: Show chart on same worksheet