Open In App

Top 100+ Excel Shortcut Keys List (A to Z)

Last Updated : 15 Mar, 2024
Improve
Improve
Like Article
Like
Save
Share
Report

Did you know that using keyboard shortcuts can increase productivity and save you time? Although the term “shortcut” may seem intimidating, it’s important to consider the benefits if you use computers every day!

Here, we provide a list of all essential list of excel shortcut keys, Starting with Basic Excel Shortcuts to advanced Excel shortcut keys.

Top-Excel-Shortcuts

We have also compiled all the essential computer shortcut keys, which include shortcuts for popular software like Microsoft Word, Excel, PowerPoint, and Gmail, as well as special characters and shortcuts relevant to competitive exams.

What is Microsoft Excel?

MS Excel is an electronic spreadsheet with numerous rows and columns, used for organizing data, graphically representing data, and performing different calculations. Despite various new tools for data analytics in the market, Excel is the go-to product for working with data. Excel has numerous in-built features, that make organizing data easier for you.

The Excel shortcut keys help you to work on your data effectively and efficiently. Below are some shortcuts that can be used to perform tasks faster. The Excel shortcut for inserting a row is Alt+I+R and Shortcut for Filter is Ctrl+Shift+L.

Note: CTRL is used in Windows whereas CMD is used for Mac operating system.

List of all the Excel Shortcut Keys

Here below we have provided all the Excel shortcut keys that will make your work fast and efficient:

Basic Shortcuts in Excel

These are the Shortcuts that are used to perform some basic tasks such as opening help, undoing, redoing the last action, and many more.

Shortcuts

Descriptions

F1

To open Help

Ctrl + Z

To Undo the last action

Ctrl + Y

To redo the last action

Ctrl + C

To copy the Selected data

F4

To Repeat the last action

Ctrl +X

To cut the selected data

Ctrl + V

To paste the Content from the clipboard

Ctrl + Alt + V

To display the paste special dialog box

Ctrl+ F

To display the find and replace with the find tab selected

Ctrl + H

To display the find and replace with the Replace tab selected

Ctrl+ Shift + F4

Find the previous match

Shift +F4

Find the next match

Alt + F1

Insert Embedded chart

F11

Insert a chart in a new sheet

Ctrl + Shift + L

Toggle Autofilter

Atl + (Arrow down button)

Activate Filter

Ctrl + T or Ctrl + L

Create Table

Shift + Space

Select Table row

Ctrl + Space

Select Table column

Ctrl + A

Select the table when the active cell is in the table

Clear Slicer Filter

Atl + C

Run Spellcheck

F7

Open the Macro Dialog box

Alt + F8

Open VBA Editor

Alt + F11

Duplicate object, Formula, Text Ctrl + D
Snap to grid Alt
Hide or show objects Ctrl + 6
Open modify cell style dialog box Alt + ‘
Show right-click menu Shift + F10
Display control menu Alt Space

Excel Worksheet Shortcut keys

The worksheet is a collection of cells, where you can store and manipulate data. By default, every workbook contains at least one worksheet in it. It is easier to organize and locate information in your workbook by using multiple worksheets when working with huge data. Excel Shortcuts will help you to work with large data in less amount of time. For exiting the worksheet, Renaming the worksheet, and many more.

Below are some shortcuts for worksheet:

Shortcuts

Description

Shift + F11

Insert a new worksheet

Ctrl +PgDn

Go to the next Worksheet

Ctrl + PgUp

Go to the previous worksheet

Alt +O, H, R

Rename current worksheet

Alt + E, L

Delete current worksheet

Alt + E, M

Move Current Worksheet

F6 or Shift + F6

Move between the worksheet, Ribbon, Task pane, and zoom controls in a worksheet that has been split

Ctrl + Shift + PgUp/PgDn

Select adjacent worksheet

Ctrl + Click

Select non-adjacent worksheets

Scrlk

Toggle Scroll Lock

Ctrl +Shift + F1

Toggle fullscreen

Ctrl + P

Print

Ctrl + F2

Open print preview window

Alt + P, R, S

Set Print area

Alt + P + R,C

Clear Print area

Ctrl + Mouse Wheel up

Zoom in

Ctrl + Mouse Wheel Down

Zoom in

Alt + R, P, S

Zoom in

Excel Workbook Shortcut Keys

We can learn the basic operations of the workbook. For example, how to create a new workbook, open an existing workbook, and save a spreadsheet so that data or any performance on the data will not be lost.

