There are many data analytics tools out there, but Microsoft Excel remains a popular go-to for storing and managing data.

Since Excel has a lot of functionality built into it, getting familiar with the various keyboard shortcuts will help you work more efficiently.

In this article, I’m going to show you some of those shortcuts and what they are used for.

Excel Keyboard Shortcuts

ShortcutDescription
Keyboard shortcuts for making selections
Ctrl + ASelects the entire worksheet
Ctrl + Shift + Page upSelects the current and previous worksheet
Ctrl + Shift + Page downSelects the current and next worksheet
Shift + Up arrowExtends the selection of a cell by one cell upward
Shift + Down arrowExtends the selection of a cell by one cell downward
Shift + Right arrowExtends the selection of a cell by one cell forward
Shift + Left arrowExtends the selection of a cell by one cell backward
F8Turns on extend mode so you can extend selections with the arrow key pressed
EnterMakes a cell entry and selects the cell below
Shift + EnterMake a cell entry and selects the cell above
Shift + SpacebarSelects an entire row
Ctrl + SpacebarSelects an entire column
Ctrl + Shift + HomeExtends selection from the current cell to the beginning of the sheet
Ctrl + Shift + EndExtends selection from the current cell to the end of the sheet
HomeSelects the first cell in a row
Keyboard shortcuts for performing actions
Ctrl + ZUndoes the last action
Ctrl + YRepeats the last action
Ctrl + NCreates a new worksheet
Ctrl + BBolds the item in a cell
Ctrl + IItalicizes the item in a cell
Ctrl + UUnderlines the item in a cell
Ctrl + 5Applies a strikethrough to the content in a cell
Ctrl + OOpens a worksheet
Ctrl + WCloses a worksheet
Ctrl + SSaves a worksheet
Ctrl + CCopies a selection
Ctrl + VPastes a selection
Ctrl + XCuts a selection
Ctrl + 9Hides a row
Ctrl + 0Hides a column
DeleteRemoves the content of a cell
Alt + H, A, CAligns the content of a cell to the center
Alt + PGoes to the Page Layout tab
Alt + NGoes to the Insert tab
Alt + AGoes to the Data tab
Alt + WGoes to the View tab
Alt + MGoes to the Formula tab
Alt + H, BAdds borders
Alt + H, D, CDeletes a column
Keyboard shortcuts for navigating in cells
Up arrowMoves one cell up in a worksheet
Down arrowMoves one cell down in a worksheet
Right arrowMoves one cell to the right in a worksheet
Left arrowMoves one cell to the left in a worksheet
Ctrl + ArrowMoves to the edge of the data in the direction of the arrow key
End, arrowEnters the end mode and moves to the edge in the direction of the arrow key pressed
Ctrl + EndMoves to the last cell in a worksheet
Ctrl + EndMoves to the first cell in a worksheet
Page upMoves one screen up
Page downMoves one screen down
Alt + Page upMoves one screen to the left
Alt + Page downMoves one screen to the right
Keyboard shortcuts for formatting cells
Ctrl + 1Opens the Format Cells dialogue box
Ctrl + Shift + FOpens the dialogue box for formatting fonts in a cell
F2Turns on cursor in a cell
Shift + F2Inserts a note
Ctrl + Shift + F2Inserts a threaded comment
Ctrl + Shift + Plus (+)Opens the dialogue box for inserting blank cells
Ctrl + Shift + Minus (-)Opens the dialogue box for deleting selected cells
Ctrl + SemicolonEnters the current date
Ctrl + Shift + ColonEnters the current time
Ctrl + CCopies the selected cell
Ctrl + XCuts the selected cell
Ctrl + VPastes copied or selected content
Ctrl + Alt + VOpens the Paste Special dialogue box
Ctrl + Shift + &Applies an outlined border to the selected cell
Ctrl + 8Displays and hides outlined symbols
Ctrl + DReplaces the current content with the content above it
Ctrl + $Applies currency formatting to a number
Ctrl + ~Applies the general number format
Ctrl + Shift + %Applies the percentage format
Ctrl + Shift + ^Apploes the scientific number format
Ctrl + Shift + #Applies the day format to a number with the day, month, and year
Ctrl + Shift + @Applies the time format with the hour, minute, and PM or AM
Ctrl + Shift + !Applies the number format with thousand separators
Ctrl + KOpens the inserts a hyperlink dialogue box
F7Checks spelling in the worksheet or selected range
Ctrl + QDisplays the Quick Analysis options
Ctrl + TDisplays the Create Table dialogue box
Ctrl + Shift + GOpens the Workbook Stats dialogue box
Keyboard shortcuts for working with functions and the formula bar
Ctrl + Shift + UExpands and collapses the formula bar
EnterExecutes an entry in the formula bar
EscCancels an entry in the formula bar
Shift + F9Calculates the active worksheet
F9Calculates all worksheets in opened workbooks
Alt + Shift + F10Displays the message or menu for an Error Checking button
Alt + =Inserts the autosum formula
Shift + F3Inserts a function
Alt + F11Opens the Microsoft Visual Basic for Applications Editor
Other Shortcuts
F1Displays Excel help
Ctrl + F6Switches between two Excel windows
F7Opens the spelling dialogue box for spellcheck
Alt + F4Closes Excel
Ctrl + F5Switches to the window size of the active workbook
Shift + F11Inserts a new worksheet
F12Opens the Save As dialogue box
Ctrl + F10Maximizes or restores the window of the selected workbook
Ctrl + F9Minimizes the workbook window

Conclusion

I hope the shortcuts in this article help you become more efficient and productive when using Excel so you can work with data faster.

If you find the shortcuts helpful, you can share the article so it can reach others who might need it.