35 Most Useful Microsoft Excel Keyboard Shortcut & Tips

Basic Keyboard Shortcut for Excel

Keystroke / Shortcut Function
Ctrl + N Create a new workbook.
Ctrl + O Open an existing workbook.
Ctrl + S Save the active workbook.
F12 Save the active workbook under a new name, displays the Save as dialog box.
Ctrl + C Copy the contents of the selected cells to Clipboard.
Ctrl + X Cut the contents of the selected cells to Clipboard.
Ctrl + V Insert the contents of the Clipboard into the selected cell.
Ctrl + Z Undo your last action.
Ctrl + P Open the “Print” dialog / print preview window.
Ctrl + F4 / Ctrl + W Close the active workbook.

 

 

Most Used Keyboard Shortcut for Data Entry in Excel

Function

Keystroke / Shortcut

Notes

Edit the current cell.

F2

Press F2 to edit the current cell.
Enter a new line in Cell

Alt + Enter

To enter new line while editing (typing) the cell, press Alt + Enter.
Enter Data and move down

Enter

Press Enter After entering data on a cell, to move the cursor down by one cell.
Enter Data and move up

Shift + Enter

Press Shift + Enter After filling data on a cell, to move the cursor above the current cell.
Enter Data and move right

Tab

Press Tab after filling data on a cell, to move the cursor right to the current cell.
Enter Data and move left

Shift + Tab

Press Enter + Tab after filling data on a cell, to move the cursor below the current cell.
Complete entry and stay in same cell

Ctrl + Enter

Press Ctrl + Enter After filling data on a cell, to stay in cell.
Enter same data in multiple cells

Ctrl + Enter

Select multiple cells and enter the data on one cell then Press Ctrl +Enter to enter the same data in all cells in the selection at once.
Insert current date

Ctrl + ;

To Insert the current date in selected cell press Ctrl+;
Insert current time

Ctrl + Shift + :

To Insert the current time in selected cell press Ctrl +shift+: .
Duplicate of upper cell

Ctrl + D

To make a copy of upper cell press Ctrl + D on down cell.
Total Calculation

Alt + =

Calculate total sum of cell above in a column by pressing Alt + =
Duplicate of upper row

Ctrl + D

If we make a selection of whole row before pressing Ctrl + D on down row then it will make duplicates of upper row at once.
Note: We can also make a copy of cells by selecting cells and dragging the cursor from the corner of the selected cell.
Copy from cell left

Ctrl + R

Pressing Ctrl + R will make duplicate from left cell to right cell.
Copy formula from the cell above

Ctrl + ‘

To copy the formula from upper cell press Ctrl + ‘ .
Copy value from the cell above

Ctrl + Shift + “

To copy only result of some formula from upper cell, press Ctrl+ shift+”.
Open paste special after copying.

Ctrl + Shift + V

After copying something from cell press Ctrl + Shift + V to open “Paste special” dialog
Add hyperlink

Ctrl + K

To add a hyperlink on any cell press Ctrl+K.
Move cursor from one edge cell to another edge on actual data consisting area of excel.

Ctrl + Arrow keys

To move the cursor from top cell to bottom cell on actual data consisting area, press Ctrl + down arrow key.
To move the cursor from bottom cell to top cell on actual data consisting area, press Ctrl + UP arrow key.
Select the entire column

Ctrl + Space

Pressing Ctrl + Space on cell will selcect entire column of respective cell.
Select the entire row

Shift + Space

Pressing Shift + Space on cell will selcect entire row of respective cell.
Select Worksheet

Ctrl + A

Press Ctrl + A once to select the table that contain Cursor and Ctrl + A multiple times to select entire worksheet
Selecting row/column/table on current table

Ctrl +Shift + Arrow keys

Use combination of Ctrl +Shift + Arrow keys to make selection on current table.
Open the “Format Cells” dialog.

Ctrl + 1

To open Format cell option to select cell type like number, text, time, currency etc. Press  Ctrl + 1 ( “1” from left of keyboard, not from Numeric Pad).
Convert selected cells into a table

Ctrl + T

To convert selected cell into table press Ctrl + T .