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+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+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+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+T / Alt+E+S+T: Manage the same Formatting of copied range(s)
⇒ FAQs: What is an excel format painter shortcut?
• Alt+Ctrl+V+E / Alt+E+S+E: Transpose the data
• Alt+O+D: Display the Conditional Formatting Rules Manager
• Alt+D+F+F / Alt+A+T / Ctrl+Shift+L: Apply or remove the Filter
⇒ FAQs: What is the excel filter shortcut?
• Alt+A+C / Alt+D+F+S: Clear the Filter
• Alt+A+Q: Apply the Advanced Filter
• Alt+E+I+S: Open the Series Dialogue box
• Alt+H+O+I: Apply Autofit Column Width
• Alt+H+O+A: Apply Autofit Row Width
• Alt+O+H+R / Alt+H+O+R: Rename the Tab/worksheet
• Alt+E+L: Delete the tab/worksheet
• Alt+E+M: Open Move or Copy dialogue box for Tab
• 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+H: Unhide tab/worksheet equivalent to Right-click on Tab ⇨ UnhideEquivalent to Home ⇨ Format ⇨ Hide & Unhide ⇨ Unhide Sheet
• Alt+H+O+U+H: Tab Color
Equivalent to Home ⇨ Format ⇨ Tab Color
• Alt+H+E+A: Remove all the Formatting including Content
Equivalent to Home ⇨ ‘Clear’ under Editing section ⇨ Clear All
• 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+M: Remove duplicates
Equivalent to Data ⇨ Remove Duplicates
• Alt+D+L: Open the Data Validation Window
Equivalent to Data ⇨ Data Validation
• 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+W: Apply or remove the Wrap Text
Equivalent to Home ⇨ Wrap Text
• Alt+W+F+F: Apply or remove the Freeze Panes
Equivalent to View ⇨ Freeze Panes
• Alt+D+P: Display the Pivot Table Wizard
Equivalent to Insert ⇨ Pivot Table
⇒ FAQs: What is a pivot table shortcut?
• 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+D+S: Display Sort window
Equivalent to Data ⇨ Sort
⇒ FAQs: What is the sort key to Excel?
• Alt+H+B+A: Apply All Borders
• Alt+H+B+T: Apply Thick Box Borders outside a selected area
• 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+N: Remove All Borders
• Alt+H+F+F: Activate Font drop-down box
• Alt+H+F+S: Activate Font Size drop-down box
• Alt+H+F+C: Activate Font Color box
• Alt+H+H: Activate Background Color box
• Alt+H+H+N: No fill (remove all background colors)
• Alt+H+H+M: More colors
• Alt+N+U: Insert Symbol
Equivalent to Insert ⇨ Symbol
Note: Choose Font Wingdings, Wingdings 2, Wingdings 3 for best results.
• Alt+R+P+S: Protect a sheet
Equivalent to Review ⇨ Protect Sheet
• Alt+R+P+W: Protect a workbook
Equivalent to Review ⇨ Protect Workbook
• Alt+F+T: Excel Options
Equivalent to File ⇨ Options
• Alt+W+Q: Zoom
Equivalent to View ⇨ Zoom
Type II: Advanced Excel Shortcuts with ‘ALT’ Key & ‘FUNCTION’ Keys
• ALT / F10: Active the Menu Bar
• Alt+F1: Creates an embedded Chart from data in the current range
Equivalent to Insert ⇨ Charts (Select any)
• Alt+Shift+F1 / Shift+F11: Insert a New Worksheet in a workbook
Equivalent to Home ⇨ Insert ⇨ Insert Sheet
• 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+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+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+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
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+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+↓: Display AutoComplete list / Display Filter drop-down list
Figure: Use of AutoComplete 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+Enter: Starts a new line in the same cell
• Alt+Spacebar: Displays the Control Menu of the Excel window
• 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+’ (single quotation): Display the Style dialog box
• 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.
Latest posts by Sudipta Mondal (see all)
- Excel SUMIFS Function - October 27, 2019
- How to use INDEX MATCH Function in Excel with 04 Best Examples - October 13, 2019
- 09 Steps to Reduce Excel File size || Evaluate Existing Formulas || - September 5, 2019
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