The term workbook refers to the entire Excel file.

Shortcuts

Descriptions

Ctrl + N

This will create a new workbook

Ctrl + O

This will open an existing workbook

Ctrl + S

This will save a workbook

Ctrl + W

This will Close the current workbook

Ctrl + F4

This will Close Excel

Ctrl + PageDown

This will move to the next sheet

Ctrl + PageUp

To move to the previous sheet

Ctrl + A

To go to the Data tab

Ctrl + W

To go to the View tab

Alt + M To go to the Formula tab
Ctrl + Z

This will undo your most recent action.

Ctrl + Y This will Redo your most recent action.

Shortcuts keys for Ribbon in Excel

The ribbon in Excel is the row of tabs and icons at the top of the Excel window that allows us to quickly find, understand and use commands for completing a certain task.

Shortcut

Description

Ctrl +F1

Expand and collapse Ribbon

Alt

Activate access keys

Space or Enter

Activate or open selected Control

Enter

Confirm control change

F1

Get help with selected control

Drag and Drop Shortcuts in Excel

Here are the Drag and Drop Shortcut keys in Excel:

Shortcuts

Description

Drag

Drag and cut

Ctrl + Drag

Drag and copy

Shift + Drag

Drag and insert

Ctrl + Shift + Drag

Drag and insert copy

Alt + Drag

Drag to Worksheet

Ctrl + Drag

Drag to duplicate Worksheet

Shortcuts Keys for Navigation in Excel

The navigation pane in Excel is an easy way to understand a workbook’s layout, see what elements are there in the workbook, and navigate directly to those elements.

Shortcuts

Description

Right side arrow

Move one cell Right

Left side arrow

Move one cell Left

Upward arrow

Move one cell up

Downward arrow

Move one cell down

Alt + PgDn

Move one screen Right

Alt + PgUp

Move one screen Left

PgUp

Move one screen up

PgDn

Move one screen down

Ctrl + Right Arrow

Move to the right edge of the data region

Ctrl + Left Arrow

Move to the left edge of the data region

Ctrl + Upward arrow

Move to the top edge of the data region

Ctrl + Downward arrow

Move to the bottom edge of the data region

Home

Move to the beginning of Row

Ctrl + End

Move to the last cell in the Worksheet that contains the data

Ctrl + Home

Move to the first cell in the Worksheet

End

Turn end mode on

Excel Shortcut keys for Active Cell

The active cell is the cell in the worksheet on which the task is being performed. There are various functions that can be performed on Active cell for which below are the shortcut keys:

Shortcuts

Descriptions

Shift + Backspace

