Mastering Excel: 65 Keyboard Shortcuts for Efficient Spreadsheet Creation

Excel is one of the most popular spreadsheet programs available today. It offers a variety of tools and features that can help you organize and analyze data quickly and efficiently. One way to save time and streamline your workflow in Excel is by using keyboard shortcuts.

Keyboard shortcuts are combinations of keys that perform specific actions in Excel. By using these shortcuts, you can navigate through your spreadsheet, enter and edit data, and perform various other tasks without ever having to touch your mouse. In this article, we will provide you with a comprehensive list of all the keyboard shortcuts available in Excel.

excel 65 keyboard shortcuts

These are just a few of the many keyboard shortcuts available in Excel. By using these shortcuts, you can save time and increase your productivity while working with spreadsheets. Remember that many of these shortcuts can be customized, so don’t be afraid to experiment and find the shortcuts that work best for you.

Create new workbookCtrl + N
Save workbookCtrl + S
Open Print menuCtrl + P
Open Excel optionsAlt, F, T
Open right-click menuShift + F10
Protect/unprotect workbookAlt, R, P, W
Protect/unprotect worksheetAlt, R, P, S
Input and Editing
CopyCtrl + C
CutCtrl + X
PasteCtrl + V
Open Paste Special windowCtrl + Alt + V
UndoCtrl + Z
RedoCtrl + Y
Copy data and formatting from the cell aboveCtrl + D
Use Flash FillCtrl + E
Insert current dateCtrl + ; (Semicolon)
Insert current timeCtrl + Shift + : (Colon)
Navigation and Selection
Move to cellArrow key
Move to the first cellCtrl + Home
Move to the last cell of the rightmost populated columnCtrl + End
Move to the first cell in the current rowHome
Move to the edge cell within a regionCtrl + Arrow key
Move one screen up/downPage up/down
Move one screen right/leftAlt + Page down/up
Move to the next/previous sheetCtrl + Page down/up
Select cell in chosen directionShift + Arrow key
Select one screen right/leftShift + Alt + Page down/up
Select rowShift + Space
Select columnCtrl + Space
Select additional row/column/cellCtrl + Left click
Select entire active worksheetCtrl + A
Toggle Ribbon shortcutsAlt
Navigate Ribbon sectionsAlt, Arrow key
Open Find and ReplaceCtrl + F
Zoom inCtrl + Alt + = (Equals)
Zoom outCtrl + Alt + – (Minus)
Visibility and Grouping
Hide rowCtrl + 9
Hide columnCtrl + 0
Open Group windowShift + Alt + Right arrow
Open Ungroup windowShift + Alt + Left arrow
Tables and Graphs
Create tableCtrl + T
Open table styles windowAlt, H, T
Insert row aboveAlt, H, I, R
Insert column to leftAlt, H, I, C
Open PivotTable menuAlt, N, V
Open PivotTable wizardAlt, D, P
Open Format Cells windowCtrl + 1
Apply General number formatCtrl + Shift + ~ (Tilde)
Apply Currency formatCtrl + Shift + $ (Dollar)
Apply Percentage formatCtrl + Shift + % (Percent)
Apply Scientific formatCtrl + Shift + ^ (Caret)
Apply Date formatCtrl + Shift + # (Hash)
Apply Time formatCtrl + Shift + @ (At)
Apply/remove boldCtrl + B
Apply/remove italicCtrl + I
Apply left alignAlt, H, A, L
Apply center alignAlt, H, A, C
Apply right alignAlt, H, A, R
Adjust row heightAlt, H, O, H
Adjust column widthAlt, H, O, W
Apply bottom borderAlt, H, B,

Combining the use of these 65 Excel keyboard shortcuts with other productivity techniques like AutoFill can help you save time and effort when working on spreadsheets. By relying less on your mouse and reducing the time spent navigating through menus, you’ll be able to complete your tasks more efficiently. Incorporating these shortcuts into your workflow can make a significant difference in your productivity and help you build spreadsheets faster and with greater ease.

Frequently asked Questions

Scroll to Top