Excel shortcuts that can save you much time at work
2 min readJan 9, 2021
Hello Everyone! Today I am going to tell you some excel shortcuts that you can use while at work. These shortcuts can help you save time and also increase your efficiency.
Here are these:
- To Open a new Workbook: Ctrl+N
- To Open an existing workbook: Cltr+O
- To save a workbook: Cltr+S
- To open Save As Dialog Box: F12
- To close a Workbook: Cltr+W
- To close Excel: Cltr+F4
- To insert a new Worksheet: Shift+F11
- To Undo an action: Cltr+Z
- To Redo an action: Cltr+Y
- To check Spelling: F7
- To switch between worksheet tabs to right: Cltr+ PgDn
- To switch between worksheet tabs to left: Cltr+ PgUp
- To open Help Pane: F1
- To check and Debug Formulas: F9
- To expand or collapse Formula Bar: Cltr+Shift+U
- Create a bar chart based on selected data in seperate sheet: F11
- Create an embedded bar Chart based on selected data in same sheet: Alt+F1
- To move to beginning of the Sheet: Cltr+ Home
- Go to leftmost cell in current row: Home
- Go to any cell: F5
- Select entire row: Shift+Space
- Select Entire column: Cltr+Space
- Select Entire Sheet: Cltr+Shift+Space
- Edit a cell: F2
- Cancel an entry inside a cell or Escape from a cell: Esc
- Delete content of selected cells: Delete
- Formatting content to make it Bold: Cltr+B
- Formatting content to make it Italic: Cltr+I
- Adding Border to selected cells: Alt+H+B
- Hide selected rows: Cltr+9
- Hide selected columns: Cltr+0
- To unhide rows: Cltr+Shift+9
- To unhide columns (By default only in Windows 7 & 8): Cltr+Shift+0
Hope you all find these shortcuts helpful. Do submit feedback.
Keep Learning :)