101 Shortcuts of Excel Explain(Master in Excel)

All Shortcuts of Excel Explain

To become superfast in Excel, your hand should be fitted well on the keyboard. Now to sfit on the keyboard that is to have good command on the shortcut keys, and this is why 101 Shortcut Keys.


Ctrl + E – Flash Fill


Ctrl+Page Up/Down: Move to the previous or next worksheet


Shift+Left/Right Arrow: Extend the cell selection to the left or right


Shift+Space: Select the entire row


Ctrl+Space: Select the entire column


Ctrl+Shift+Space: Select the entire worksheet


Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)


Ctrl+Home: Move to the beginning of a worksheet


Ctrl+End: Go to the most bottom right used cell


Page Up/Down: Move one screen up or down in a worksheet


Alt+Page Up/Down: Move one screen to the right or left in a worksheet


F8 : Exntend Selection


Ctrl+W  / CTRL + F4: Close a workbook  (Alt + Space + C)


F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.


Shift+F11: Insert a new worksheet


Ctrl+Z: Undo an action


Ctrl+Y: Redo an action


Ctrl+N: Create a new workbook


Ctrl+O: Open an existing workbook


Ctrl+S: Save a workbook


F12: Open the Save As dialog box


Ctrl+ P: Print / Print Preview


F1: Open the Help pane


F7: Check spelling


F9: Calculate all worksheets in all open workbooks


Alt + V + Z : Zoom in / Zoom Out


Alt or F10: Turn key tips on or off


Ctrl+F1: Show or hide the ribbon


Ctrl+Shift+U: Expand or collapse the formula bar


Ctrl+F9: Minimize the workbook window


F11: Create a bar chart based on selected data (on a separate sheet)


Alt+F1: Create an embedded bar chart based on select data (same sheet)


Ctrl+F: Search in a spreadsheet, or use Find and Replace


Alt+F: Open the File tab menu


Alt+H: Go to the Home tab


Ctrl+Tab: Switch between open workbooks


Shift+F3: Insert a function


Alt+F8: Create, run, edit, or delete a macro


Alt+F11: Open the Microsoft Visual Basic For Applications Editor


Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row


Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column


Tab = Goto the Next cell  & Shift+Tab: Go to the previous cell


F5 or CTRL + G: Go to any cell by pressing F5 and typing the cell coordinate or cell name.


F2: Edit a cell


Shift+F2: Add or edit a cell comment


Ctrl+X: Cut contents of a cell, selected data, or selected cell range


Ctrl+C or Ctrl+Insert: Copy contents of a cell, selected data, or selected cell range


Ctrl+V or Shift+Insert: Paste contents of a cell, selected data, or selected cell range


Ctrl+Alt+V: Open the Paste Special dialog box


Alt+Enter: Insert a hard return within a cell (while editing a cell)


F3: Paste a cell name (if cells are named in the worksheet)


Esc: Cancel an entry in a cell or the formula bar


Enter : Complete the Formula / Paste Content if already copied


Alt+H+H: Select a fill color


Alt+H+B: Add a border


Ctrl+Shift+&: Apply outline border


Ctrl+Shift+_ (Underscore): Remove outline border


Ctrl+9: Hide the selected rows


Ctrl + Shift + 9 : Unhide Rows


Ctrl+0: Hide the selected columns


Ctrl+1: Open the Format Cells dialog box


Ctrl+5: Apply or remove strike through


Ctrl+Shift+$: Apply currency format


Ctrl+Shift+%: Apply percent format


Ctrl+Shift+#: Apply Date format


Ctrl+Shift+@: Apply Time format


Ctrl+Shift+!: Apply Number format


Ctrl+Shift+ ~: Apply General format


Ctrl+ ‘ : Copy Above Content to Fill below


Ctrl + D = Fill Down


Ctrl + R – Fill Right


Ctrl + F3 = Name Manager 


Ctrl  + F10 = Restore Window or Alt + Space + R   


Alt + Space + X – Maximize  or Ctrl + F10 – Restore 


Ctrl + F9 – Minimize  / Alt + Tab – Maximize / Switch


Ctrl + F11 – Insert Macro Name Sheet


Ctrl  + F12 = Open Dialog box


Ctrl + Shift + F1 – Hide Tab and Ribbon


Alt + V + U – Full Screen


Ctrl + Shift + F3 – Create Names from Selection


Alt + H + W – Wrap Text


Ctrl + Shift + Page Down / Page up – Select All Sheets to the right / Left


Ctrl + ; – Insert Date


Ctrl + Shift + ; – Insert Time


Ctrl + T – Create Table or Ctrl + L 


Alt + H + O + R – Rename Sheet


Ctrl + H – Replace


Ctrl + K – Hyperlink


Ctrl + Shift + {  – Select all cells which involved in selected formula 


Ctrl + Shift + }  – Select Formula cells where selected cell in included  


Ctrl  + Shift + A – Insert Argument Names into a Formula


Alt + A + T – Apply and Remove Filter


ALT + N + V – PIVOT TABLE


ALT + = : AutotSum


ALT + H +M + C – MERGE AND CENTER


CTRL  + ~ = Show and Hide All formulas from sheet


CTRL + SHIFT + ENTER – Create Array


Alt + A + Q – Advance Filter


 Alt + H + O + I – Auto-fit Column Width


Alt + H + FP – Format Painter


Alt + H + E + F – Clear Format


Ctrl + + – Insert Column / Row

Ctrl  + –  = Delete Row / Column

Alt + I + R – Insert Row

Alt + I + C – Insert Column

So if you liked these EXCEL TIPS mentioned in this, then just comment and tell us.

Leave a Comment

Share via
Copy link
Powered by Social Snap