MS Excel: Top 50 Mostly Used Excel Keyboard Shortcuts

Added On: May 2, 2023

Last Update: Aug 17, 2023

MS Excel keyboard shortcuts makes Excel work easy and save time. Excel keyboard shortcuts are used most frequently. Time invested in learning about the keyboard shortcuts will repay for many times while you working with Excel worksheet/spreadsheet.

Excel keyboard shortcuts help while working with Excel more efficiently and using shortcuts can complete lots of work in less time.

Excel keyboard shortcuts are mentioned below in different categories and try to use shortcuts in your daily routine work till the shortcuts become used.

1. Copy And Paste Shortcuts

Shortcuts	Description
ctrl + c	Used to copy the particular section of the page.
ctrl + v	Paste particular data from the clipboard into the selected section of the spreadsheet.
ctrl + d	Fill the below pattern: If a single cell is selected of a row then copies the content of the above row into the selected range. If multiple cells are selected of more than one row then copy the content of the top row selected into all other rows of a selected range.
ctrl + r	Fill the data to the right: If a single cell is selected for a column then copy the content from the column towards the left of the selected range. If multiple cells are selected of more than one column then copy the content of the first selected column into all other columns of a selected range.
ctrl + z	Undo the change or last action performed on the spreadsheet.

2. Selecting Cells Shortcuts

ctrl + [Left Mouse Button]	Select multiple cells at a time.
shift + [Left Mouse Button]	Selects all cells from the last selected cell to the currently selected cell.
shift + ↓	Moves the current selected range towards down of a row
shift + ↑	Moves the currently selected range towards the up of a row.
shift + →	Moves the currently selected range towards the right by one column.
shift + ←	Moves the currently selected range towards the left by one column.
ctrl + shift + ↓	Selects all cells below the current selected cell, up to the edge of the current data region.
ctrl + shift + ↑	Selects all cells above the current selection, up to the edge of the current data region.
ctrl + shift + →	Selects all cells towards the right of the currently selected cell, up to the edge of the current data region.
ctrl + shift + ←	Selects all cells towards the left of the currently selected cell, up to the edge of the current data region.
ctrl + Spacebar	Selects all the cells of the current column.
shift + Spacebar	Selects all the cells of the current row.
ctrl + a	Selects all cells of a current Excel worksheet/spreadsheet.

3. Find And Replace

ctrl + f	Used to find in the current worksheet.
ctrl + h	Used to find and replace in current worksheet.
shift + f4	Used to repeat the last find request.

4. Selecting And Inserting Into Worksheet Shortcuts

shift + f11	Used to add a new worksheet of the current Excel workbook.
alt + shift + f1	Used to add a new worksheet of the current Excel workbook.
ctrl + PageDown	Used to move to next worksheet
ctrl + PageUp	Used to move to next worksheet
shift + ctrl + PageDown	Used to select the current and the next worksheet.
shift + ctrl + PageUp	Used to select the current and the previous worksheet.

5. Workbook Action Shortcuts

ctrl + s	Used to save current.
f12	Used to save already saved file with different name.
ctrl + o	Used to open existing workbook.
ctrl + n	Used to create a workbook.
ctrl + w	Used to close the current workbook.