Select the active cell( when multiple cells already selected0

Ctrl + Backspace

Show the active cell on the worksheet

Ctrl +.

Move active cell clockwise to corners of the selection

Enter

Move the active cell down in the selection- wrap to the next column

Shift + Enter

Move active cells up in selection – wrap to the previous column

Tab

Move active cell right in a selection – Wrap to next row

Shift + Tab

Move active cell left in a selection – Wrap to the previous row

Excel Shortcut keys for Selection

There is various operation that takes a lot of time, We can do them with a simple click using shortcuts as mentioned below:

Shortcuts

Descriptions

Shift + Space

Select the entire row

Ctrl + Space

Select entire column

Ctrl + A

Select the current region if the worksheet contains data. Press again to select the current region and summary rows. Press again to select the entire worksheet.

Shift + Click

Expand Selection

Ctrl + Click

Add nonadjacent cells to the selection

Ctrl + Alt + Right Side arrow

Move right between non- Adjacent selections

Ctrl + Alt + Left side arrow

Move left between non-adjacent selections

Shift +F8

Toggle the ‘Add to selection’ mode

Esc

Exit the ‘Add to selection ‘ mode

Shortcut Keys for Cell Edit Mode in Excel

Excel Shortcut Keys for Cell Edit Mode are mentioned below:

Shortcuts

Descriptions

F2

Edit active cell

Shift +F2

Insert or edit the comment

Shift + F10 ,M

Delete comment

Esc

Cancel Editing

Shift + Right Side Arrow

Select one character right

Shift + Left Side arrow

Select one character Left

Ctrl + Right side Arrow

Move one word right

Ctrl + Left side Arrow

Move one word left

Ctrl + Shift +Right arrow

Select one word right

Ctrl + Shift + Left arrow

Select one word left

Shift +Home

Select the beginning of the cell

Shift + End

Select to end of the cell

Ctrl + Delete

Delete to end of line

Backspace

Delete the character to the left of the cursor

Delete

Delete the character to the right of the cursor

Alt +Enter

Start a new line in the same cell

Excel Shortcut Keys to Enter data

You may need to reenter the data again and again whenever you need to perform the Calculations to make your work easy and fast below are some shortcut keys that can be used to enter the data.

Shortcuts

Description

Enter

Enter data and move down

Shift + Enter

Enter data and move up

Tab

Enter data and move right

Shift +Tab

Enter data and move left

Ctrl + Enter

Enter data and stay in the same cell

Enter

Enter the same data in multiple cells

Ctrl + ;

Insert current date

Ctrl + Shift + :

Insert current Time

Ctrl + D

Fill down from the cell Above

Ctrl + R

Fill right from the cell on the left

Ctrl + ‘

Copy the formula from the cell above(the formula is an exact copy)

Ctrl +Shift + “

Copy value from the cell above

Ctrl + K

Insert hyperlink

Alt + Arrow down

Display AutoComplete list

Formatting in Excel Using Shortcut Keys

Excel shortcut keys for Formatting are listed below:

Shortcuts

Description

Ctrl + 1

Format cells

Ctrl + Shift + F

Display format cells with font tab selected

Ctrl + B

Apply or remove bold

Ctrl + I

Apply or remove italics

Ctrl + U

Apply or remove the underscore

Ctrl + 5

Apply or remove the strikethrough

Alt + H, A, C

Align center

Alt + H, A, L

Align left

Alt+ H, A, R

Align right

Alt + H, 6

Indent

Alt+ H, 5

Remove Indent

Alt + H, W

Wrap text

Alt + H, A, T

Align top

Alt + H, A, M

Align Middle

Alt + H, A, B

Align bottom

Alt + H, F, G

Increase font size by one step

Alt + H, F, K Decrease font size by one step

Shortcut Keys for Insert & Layout in Excel

Shortcuts

Description

Alt +N+T

To insert table

Alt +N+P

To insert picture

Alt +N+S+H

To insert shape

Alt +N+S+C

To insert Chart

Alt +N+I

To insert hyperlink

Alt +N+X

To insert a text box

Alt +N+U

To insert Symbol

Alt +N+H

To insert header and footer

Alt +W+F+C

To Create a custom View

How to apply Borders in Excel Using Shortcut

Excel Shortcut Keys to apply borders are listed below:

Shortcuts

Descriptions

Alt + H + B

To open a list of borders styles from ribbon

Ctrl + Shift + &

Add a border around selected cells

Alt + H +B,R

Add or remove the right border

Alt + H, B, L

Add or remove the left border

Alt +H, B, P

Add or remove the top border

Alt + H, B, O

Add or remove the bottom border

Alt + H, B, A

Add all borders to all cells in the selection

Ctrl + Shift + –

Remove borders

Excel Shortcut Keys for Pivot Tables

Here are some of the Excel Shortcut keys for Pivot Tables:

Shortcuts

Descriptions

Alt + N+ V

Create pivot table

Ctrl + A

Select entire pivot table

Alt + Shift + Right arrow

Group pivot table

Alt + Shift + Left arrow

Ungroup Pivot table items

Ctrl + –

Hide (Filter out) pivot table item

Alt + H,S,C

Unhide (clear filter on) pivot table item

Alt +N,S,Z,C

Insert pivot chart.

Conclusion

The above article provides the important shortcut keys that will help you in saving time. These key shortcuts are very helpful in Excel allowing you to ditch long methods for simple tasks and helps you to excel in excel fast.

Excel Shortcut Keys – FAQs

Which are the 5 basic shortcut keys?

The 5 basic shortcut keys are:

  1. Copy: Ctrl + C.
  2. Cut: Ctrl + X.
  3. Paste: Ctrl + V.
  4. Display and hide the desktop: Windows logo key + D.
  5. Switch between open apps: Alt + Tab.

Give some shortcuts for Number formatting

Some shortcut keys for Number Formatting are:

  • Ctrl + Shift + ~ : To apply a general format
  • Ctrl + Shift +! : To apply the number format
  • Ctrl + Shift + @ : To apply the time format
  • Ctrl + Shift + # : To apply the date format
  • Ctrl + Shift + $ : To Apply Currency Format
  • Ctrl + Shift + % : To apply Percentage Format
  • Ctrl + Shift + ^ : To apply a scientific format

What are the 20 shortcut keys in Excel?

The 20 shortcut keys in Excel are:

1. To move to the next sheet – Ctrl + PageDown

2. To edit a cell – F2

3. Go to Formula Tab – ALT +M

4. Close Excel – CTRL +F4

5. Create New Workbook -CTRL + N

6. To add border – ALT + H + B

7. To move to the next Cell – Tab

8. Copy Cells- CTRL + C

9. Paste Cells- CTRL + V

10. Createv pivot table – ALT +N +V

11. Selecting Entire pivot table – CTRL +A

12. Creating custom view- ALT +W + F + C

13. Enter data and move left – Shift + Tab

14. Insert current date- CTRL +;

15. Activate or open selected Control- Space

16. Format cells – CTRL + 1

17. Drag to Worksheet- ALT + Drag

18. To apply the number format- CTRL + Shift + !

19. Turn end mode on- end

20. Move to the beginning of Row- Home

What does Ctrl +Y mean?

This keyboard Shortcut is used for performing the same action Again. This means CTRL +Y is to redo



Similar Reads

Top PowerPoint Shortcut Keys List
PowerPoint is like your best friend when it comes to sharing ideas, presenting projects, and keeping your audience engaged. But did you know there's something super cool hidden in there? It's called keyboard shortcuts. Think of them as your magic wand—they help you move smoothly between slides, make your designs look perfect, and make creating pres
7 min read
How to Create a Desktop Shortcut in Windows?
Desktop shortcuts are a quick link to a particular file found inside the complex directories and drives on our Windows operating systems. Applications can be opened easily with only one click through desktop shortcuts. We can create desktop shortcuts for any type of file. Moreover, using desktop shortcuts reduces the valuable time of the user. Ways
2 min read
How to Create Your Own Shortcut in Android Studio?
Android Studio is the official integrated development environment for Google’s Android operating system, built on JetBrains’ IntelliJ IDEA software and designed specifically for Android app development. Android Studio offers a lot of shortcuts to users. It also provides to configure Keymap and add your own shortcuts. So in this article let's create
2 min read
How to Create a Copilot Desktop Shortcut in Windows 11
Windows 11 emerges as a trailblazer, introducing a groundbreaking feature that sets it apart from its predecessors. Enter Windows Copilot, a built-in AI assistant that transforms the user experience by providing centralized AI support directly within the operating system. This marks a significant leap, making Windows 11 the pioneer in offering such
8 min read
Editing Excel Macros in Excel
Excel Macro is a set of actions that can be recorded, saved, used multiple times. This feature saves us a lot of time when dealing with repetitive tasks and huge data sets. We can always make changes to an existing Macro in Excel. There are two ways to record and run macros: Excel Commands Excel Visual Basic for Applications(VBA).1. Copying a Macro
1 min read
Best Microsoft Excel High-Paying Jobs with Excel Skills in 2024
Master Essential Skills to Launch Your Career with Microsoft Excel, the world's leading spreadsheet software. Dominate data analysis, financial modelling, and project management tasks used by organizations of all sizes. Excel proficiency is a highly sought-after skill that can boost your resume and open doors to high-paying jobs. Excel High-Paying
14 min read
Top 20 Excel Shortcuts That You Need To Know
Although many of us are already aware of Microsoft Excel, let us still have a basic introduction to it. Microsoft Excel is a very powerful and pretty old application developed by Microsoft in the year 1984, extensively used for spreadsheet processing, business operations, accounting, social media marketing, and many more. It is extensively used acr
6 min read
How to find Top or Bottom N values in Excel?
Functions help find top or bottom N values in excel very easily. The functions used to find Nth largest and Nth smallest number are = LARGE(array, k) and = SMALL(array, k) respectively. Cell Reference Before understanding the LARGE and SMALL functions. We first need to have a fine knowledge of cell references. Cell reference is of two types: Relati
4 min read
Lookup Top N Values Ignoring Duplicates in Excel
Excel is one of the best ways to organize and present a large amount of data. However, finding data in excel requires certain commands. In order to lookup top N values ignoring duplicates, it is important to first learn how to find top N values in Excel. Top N values mean finding the largest value, second largest value, and so on. However, if we wa
2 min read
Top Excel Data Analysis Functions
Have you ever analyzed any data? What does it mean? Well, analyzing any kind of data means interpreting, collecting, transforming, cleaning, and visualizing data to discover valuable insights that drive smarter and more effective decisions related to business or anywhere you need it. So, Excel solves a big problem as you can use functions to analyz
6 min read
Article Tags :