Excel Keyboard Shortcuts: Best Keyboard Shortcuts For Excel Here

Excel Keyboard Shortcuts

Microsoft Excel has tons of keyboard shortcuts that can speed up the work and make things much more convenient. Almost all these shortcuts have been there for a long time, so they should be working in all versions of Excel. Many have been wanting to know all the Excel Keyboard Shortcuts, and for your reference, we have a list of all the Excel Keyboard Shortcuts. Use these Excel Keyboard Shortcuts and make work more easier and hassle-free.

Shortcuts In Excel

The more you use excel key shortcuts, the easier they are to remember. It isn't easy to memorize all of them; however, users can get a hands-on experience on them upon using them regularly. There are many shortcuts such as General Program Shortcuts, Navigate in a Worksheet or Cell shortcuts, Selecting Cells shortcuts, Editing Cells shortcuts and many more.

Keyboard Shortcuts For Excel

General Program Shortcuts

• 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+W: Close a workbook

• Ctrl+F4: Close Excel

• F4: Repeat the last command or action. 

• Shift+F11: Insert a new worksheet

• Ctrl+Z: Undo an action

• Ctrl+Y: Redo an action

• Ctrl+F2: Switch to Print Preview

• F1: Open the Help pane

• Alt+Q: Go to the “Tell me what you want to do” box

• F7: Check the spelling

• F9: Calculate all worksheets in open workbooks

• Shift+F9: Calculate active worksheets

• 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

• Alt+N: Open the Insert tab

• Alt+P: Go to the Page Layout tab

• Alt+M: Go to the Formulas tab

• Alt+A: Go to the Data tab

• Alt+R: Go to the Review tab

• Alt+W: Go to the View tab

• Alt+X: Go to the Add-ins tab

• Alt+Y: Go to the Help 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

Navigate in a Worksheet or Cell

• Left/Right Arrow: Move one cell to left or right

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

• Up/Down Arrow: Move a cell up or down

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

• Tab: Go to the next cell

• Shift+Tab: Go to the previous cell

• Ctrl+End: Go to the most bottom-right cell

• F5: Go to any cell by pressing F5 and typing the cell coordinate or cell name.

• 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

• 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

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

Selecting Cells

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

• Shift+Space: Select the entire row

• Ctrl+Space: Select the entire column

• Ctrl+Shift+Space: Select the entire worksheet

Editing Cells

• F2: Edit a cell

• Shift+F2: Add or edit a cell comment

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

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

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

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

• Delete: Remove the contents of a cell, data, or cell range

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

• F3: Paste a cell name 

• Alt+H+D+C: Delete column

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

• Enter: Complete an entry in a cell or the formula bar

Formatting Cells

• Ctrl+B: Add or remove bold to the contents of a cell, data, or cell range

• Ctrl+I: Add or remove italics to the contents of a cell, data, or cell range

• Ctrl+U: Add or remove underline to the contents of a cell, data, or cell range

• Alt+H+H: Select a fill color

• Alt+H+B: Add a border

• Ctrl+Shift+&: Apply outline border

• Ctrl+Shift+_ (Underline): Remove outline border

• Ctrl+9: Hide the selected rows

• Ctrl+0: Hide the selected columns

• Ctrl+1: Open the Format Cells dialog box

• Ctrl+5: Apply or remove strikethrough

• Ctrl+Shift+$: Apply currency format

• Ctrl+Shift+%: Apply percent format

Keyboard Shortcut For Strikethrough In Excel

To make a strikethrough in Excel, select the cell and press Control + 5. To apply this to a range of cells, select the entire range of cells, and use the shortcut.

Keyboard Shortcut To Switch Tabs In Excel

To switch between two adjacent tabs, use Ctrl + PgUp or Ctrl + PgDn. This helps to jump from one tab to another.

These are some of the most important shortcuts that can help you become an expert in Microsoft Excel. These shortcuts cannot be memorized as they are plenty in number, however users can get their hands on upon regular use. The list of Excel Keyboard Shortcuts has been provided, along with full details. Read the article to know all about Microsoft Excel Shortcuts.

Test Visual Acuity: Can You Spot the Mistake in the Shipyard Picture in 15 secs?

330 days ago

Is Fujii Kaze Married? Who is Fujii Kaze?

364 days ago

Total Youtube Users In World, Check The Total Number Of Youtube Users In The Wor...

406 days ago

Observation Brain Test: If you have Eagle Eyes Find the Word Pain among Poin in ...

429 days ago

Observation Brain Teaser: If you have Hawk Eyes Spot the Number 94 among 64 in 1...

429 days ago