Рет қаралды 144
TOP 10 Excel Shortcuts!
1. CTRL + SHIFT + + (Plus Sign): Insert new rows/columns
2. CTRL + ; (Semicolon) : Insert Current Date
3. ALT + = (Equal Sign) : Insert Autosum formula
4. CTRL + K: Insert the Hyperlink
5. CTRL + 1: Opens format dialogue boxses
6. CTRL + ' (Apostrophe) : Copy formula from cell above
7. CTRL + 9: Hide Rows
8. CTRL + SHIFT +9 : Unhide Rows
9. CTRL + SHIFT + L : Apply or remove filters in data range
10. ALT + DOWN ARROW KEY : Open drop-down menu in selected cell.
#msofficeexcel #exceltech #exceltips #excelspreadsheettips #excelshortcuts #excelshortcut #microsoftoffice #exceltricks #excelfunctions #exceltutorial