80+ Excel Shortcuts with ALT Key|| Best Hotkey of Keyboard Shortcuts

80+ Excel Shortcuts with ALT Key || Best Hotkey of Keyboard Shortcuts

By

Microsoft Excel offers a couple of advanced excel shortcuts for handling several features and types of commands to customize the Excel activity. ALT key either individually or a combination of other keys performs a task or command more quickly than a mouse.

Likes CTRL key, ALT key also makes a couple of shortcut keys. That’s why it is called one of the best hotkeys in Excel. In a word, hotkeys are considered as shortcut keys.      

 

What is the meaning of Excel Shortcuts?

A keyboard shortcut or Excel shortcut is a key or combination of keys, after using them allow Excel users to access a particular feature or perform a command in a very short time.  Here we explain all about ALT Shortcut Keys and their uses as well. 

 

Why do we use Excel Shortcuts?

In a word, keyboard shortcuts can help Excel users to manage big database faster and handle them more efficiently because users’ hands remain on the keyboard.

  • Excel provides several keyboard shortcuts or Excel shortcuts for many commonly used commands. For example, Ctrl+S is the keyboard shortcut for the Save command, which means the user hold down the CTRL key, then press the S key to save the workbook. Similarly, Ctrl+C for the copy, Ctrl+V for the paste. 

 

  • Users can also use the keyboard to quickly select commands on the ribbon. After pressing the ALT key to display the Key Tips, which are labels that appear over each tab and command on the ribbon. Follow the labels, press the key or keys indicated to access the corresponding tab, command, or button while users’ hands remain on the keyboard.

 


Types of Advanced Excel Shortcuts with ALT Key

There are five types of Excel shortcuts made with a combination of ALT Key. 

 

Types I: Advanced Excel Shortcuts with ALT’ Key & ‘ALPHABET’ Keys

About 90% of advanced Excel shortcuts with ALT Key belong to this category. 

 

• Alt+Ctrl+V / Alt+E+S: Displays the Paste Special Window.

Equivalent to Copy the range ⇨ Home ⇨ Clipboard ⇨ Paste ⇨ Paste Special

Note: Paste Special option only activates when copied the cell(s) or range(s).

FAQs:  What is the paste special shortcut?   What is the paste values shortcut?  

Alt+Ctrl+V or Alt+E+S

 

• Alt+Ctrl+V+V / Alt+E+S+V: Converts any formulas into the Values using the Paste Special Window.

Equivalent to Copy the range ⇨ Home ⇨ Clipboard ⇨ Paste ⇨ Paste Special ⇨ Values

 

• Alt+Ctrl+V+U / Alt+E+S+U: Converts any formulas into the Values and number formats using the Paste Special Window.

Equivalent to Copy the range ⇨ Home ⇨ Clipboard ⇨ Paste ⇨ Paste Special ⇨ Values and number formats

Note: Another use of it that when we copy number, text and date format from a database and want to paste it as the same format to another location, we should apply it. As a result, date format paste as date format, number format as number and text format as text.

Alt+E+S+V or Alt+E+S+U

• Alt+Ctrl+V+R / Alt+E+S+R: Paste copied range(s) in a new place with same formulas and number formats except formatting

Equivalent to Copy the range ⇨ Home ⇨ Clipboard ⇨ Paste ⇨ Paste Special ⇨ Formulas and number formats

Alt+Ctrl+V+R or Alt+E+S+R

 

• Alt+Ctrl+V+W / Alt+E+S+W: Manage the same Column widths of a copied range(s) in a new pasted area

Equivalent to Copy the range ⇨ Home ⇨ Clipboard ⇨ Paste ⇨ Paste Special ⇨ Column widths

 

Alt+Ctrl+V+W or Alt+E+S+W

 

• Alt+Ctrl+V+T / Alt+E+S+T: Manage the same Formatting of copied range(s)

FAQs: What is an excel format painter shortcut? 

Alt+Ctrl+V+T or Alt+E+S+T

EXAMPLES• Alt+Ctrl+V+N / Alt+E+S+N: Apply same Validation over the range(s)

Alt+Ctrl+V+N or Alt+E+S+N

 

• Alt+Ctrl+V+E / Alt+E+S+E: Transpose the data

Alt E S E / Alt Ctrl V E
Step-1

 

Alt E S E or Alt Ctrl V E (2)
Step-2

 

• Alt+O+D: Display the Conditional Formatting Rules Manager

ALT+O+D

 

• Alt+D+F+F / Alt+A+T / Ctrl+Shift+L: Apply or remove the Filter

⇒ FAQs: What is the excel filter shortcut?

Alt+D+F+F or Ctrl+Shift+L or Alt+A+T

 

• Alt+A+C / Alt+D+F+S: Clear the Filter

Alt+A+C or Alt+D+F+S

• Alt+A+Q: Apply the Advanced Filter

