Click here to read more about how to disable it if you don’t have Scroll Lock key on your keyboard. Usually helpful when the Workbook is not scrolling. Scroll Lock – Disable Scrolling in your Excel Workbook. Shift + Arrow Keys – Select cells in the direction of the Arrow Keys (One at a time)Ĭtrl + Shift + Arrow Keys – Select cells until the last non-empty cell (Stops when you reach an empty cell) Here are some of the most popular shortcuts for Excel for Windows users:Ĭtrl + A / Ctrl + Shift + Space – Select all (Click once to select the current range, click twice to select the entire worksheet)Ĭtrl + Shift + Arrow keys – Select a range – from the selected cell to the end of the rangeĬtrl + Arrow keys – Go the end of the rangeĪlt + (Semicolon) – Select visible cell onlyĬtrl + – (Minus) – Delete cells/ rows/ columnsĬtrl + Shift + = – Insert cells/rows/columnsĬtrl + S – Save Workbook (Or Save As, if it’s the first time you’re saving it)į12 – Save As (Even if you already saved it!)į4 – (When editing a specific cell) Apply absolute/mixed/relative reference (For example, cell C4 will change to $C$4 – Absolute Reference)ĬTRL + E – Flash Fill – One of Excel’s greatest tools for auto-completing data based on examples from adjacent cells.Ĭtrl + ~ (Tilde) – Shows all the formulas in the sheetį4 – (When a cell is not being edited) Repeats the last actionĬtrl + Shift + Enter -Apply an array formulaĬtrl + PgUp/PgDn – Navigate between sheetsĬtrl + – Takes you to the cell which is affected by the current cellį5, then Enter (not together) – Takes you back to where you were before using ctrl + [Ĭtrl + Home / Ctrl + End – Go to the first cell in worksheet (A1) / Go to the last cell in the used rangeĬtrl + Arrow Keys – Go to the last non-empty cell (Stops when you reach an empty cell) Apple user? Click here to view Excel Shortcuts for Mac
0 kommentar(er)
