Common Excel Shortcut Keys

Serial No.	Shortcut Keys	Function
1.	Ctrl + C	Copies the content of a selected cell.
2.	Ctrl + V	Pastes contents from the clipboard.
3.	Ctrl + X	Cuts and copies the contents of a selected cell.
4.	Ctrl + A	Selects all the cells in a workbook.
5.	Ctrl + F	Opens the Find dialog box.
6.	Ctrl + G	Opens the Go To dialog box.
7.	Ctrl + H	Opens the Find and Replace dialog box.
8.	Ctrl + K	Inserts a hyperlink in a selected text.
9.	Ctrl + L	Opens the Create Table dialog box.
10.	Ctrl + P	Avails the Print window to print a worksheet.
11.	Ctrl + W	Closes the current workbook.
12.	Ctrl + Z	Reverses the last action.
13.	Ctrl + 1	Opens the Format Cells dialog box.
14.	Ctrl + –	Deletes the selected columns or rows.
15.	Ctrl + Space	Selects an entire column.
15.	Shift + Space	Selects an entire row.
16.	Ctrl + Home	Redirects to cell A1.
17.	Alt	Displays the access keys.
18.	Tab	Moves to the next cell.
19.	F2	Enables editing a cell.
20.	Esc	Cancels out an entry.
21.	Enter	Executes an entry in a cell and moves to the next cell.
22.	Alt + Enter	Starts a new line in the current cell.
23.	F1	Opens the Microsoft Excel help.
24.	Ctrl + F4	Closes Microsoft Excel.
25.	Alt +F8	Opens the Macro window.

Basic Shortcut Keys in Excel [Chart]

DOWNLOAD BASIC SHORTCUT KEYS IN EXCEL PDF

Serial No.	Shortcut Keys	Function
1.	Ctrl + N	Creates a new Excel Workbook.
2.	Ctrl + O	Opens an existing workbook.
3.	Ctrl + S	Saves a workbook.
4.	Ctrl + A	Selects all the cells in the opened workbook.
5.	Ctrl + B	Makes the contents bold of a selected cell.
6.	Ctrl + C	Copies the contents of a selected cell.
7.	Ctrl + D	Fills up a selected cell with the contents of its upper cell.
8.	Ctrl + F	Opens up the Find dialog box to search for anything inside the current workbook.
9.	Ctrl + G	Opens up the Go To dialog box.
10.	Ctrl + H	Opens up the Find and Replace dialog box.
11.	Ctrl + I	Italicizes your text.
12.	Ctrl + K	Inserts hyperlink within a text.
13.	Ctrl + L	Opens up the Create Table dialog box.
14.	Ctrl + P	Brings up the Print window to print a workbook.
15.	Ctrl + R	Fills up the selected cells with the contents of the left cell.
15.	Ctrl + U	Adds up an underline to the selected text.
16.	Ctrl + V	Pastes your copied data from the clipboard.
17.	Ctrl + W	Closes down a running workbook.
18.	Ctrl + –	Deletes a selected row or column.
19.	Ctrl + Z	Reverses the last action.
20.	Ctrl + 1	Opens up the Format Cells dialog box.