Alt+A+Q

 

• Alt+E+I+S: Open the Series Dialogue box

Alt+E+I+S (before apply)
Before 
Alt+E+I+S (after apply)
After

 

• Alt+H+O+I: Apply Autofit Column Width

Alt+H+O+I (Before apply)
Alt+H+O+I (after apply)

 

• Alt+H+O+A: Apply Autofit Row Width

Alt+H+O+A (before apply)
Before 
Alt+H+O+A (after apply)
After

 

• Alt+O+H+R / Alt+H+O+R: Rename the Tab/worksheet

Alt+O+H+R or Alt+H+O+R

 

• Alt+E+L: Delete the tab/worksheet

Alt+E+L

 

• Alt+E+M: Open Move or Copy dialogue box for Tab

Alt+E+M

 

• Alt+H+O+U+S: Hide tab(s) /worksheet(s)

Equivalent to Right-click on Tab ⇨ Hide

Equivalent to Home ⇨ Format ⇨ Hide & Unhide ⇨ Hide Sheet

Alt+H+O+U+S (before apply)

 

Alt+H+O+U+S (after apply)

 

• Alt+H+O+U+H: Unhide tab/worksheet equivalent to Right-click on Tab ⇨ UnhideEquivalent to Home ⇨ Format ⇨ Hide & Unhide ⇨ Unhide Sheet

Alt+H+O+U+H

 

• Alt+H+O+U+H: Tab Color 

Equivalent to Home ⇨ Format ⇨ Tab Color

Alt+H+O+T (before apply)

 

Alt+H+O+T (after apply)

 

• Alt+H+E+A: Remove all the Formatting including Content

Equivalent to Home ⇨ ‘Clear’ under Editing section ⇨ Clear All

Alt+H+E+A

 

• Alt+H+E+F: Remove all the Formatting excluding Content

Equivalent to Home ⇨ ‘Clear’ under Editing section ⇨ Clear Formats

 

• Alt+A+E / Alt+D+E: Open the Convert Text to Column Wizard after selecting a single column

Equivalent to Data ⇨ Text to Columns

Alt+A+E or Alt+D+E

 

• Alt+A+M: Remove duplicates

Equivalent to Data ⇨ Remove Duplicates

Alt+A+M

 

• Alt+D+L: Open the Data Validation Window

Equivalent to Data ⇨ Data Validation

Alt+D+L

 

• Alt+H+M+C: Merge and Center

Equivalent to Home ⇨ Merge & Center

⇒ FAQs: What is the excel merge cells shortcut?  What does Excel merge and center shortcut? 

Alt+H+M+C

 

• Alt+H+W: Apply or remove the Wrap Text

Equivalent to Home ⇨ Wrap Text

Alt+H+W

 

• Alt+W+F+F: Apply or remove the Freeze Panes

Equivalent to View ⇨ Freeze Panes

ALT+W+F+F

 

• Alt+D+P: Display the Pivot Table Wizard

Equivalent to Insert ⇨ Pivot Table

⇒ FAQs:  What is a pivot table shortcut?

Alt+D+P

 

• Alt+A+R+R / Alt+F5: Refresh All active query or Pivot Table

Equivalent to Data ⇨ Refresh All

Note: All the pivot tables in a worksheet are refreshed at a time. 

Alt+A+R+R or Alt+F5

 

• Alt+D+S: Display Sort window

Equivalent to Data ⇨ Sort

⇒ FAQs:  What is the sort key to Excel?  

Alt+D+S

 

• Alt+H+B+A: Apply All Borders

Alt+H+B+A

 

• Alt+H+B+T: Apply Thick Box Borders outside a selected area

Alt+H+B+T

 

Apply both Alt+H+B+A & Alt+H+B+T: Apply All Borders and Outside Thick Box Borders of a selected area

Alt+H+B+A and Alt+H+B+T

 

• Alt+H+B+N: Remove All Borders

Alt+H+B+N

 

• Alt+H+F+F: Activate Font drop-down box

Alt+H+F+F

 

• Alt+H+F+S: Activate Font Size drop-down box

Alt+H+F+S

 

• Alt+H+F+C: Activate Font Color box

Alt+H+F+C

 

• Alt+H+H: Activate Background Color box

Alt+H+H

 

• Alt+H+H+N: No fill (remove all background colors)

Alt+H+H+N

 

• Alt+H+H+M: More colors

Alt H H M

 

• Alt+N+U: Insert Symbol

Equivalent to Insert ⇨ Symbol

Note: Choose Font Wingdings, Wingdings 2, Wingdings 3 for best results. 

 

Alt+N+U

 

• Alt+R+P+S:  Protect a sheet

Equivalent to Review ⇨ Protect Sheet

Alt+R+P+S

 

• Alt+R+P+W: Protect a workbook

Equivalent to Review ⇨ Protect Workbook

