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

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


-3
2 shares, -3 points

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. 

I. 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. 

II. WHY DO WE USE EXCEL SHORTCUTS?

In a word, keyboard shortcuts can help Excel users to manage big datasets 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.

The main motto of using Excel shortcuts is to customize the Excel activity rapidly other than using a mouse input device.

III. TYPES OF ADVANCED EXCEL SHORTCUTS WITH ALT KEY

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

(A). TYPE 1: ADVANCED EXCEL SHORTCUTS WITH ALT’ KEY & ‘ALPHABET’ KEYS

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

• Alt+Ctrl+V (Sequentially press Alt+Ctrl+ V) / Alt+E+S (Sequentially press 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 (Sequentially press Alt+Ctrl+V, V) / Alt+E+S+V (Sequentially press 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 (Sequentially press Alt+Ctrl+V, U) / Alt+E+S+U (Sequentially press 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 in the same format to another location, we should apply it. As a result, date format paste as date format, number format as a number, and text format as a text.

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

• Alt+Ctrl+V+R (Sequentially press Alt+Ctrl+V, R) / Alt+E+S+R (Sequentially press Alt, E, S, R)

Paste copied range(s) in a new place with the 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 (Sequentially press Alt+Ctrl+V, W)  Alt+E+S+W (Sequentially press 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 (Sequentially press Alt+Ctrl+V, T) / Alt+E+S+T (Sequentially press Alt, E, S, T)

Manage the same Formatting of copied range(s).

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

FAQs: What is an excel format painter shortcut? 

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

• Alt+Ctrl+V+N (Sequentially press Alt+Ctrl+V, N) / Alt+E+S+N (Sequentially press Alt, E, S, N)

Apply same Validation over the range(s).

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

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

• Alt+Ctrl+V+E (Sequentially press Alt+Ctrl+V, E) / Alt+E+S+E (Sequentially press Alt, E, S, E)

Transpose the data.

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

Step 1:

Alt E S E / Alt Ctrl V E

Step 2:

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

• Alt+O+D (Sequentially press Alt, O, D)

Display the Conditional Formatting Rules Manager.

Equivalent to Select the cell or range ⇨ Home ⇨ Conditional Formatting drop-down ⇨ Manage Rules

ALT+O+D

• Alt+D+F+F (Sequentially press Alt, D, F, F) / Alt+A+T (Sequentially press Alt, A, T) / Ctrl+Shift+L

Apply or remove the Filter

Equivalent to Select the dataset ⇨ Home ⇨ Sort & Filter drop-down ⇨ Filter

Equivalent to Select the dataset ⇨ Data ⇨ Filter from Sort & Filter group

⇒ FAQs: What is the excel filter shortcut?

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

• Alt+A+C (Sequentially press Alt, A, C) / Alt+D+F+S (Sequentially press Alt, D, F, S)

Clear the Filter

Equivalent to Select the dataset ⇨ Home ⇨ Sort & Filter drop-down ⇨ Clear

Equivalent to Select the dataset ⇨ Data ⇨ Clear from Sort & Filter group

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

• Alt+Ctrl+L  / Alt+A+Y (Sequentially press Alt, A, Y)

Reapply the Filter.

Equivalent to Select the dataset ⇨ Home ⇨ Sort & Filter drop-down ⇨ Reapply

Equivalent to Select the dataset ⇨ Data ⇨ Reapply from ‘Sort & Filter’ group

Note: After making any changes (edit or delete data) in filtered cells, Excel AutoFilter does not update the data automatically to reflect the changes. So, in that case, we have to ‘Reapply’ the filter to get the result. First, we click any cell within the filtered dataset and then apply any of the Excel Shortcuts.

⇒ FAQs: Reapply filter Excel shortcut

• Alt+A+Q (Sequentially press Alt, A, Q)

Apply the Advanced Filter

Equivalent to Select the dataset ⇨ Data ⇨ Advanced from Sort & Filter group

Alt+A+Q

• Alt+E+I+S (Sequentially press Alt, E, I, S)

Open the Series Dialogue box

Equivalent to Select the range ⇨ Home ⇨ Fill drop-down from ‘Editing’ group ⇨ Series

Before:

Alt+E+I+S (before apply)

After:

Alt+E+I+S (after apply)

• Alt+H+O+I (Sequentially press Alt,  H, O, I)

Apply Autofit Column Width

Equivalent to Select the dataset ⇨ Home ⇨ Format drop-down from ‘Cells’ group ⇨ Autofit Column Width

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

• Alt+H+O+A (Sequentially press Alt, H, O, A)

Apply Autofit Row Height

Equivalent to Select the dataset ⇨ Home ⇨ Format drop-down from ‘Cells’ group ⇨ Autofit Row Height

Before

Alt+H+O+A (before apply)

 

After

Alt+H+O+A (after apply)

 

• Alt+O+H+R (Sequentially press Alt, O, H, R) / Alt+H+O+R (Sequentially press Alt, H, O, R)

Rename the Sheet Tab/worksheet

Equivalent to Open the worksheet want to rename ⇨ Home ⇨ Format drop-down from ‘Cells’ group ⇨ Rename Sheet

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

• Alt+E+L (Sequentially press Alt, E, L)

Delete the Sheet Tab/worksheet

Equivalent to Open the worksheet want to delete ⇨ Home ⇨ Delete drop-down from ‘Cells’ group ⇨ Delete Sheet

Alt+E+L

• Alt+E+M (Sequentially press Alt, E, M)

Open Move or Copy dialogue box for Sheet Tab

Equivalent to Open the worksheet want to move or copy ⇨ Home ⇨ Format drop-down from ‘Cells’ group ⇨ Rename Sheet

Alt+E+M

• Alt+H+O+U+S (Sequentially press Alt, H, O, U, S)

Hide tab(s) /worksheet(s)

Equivalent to Select the tab or tabs ⇨ Right-click on any selected Tab ⇨ Hide

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

Equivalent to Select the tab or tabs ⇨ Format drop-down from ‘Cells’ group ⇨ Hide & Unhide arrow ⇨ Hide Sheet

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

• Alt+H+O+U+H (Sequentially press Alt, H, O, U, H)

Unhide tab/worksheet

Equivalent to Right-click on any Tab ⇨ Unhide

Equivalent to Home ⇨ Format drop-down from ‘Cells’ group ⇨ Hide & Unhide arrow ⇨ Unhide Sheet

Alt+H+O+U+H

• Alt+H+O+T (Sequentially press Alt, H, O, T)

Tab Color (select color from palette)

Equivalent to Select the tab(s) ⇨ Home ⇨ Format drop-down from ‘Cells’ group ⇨ Tab Color (select color from palette)

Alt+H+O+T (before apply)

 

Alt+H+O+T (after apply)

• Alt+H+E+A (Sequentially press Alt, H, E, A)

Remove all the Formatting including Content

Equivalent to Select the range ⇨ Home ⇨ ‘Clear’ drop-down from ‘Editing’ section ⇨ Clear All

Alt+H+E+A

• Alt+H+E+F (Sequentially press Alt, H, E, F)

Remove all the Formatting from the selected range.

Equivalent to Select the range ⇨ Home ⇨ ‘Clear’ drop-down from ‘Editing’ section Clear Formats

• Alt+A+E (Sequentially press Alt, A, E) / Alt+D+E (Sequentially press Alt, D, E)

Convert Text to Column Wizard after selecting a single column

Equivalent to Select the column ⇨ Data ⇨ Text to Columns

Alt+A+E or Alt+D+E

• Alt+A+M (Sequentially press Alt, A, M)

Remove duplicates

Equivalent to Select range ⇨ Data ⇨ Remove Duplicates

Alt+A+M

• Alt+D+L (Sequentially press Alt, D, L)

Open the Data Validation Window

Equivalent to Select a cell ⇨ Data ⇨ Data Validation

Alt+D+L

• Alt+H+M+C (Sequentially press Alt, H, M, C)

Merge and Center

Equivalent to Select a range of cells ⇨ 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 (Sequentially press Alt, H, W)

Apply or remove the Wrap Text

Equivalent to Select a cell or range of cells ⇨ Home ⇨ Wrap Text

Alt+H+W

• Alt+W+F+F (Sequentially press Alt, W, F, F)

Apply or remove the Freeze Panes

Equivalent to Select a cell ⇨ View ⇨ Freeze Panes

ALT+W+F+F

• Alt+D+P (Sequentially press Alt, D, P) / Alt + N + V (Sequentially press Alt, N, V)

Display the Pivot Table Wizard

Equivalent to Select a range of cells ⇨ Insert ⇨ Pivot Table

⇒ FAQs:  What is a pivot table shortcut?

Alt+D+P

• Alt+A+R+R (Sequentially press Alt, A, R, R) / Alt+F5

Refresh All active query or Pivot Table

Equivalent to Click any cell in the pivot table ⇨ 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 (Sequentially press Alt, D, S)

Display Sort window

Equivalent to Select a range of cells ⇨ Data ⇨ Sort under the ‘Sort & Filter’ group 

⇒ FAQs:  What is the sort key to Excel?  

Alt+D+S

• Alt+H+B+A (Sequentially press Alt, H, B, A)

Apply All Borders

Equivalent to Select a range of cells ⇨ Home ⇨ Borders drop-down under the ‘Font’ group ⇨ All Borders

Alt+H+B+A

• Alt+H+B+T (Sequentially press Alt, H, B, T)

Apply Thick Box Borders outside a selected area

Equivalent to Select a range of cells ⇨ Home ⇨ Borders drop-down under the ‘Font’ group ⇨ Thick Box Borders

Alt+H+B+T

Apply both Alt+H+B+A (Sequentially press Alt, H, B, A) & then Alt+H+B+T  (Sequentially press 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 (Sequentially press Alt, H, B, N)

Remove All Borders

Equivalent to Select a range of cells ⇨ Home ⇨ Borders drop-down under the ‘Font’ group ⇨ No Border

Alt+H+B+N

• Alt+H+F+F (Sequentially press Alt, H, F, F)

Activate Font drop-down box

Alt+H+F+F

• Alt+H+F+S (Sequentially press Alt, H, F, S)

Activate Font Size drop-down box

Alt+H+F+S

• Alt+H+F+C (Sequentially press Alt, H, F, C)

Activate Font Color box

Alt+H+F+C

• Alt+H+H (Sequentially press Alt, H, H)

Activate Background Color box

Alt+H+H

• Alt+H+H+N (Sequentially press Alt, H, H, N)

No fill (remove all background colors).

Alt+H+H+N

• Alt+H+H+M (Sequentially press Alt, H, H, M)

More colors

Alt H H M

• Alt+N+U (Sequentially press 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 (Sequentially press Alt, R, P, S)

Protect a Worksheet

Equivalent to Review ⇨ Protect Sheet

Alt+R+P+S

• Alt+R+P+W (Sequentially press Alt, R, P, W)

Protect a Workbook

Equivalent to Review ⇨ Protect Workbook

Alt+R+P+W

• Alt+F+T (Sequentially press Alt, F, T)

Excel Options

Equivalent to File ⇨ Options

Alt+F+T

• Alt+W+Q (Sequentially press Alt, W, Q)

Zoom

Equivalent to View ⇨ Zoom

Alt+W+Q

(B). TYPE 2: 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 (Sequentially press 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 (Sequentially press 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

(C). TYPE 3: 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 (Vertically move)

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

• Alt + ↓

Display AutoComplete list / Display Filter drop-down list

• Example 1: Display AutoComplete list

Alt+↓ (Display Autocomplete List)

• Example 2: Display Filter drop-down list

Alt+↓ (Display AutoFilter drop down list)

(D). TYPE 4: 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

(E). TYPE 5: 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 the entire range along with the visible cells.

Alt+;
If you would like to improve your academic and professional career as well, then the below courses help you a lot. Instead of Advanced Excel, a number of best courses suggested you through this platform that boosts your confidence and flies your career high.
AEF_192by192
Advance Excel Forum

Premium Courses on ed2go

excel 2019 series4&bids=739114

Microsoft Excel 2019/Office 365 Series

Bestseller
4.9/5
office master 2019 cert training w voucher4&bids=739114

Microsoft Office Master 2019 Certification Training (Vouchers Included)

Bestseller
4.9/5
excel 2019 cert training4&bids=739114

Microsoft Excel 2019 Certification Training

Bestseller
4.9/5
Accounts Payable Specialist Excel 2019 GES20904&bids=739114

Accounts Payable Specialist Certification with Microsoft Excel 2019

Bestseller
4.9/5
GES2080 Exec Asstnt Voucher4&bids=739114

Executive Assistant (Voucher Included)

Bestseller
4.9/5
oracle courses online4&bids=739114

Intermediate Oracle (Self-Paced Tutorial)

Bestseller
4.9/5
office 2019 specialist cert training4&bids=739114

Microsoft Office Specialist 2019 (MOS) Certification Training

Bestseller
4.9/5
office 2019 master cert training4&bids=739114

Microsoft Office Master 2019 Certification Training

Bestseller
4.9/5
Certified Internal Auditor MS Excel 2019 GES20884&bids=739114

Certified Internal Auditor with Microsoft Excel 2019

Bestseller
4.9/5

Premium Courses on Coursera

04 Visualisation4&bids=759505

Data Visualization in Excel

Bestseller
4.9/5
ChartsGraphsTabletThumb4&bids=759505

Introduction to Data Analysis Using Excel

Top Rated
5/5
apple 1850613 4804&bids=759505

Everyday Excel, Part 2

Bestseller
4.9/5
large icon4&bids=759505

Organizational Analysis

Bestseller
4.9/5
DA PC Image4&bids=759505

IBM Data Analyst

Bestseller
4.9/5
PwC fl c4&bids=759505

Data Analysis and Presentation Skills: the PwC Approach Final Project

Bestseller
4.9/5
ASSuccess Coursera Course Thumb4&bids=759505

Success

Bestseller
4.9/5
Specialization Certificate Emblem AADS Final4&bids=759505

Advanced Data Science with IBM

Bestseller
4.9/5
Gies I logo4&bids=759505

Predictive Analytics and Data Mining

Bestseller
4.9/5

Premium Courses on FutureLearn Limited

Premium Courses on Udemy

1797822 6f72 384&bids=507388

Microsoft Excel – Excel from Beginner to Advanced & VBA

Best Seller
4.9/5
3702524 42a24&bids=507388

Google Professional Cloud Data Engineer

Bestseller
4.6/5
1162936 2b0f 34&bids=507388

Advanced Excel Skills-How to finish works faster

Best Seller
4.8/5
793796 0e894&bids=507388

Microsoft Excel – Excel from Beginner to Advanced

Bestseller
4.7/5
977438 476d 94&bids=507388

Microsoft Excel – Data Analysis with Excel Pivot Tables

Bestseller
4.6/5
1885612 b008 64&bids=507388

Excel PRO TIPS: 75+ Tips to go from Excel Beginner to Pro

Bestseller
4.7/5
Read-More_Orange

Thanks for your interest joining to Advance Excel Forum community.

Something went wrong.

Join Our Community List

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.


Like it? Share with your friends!

-3
2 shares, -3 points
Share via

Join Our Community List

Community grow with You. * VERIFY & CONFIRM YOUR EMAIL *

Thanks for your interest joining to Advance Excel Forum community.

Fill the Correct Information.

Thanks for your interest joining to Advance Excel Forum community.

Something went wrong.

Join Our Community List

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

We use cookies to ensure that we give you the best experience on our website (by analyzing).  Please see our cookies page for further details or agree by clicking the 'Accept' button.

 

Cookie settings

Below you can choose which kind of cookies you allow on this website. Click on the "Save cookie settings" button to apply your choice.

FunctionalOur website uses functional cookies. These cookies are necessary to let our website work.

AnalyticalOur website uses analytical cookies to make it possible to analyze our website and optimize for the purpose of a.o. the usability.

Social mediaOur website places social media cookies to show you 3rd party content like YouTube and FaceBook. These cookies may track your personal data.

AdvertisingOur website places advertising cookies to show you 3rd party advertisements based on your interests. These cookies may track your personal data.

OtherOur website places 3rd party cookies from other 3rd party services which aren't Analytical, Social media or Advertising.