Alt+R+P+W

 

• Alt+F+T: Excel Options

Equivalent to File ⇨ Options

Alt+F+T

 

• Alt+W+Q: Zoom

Equivalent to View ⇨ Zoom

Alt+W+Q

 


Type II: Advanced Excel Shortcuts with ALT’ Key & ‘FUNCTION’ Keys

 

• ALT / F10: Active the Menu Bar

Alt or F10

 

• Alt+F1: Creates an embedded Chart from data in the current range

Equivalent to Insert ⇨ Charts (Select any)

Alt+F1

 

• Alt+Shift+F1 / Shift+F11: Insert a New Worksheet in a workbook

Equivalent to Home ⇨ Insert ⇨ Insert Sheet

Alt+Shift+F1 or Shift+F11

• Alt+F2 / Alt+F+A: Open the Save As Option

Equivalent to File ⇨ Save As

⇒ FAQs: What is the save as shortcut excel?  What is the save as shortcut key?

Alt+F2 or Alt+F+A or Ctrl+F12

 

• Alt+Shift+F2 / Ctrl+S: Save the workbook.

Equivalent to File ⇨ Save

 

• Alt+F4: Close All the opened workbooks, i.e. Close Excel

Equivalent to File ⇨ Exit

⇒ FAQs: What is the close window shortcut?

 

• Alt+F5 / Alt+A+R+R: Refresh All the active query or Pivot Table

Equivalent to Data ⇨ Refresh All

Alt+A+R+R or Alt+F5

 

• Alt+F8: Open the Macro dialog box to create, run, edit, or delete a macro

Equivalent to View ⇨ Macros ⇨ View Macros

Equivalent to Developer ⇨ Code ⇨ Macros

Alt+F8

 

• Alt+Ctrl+F9: Global Calculation i.e., Calculates all worksheets in all open workbooks

 

• Alt+F11: Open the Visual Basic Editor.

Equivalent to Developer ⇨ Code ⇨ Visual Basic

Alt+F11

 


Types III: Advanced Excel Shortcuts with ALT’ Key & ‘NAVIGATION’ Keys

 

• Alt+Page Down: Moves one screen to the right in a worksheet (Horizontally move)

• Page Down: Moves one screen to the down (Vertically move)

• Alt+Page Up: Moves one screen to the left in a worksheet (Horizontally move)

• Page Up: Moves one screen to the up (Vertically move)

Alt+Page Down, Alt+Page Up, Page Up, Page Down

 

• Alt+Shift+Page Down: Extend the selection right one screen (Horizontally move)

• Shift+Page Down: Extend the selection down one screen (Vertically move)

• Alt+Shift+Page Up: Extend the selection left one screen (Horizontally move)

• Shift+Page Up: Extend the selection up one screen

Alt+Shift+Page Down, Alt+Shift+Page Up, Shift+Page Up, Shift+Page Down

 

• Alt+↓: Display AutoComplete list / Display Filter drop-down list

Alt+↓ (Display Autocomplete List)

Figure: Use of  AutoComplete list

 

Alt+↓ (Display AutoFilter drop down list)

Figure: Use of  Filter drop-down list

 


Type IV: Advanced Excel Shortcuts with ALT’ Key & ‘SPECIAL’ Keys

 

• Alt+Tab: Switch to the next program

• Alt+Shift+Tab: Switch to the previous program

Alt+Tab, Alt+Shift+Tab

• Alt+Enter: Starts a new line in the same cell

Alt+Enter

 

• Alt+Spacebar: Displays the Control Menu of the Excel window

Alt+Spacebar

 

• Alt+Backspace / Ctrl+Z: Undo the last command or action

 


Type V: Advanced Excel Shortcuts with ALT’ Key & ‘PUNCTUATION’ Keys

 

• Alt+=: Inserts the AutoSum formula

Equivalent to Home ⇨ AutoSum

Note: We can apply the AutoSum formula in a single range or multiple ranges at a time.

⇒ FAQs: What is the excel sum shortcut?  What is the AutoSum shortcut?

Alt+=

 

• Alt+’ (single quotation): Display the Style dialog box

Alt+'

 

• Alt+; (semicolon): Select the Visible Cells Only (especially applied while the database with the filtered condition)

Equivalent to Home ⇨ Find & Select ⇨  Go To Special… ⇨ Visible Cells Only

Note: If we copy a cell with a formula and paste downwards (column-wise), it has been observed that the formula is pasted entire range along with the visible cells.

Alt+;

Read-More_Orange

• 90+ Best Excel Shortcut Keys and Hotkeys consist of CTRL Key

Sudipta Mondal
Follow AEF
80+ Excel Shortcuts with ALT Key

Microsoft Excel offers a couple of advanced excel shortcuts for handling several features and types of commands to customize the Excel activity. ALT key ei

Editor's Rating:
5

Leave a Comment

You may also like