Excel Shortcut Keys - Compute Expert

Excel Shortcut Keys




In this tutorial, you will learn the shortcut keys you can use to perform many excel functions.

When we work in excel, we surely want to do our work productively. One of the many ways we can implement to improve our excel work productivity is by using its various shortcut keys.

There are many shortcut keys we can use to help us finish our excel tasks much faster. Want to know what are those shortcut keys and what among them are probably the most useful? Read this tutorial until its last part!







What is the Excel Shortcut?

Excel shortcut is a combination of buttons you can push to run specific functions in excel faster.

There are many functions in excel that have shortcut buttons. If you press the right shortcut buttons, you should be able to do a specific task you want in excel fast!



Important and Useful Excel Shortcut Keys

From the many shortcuts that excel has, some are probably more important and useful than others. That is because we often need to perform their functions in our work in excel. If you have memorized and mastered these shortcut keys usage, you should be able to finish your excel work much faster!

So, what are these shortcut keys that we should know? According to our experience, these are those you probably will use more often.

DescriptionWindowsMac
Save a workbook fileCtrl + SCommand + S
Print fileCtrl + PCommand + P
Activate ribbon direct access buttonAlt
Drag and cut (overwrite)DragDrag
Drag and cut (to a new cell)Shift + DragShift + Drag
Drag and cut (to another worksheet)Alt + DragCommand + Drag
Move worksheetDragDrag
Duplicate worksheetCtrl + DragOption + Drag
Move to the data region’s far rightCtrl + →Command + →
Move to the data region’s far leftCtrl + ←Command + ←
Move to the data region’s bottomCtrl + ↓Command + ↓
Move to he data region’s topCtrl + ↑Command + ↑
Select the whole worksheetCtrl + ACommand + A
Extend selection one cell to the rightShift + →Shift + →
Extend selection one cell to the leftShift + ←Shift + ←
Extend selection one cell upShift + ↑Shift + ↑
Extend selection one cell downShift + ↓Shift + ↓
Extend selection to the last cell filled with data on the rightCtrl + Shift + →Control + Shift + →
Extend selection to the last cell filled with data on the leftCtrl + Shift + ←Control + Shift + ←
Extend selection to the last cell filled with data on the topCtrl + Shift + ↑Control + Shift + ↑
Extend selection to the last cell filled with data on the bottomCtrl + Shift + ↓Control + Shift + ↓
Create new line in the textAlt + EnterOption + Enter
Finish data input and move downEnterEnter
Input current dateCtrl + ;Control + ;
Input current timeCtrl + Shift + :Command + ;
Flash fill (From excel 2013)Ctrl + EControl + E
Show Format Cells dialog boxCtrl + 1Command + 1
Toggle boldCtrl + BCommand + B
Toggle absolute and relative referenceF4Command + T
AutoSum selected cell rangeAlt + =Command + Shift + T
Input array formulaCtrl + Shift + EnterControl + Shift + Enter
Zoom inCtrl + Scroll the Mouse Wheel UpControl + Trackpad/ Scroll the Mouse Wheel Up
Zoom outCtrl + Scroll the Mouse Wheel DownControl + Trackpad/ Scroll the Mouse Wheel Down
Move to the next worksheetCtrl + Page DownFn + Control + ↓
Move to the previous worksheetCtrl + Page UpFn + Control + ↑
Open VBA editorAlt + F11Fn + Option + F11
Cancel last actionCtrl + ZCommand + Z
Redo the cancelled last actionCtrl + YCommand + Y




Every person’s shortcut preferences might be different, however, depending on the work he/she does in excel. You should identify what excel functions you often run and know their shortcuts so you can utilize the excel shortcuts productively.



Full Excel Shortcut Keys List (Windows & Mac)

Here is a comprehensive shortcut keys list that should work in excel (might not be exhaustive).

We have grouped these shortcut keys based on their functions so you can find the shortcut you need easier.


FILE


DescriptionWindowsMac
Create a new workbook fileCtrl + NCommand + N
Open a workbook fileCtrl + OCommand + O
Save a workbook fileCtrl + SCommand + S
Save as a workbook fileF12Command + Shift + S
Close current workbookCtrl + F4Command + W
Close excelAlt + F4Command + Q



PRINT


DescriptionWindowsMac
Print fileCtrl + PCommand + P
Open Print PreviewCtrl + F2





RIBBON


DescriptionWindowsMac
Expand/collapse ribbonCtrl + F1Command + Option + R
Activate ribbon direct access buttonAlt
Move to the next ribbon controlTabTab
Activate/open selected ribbon controlSpaceSpace
Confirm the change in ribbon controlEnterReturn
Get explanation help about selected ribbon controlF1



TABLE AND ITS FILTER


DescriptionWindowsMac
Create tableCtrl + TControl + T
Select table rowsShift + SpaceShift + Space
Select table columnsCtrl + SpaceControl + Space
Select the whole tableCtrl + ACommand + A
Show/hide table total rowCtrl + Shift + TCommand + Shift + T
Show/hide Autofilter in the tableCtrl + Shift + LCommand + Shift + F
Activate filter in the tableAlt + ↓Option + ↓
Remove slicer filterAlt + COption + C





DRAG AND DROP (CELL CONTENT)


DescriptionWindowsMac
Drag and Cut (Overwrite)DragDrag
Drag and Copy (Overwrite)Ctrl + DragOption + Drag
Drag and Cut (To a new cell)Shift + DragShift + Drag
Drag and Copy (To a new cell)Ctrl + Shift + DragOption + Shift + Drag
Drag and Cut (To another worksheet)Alt + DragCommand + Drag



DRAG AND DROP (WORKSHEET)


DescriptionWindowsMac
Move worksheetDragDrag
Duplicate worksheetCtrl + DragOption + Drag



NAVIGATION


DescriptionWindowsMac
Move one screen to the rightAlt + Page DownFn + Option + ↓
Move one screen to the leftAlt + Page UpFn + Option + ↑
Move one screen downPage DownFn + ↓
Move one screen upPage UpFn + ↑
Move to the data region’s far rightCtrl + →Command + →
Move to the data region’s far leftCtrl + ←Command + ←
Move to the data region’s bottomCtrl + ↓Command + ↓
Move to he data region’s topCtrl + ↑Command + ↑
Move to the beginning of the rowHomeFn + ←
Move to the most top left in the worksheet where the row has dataCtrl + EndFn + Control + ←
Move to the most bottom right in the worksheet where the row has dataCtrl + HomeFn + Control + →
Toggle End ModeEndFn + →
Move back to the hyperlinkCtrl + G + EnterControl + G + Enter





ACTIVE CELL


DescriptionWindowsMac
Select just the active cellShift + BackspaceShift + Delete
Show active cell in the worksheetCtrl + BackspaceControl + Delete
Move active cell clockwise in a cell range selectionCtrl + .Control + .
Move active cell down in a cell range selectionEnterEnter
Move active cell up in a cell range selectionShift + EnterShift + Enter
Move active cell to the right in a cell range selectionTabTab
Move active cell to the left in a cell range selectionShift + TabShift + Tab



CELL SELECTION


DescriptionWindowsMac
Select the whole rowShift + SpaceShift + Space
Select the whole columnCtrl + SpaceOption + Space
Select the whole worksheetCtrl + ACommand + A
Select all the cells from where the currently selected cell is to where you clickShift + ClickShift + Click
Select the cells currently selected and the one you click simultaneouslyCtrl + ClickCommand + Click
Select the same cell region in the column to the leftOption + Tab
Select the same cell region in the column to the rightOption + Shift + Tab
Move selection to the right in between the cells/cell ranges which are not connectedCtrl + Alt + →Control + Option + →
Move selection to the left in between the cells/cell ranges which are not connectedCtrl + Alt + ←Control + Option + ←
Toggle Add to Selection modeShift + F8Fn + Shift + F8
Cancel cell selectionEscEsc



SELECTION EXTENSION


DescriptionWindowsMac
Extend selection one cell to the rightShift + →Shift + →
Extend selection one cell to the leftShift + ←Shift + ←
Extend selection one cell upShift + ↑Shift + ↑
Extend selection one cell downShift + ↓Shift + ↓
Extend selection to the last cell filled with data on the rightCtrl + Shift + →Control + Shift + →
Extend selection to the last cell filled with data on the leftCtrl + Shift + ←Control + Shift + ←
Extend selection to the last cell filled with data on the topCtrl + Shift + ↑Control + Shift + ↑
Extend selection to the last cell filled with data on the bottomCtrl + Shift + ↓Control + Shift + ↓
Extend selection one screen upShift + Page UpFn + Shift + ↑
Extend selection one screen downShift + Page DownFn + Shift + ↓
Extend selection one screen to the rightAlt + Shift + Page DownFn + Control + Shift + ↑
Extend selection one screen to the leftAlt + Shift + Page UpFn + Control + Shift + ↓
Extend selection to the beginning of the rowShift + HomeFn + Shift + ←
Extend selection to the first worksheet’s cellCtrl + Shift + HomeFn + Control + Shift + ←
Extend selection to the last worksheet’s cellCtrl + Shift + EndFn + Control + Shift + →
Toggle Selection Extension modeF8Fn + F8





SPECIAL SELECTION


DescriptionWindowsMac
Show Go To dialog boxCtrl + GControl + G
Select cells with commentsCtrl + Shift + OFn + Control + Shift + O
Select the whole worksheet with the current active cellCtrl + Shift + *Shift + Command + Space
Select the active cell’s arrayCtrl + /Control + /
Select the cell with different content to the active cell on one row in the selected cell rangeCtrl + \Control + \
Select the cell with different content to the active cell on one column in the selected cell rangeCtrl + Shift + |Control + Shift + |
Select direct cell references of the active cell’s formulaCtrl + [Control + [
Select direct and indirect cell references of the active cell’s formulaCtrl + Shift + {Control + Shift + {
Select all the cells that directly refer to the active cell in their formulasCtrl + ]Control + ]
Select all the cells that directly and indirectly refer to the active cell in their formulasCtrl + Shift + }Control + Shift + }
Select all the cells which are not hidden in the selected cell rangeAlt + ; Before Excel 2016:
Command + Shift + Z

After Excel 2016:
Option + ;



EDIT CELL MENU


DescriptionWindowsMac
Go to the edit mode of the active cellF2Control + U
Insert or delete commentShift + F2Fn + Shift + F2
Cancel edit modeEscEsc
Select one character to the rightShift + →Shift + →
Select one character to the leftShift + ←Shift + ←
Move one word to the rightCtrl + →Option + →
Move one word to the leftCtrl + ←Option + ←
Select one word to the rightCtrl + Shift + →Control + Shift + →
Select one word to the leftCtrl + Shift + ←Control + Shift + ←
Select until the beginning of the cellShift + HomeFn + Shift + ←
Select until the end of the cellShift + EndFn + Shift + →
Delete until the end of the cellCtrl + Delete
Delete one character to the leftBackspaceDelete
Delete one character to the rightDeleteFn + Delete
Create new line in the textAlt + EnterOption + Enter



DATA INPUT


DescriptionWindowsMac
Finish data input and move downEnterEnter
Finish data input and move upShift + EnterShift + Enter
Finish data input and move to the rightTabTab
Finish data input and move to the leftShift + TabShift + Tab
Finish data input and stay in the same cell (when the selection is only in one cell)Ctrl + EnterControl + Enter
Input the same data on all cells in the selected cell range (when the selection is a cell range)Ctrl + EnterControl + Enter
Input current dateCtrl + ;Control + ;
Input current timeCtrl + Shift + :Control + Shift + →
Input data from the top cell to the bottom one in the selected cell rangeCtrl + DCommand + D
Input data from the most left cell to the rightest cell in the selected cell rangeCtrl + RCommand + R
Copy formula from the above cellCtrl + ‘Control + ‘
Copy value from the above cellCtrl + Shift + “Control + Shift + “
Add hyperlinkCtrl + KCommand + K
Show AutoComplete listAlt + ↓Option + ↓
Flash fill (From excel 2013)Ctrl + EControl + E





GENERAL FORMAT


DescriptionWindowsMac
Show Format Cells dialog boxCtrl + 1Command + 1
Show Format Cells dialog box with Font tab selectedCtrl + Shift + FControl + Shift + P
Toggle boldCtrl + BCommand + B
Toggle italicCtrl + ICommand + I
Toggle underlineCtrl + UCommand + U
Toggle strikethroughCtrl + 5Command + Shift + X
Toggle shadow fontCommand + Shift + W
Toggle text outlineCommand + Shift + D
Align centerAlt + H > A > CCommand + E
Align leftAlt + H > A > LCommand + L
Align rightAlt + H > A > RCommand + R
Add indentAlt + H > 6Control + Option + Tab
Remove indentAlt + H > 5Control + Option + Shift + Tab
Increase font sizeAlt + H >F > GCommand + Shift + >
Decrease font sizeAlt + H > F > KCommand + Shift + <



NUMBER FORMAT


DescriptionWindowsMac
Apply general formatCtrl + Shift + ~Control + Shift + ~
Apply currency formatCtrl + Shift + $Control + Shift + $
Apply percentage formatCtrl + Shift + %Control + Shift + %
Apply scientific formatCtrl + Shift + ^Control + Shift + ^
Apply date formatCtrl + Shift + #Control + Shift + #
Apply time formatCtrl + Shift + @Control + Shift + @
Apply number formatCtrl + Shift + !Control + Shift + !



BORDER


DescriptionWindowsMac
Add outside borderCtrl + Shift + &Command + Option + 0
Add/remove right side borderAlt + RCommand + Option + →
Add/remove left side borderAlt + LCommand + Option + ←
Add/remove top side borderAlt + TCommand + Option + ↑
Add/remove bottom side borderAlt + BCommand + Option + ↓
Add/remove upward diagonal borderAlt + D
Add/remove horizontal interior borderAlt + H
Add/remove vertical interior borderAlt + V
Remove bordersCtrl + Shift + _Command + Option + -





FORMULA


DescriptionWindowsMac
Toggle absolute and relative referenceF4Command + T
Show Insert Function dialog boxShift + F3Fn + Shift + F3
AutoSum selected cell rangeAlt + =Command + Shift + T
Show/hide formulaCtrl + `Control + `
Input the argument that is needed by the formula (after the formula name is typed)Ctrl + Shift + AControl + Shift + A
Input array formulaCtrl + Shift + EnterControl + Shift + Enter
Trigger all worksheets’ calculation processF9Fn + F9
Trigger the active worksheet’s calculation processShift + F9Fn + Shift + F9
Force to trigger all worksheets’ calculation worksheetCtrl + Alt + F9
Evaluate formula partF9Fn + F9
Expand/collapse the formula barCtrl + Shift + UControl + Shift + U
Show Function Arguments dialog boxCtrl + AControl + A
Define nameCtrl + F3Command + Fn + F3
Define name using row/column labelCtrl + Shift + F3Command + Fn + Shift + F3
Add defined name when typing a formulaF3
Input the formula suggested by the AutoCompleteTab↓ + Tab



WORKSHEET STRUCTURE


DescriptionWindowsMac
Show Insert dialog box (row/column)Ctrl +Shift + +Command + Shift + +
Show Delete dialog box (cell/row/column)Ctrl + -Command + -
Hide columnCtrl + 0Control + 0
Hide rowCtrl + 9Control + 9
Show hidden columnCtrl + Shift + 9Control + Shift + 0
Show hidden rowCtrl + Shift + 0Control + Shift + 9
Show Group dialog box (row/column)Alt + Shift + →Command + Shift + K
Show Ungroup dialog box (row/column)Alt + Shift + ←Command + Shift + J
Toggle row/column grouping symbolCtrl + 8Control + 8
Zoom inCtrl + Scroll the Mouse Wheel UpControl + Trackpad/ Scroll the Mouse Wheel Up
Zoom outCtrl + Scroll the Mouse Wheel DownControl + Trackpad/ Scroll the Mouse Wheel Down





PIVOT TABLE


DescriptionWindowsMac
Select the whole pivot tableCtrl + ACommand + A
Check/uncheck pivot table’s field checkboxSpaceSpace
Group pivot table’s itemsAlt + Shift + →Command + Shift + K
Ungroup pivot table’s itemsAlt + Shift + ←Command + Shift + J
Hide pivot table’s itemsCtrl + -
Create pivot chart in the same worksheetAlt + F1
Create pivot chart in a new worksheetF11
Show PivotTable Wizard dialog boxAlt + D + P



DIALOG BOX


DescriptionWindowsMac
Move to the next settingsTabTab
Move to the previous settingsShift + TabShift + Tab
Move to the next tabCtrl + TabControl + Tab
Move to the previous tabCtrl + Shift + TabControl + Shift + Tab
Apply selected settingsEnterEnter
Check/uncheck checkboxSpaceSpace
Cancel selected settings and close the dialog boxEscEsc



WORKBOOK


DescriptionWindowsMac
Insert a new workbookShift + F11Shift + F11
Move to the next worksheetCtrl + Page DownFn + Control + ↓
Move to the previous worksheetCtrl + Page UpFn + Control + ↑
Move to the next panelF6Fn + F6
Move to the previous panelShift + F6Fn + F6
Move to the next workbookCtrl + Tab Before Excel 2016:
Control + Tab

After Excel 2016:
Command + `
Move to the previous workbookCtrl + Shift + Tab Before Excel 2016:
Control + Shift + Tab

After Excel 2016:
Command + Shift + `
Minimize current workbookCtrl + F9Command + M
Maximize current workbookCtrl + F10Fn + Control + F10
Select from the active worksheet to the clicked oneShift + ClickShift + Click
Select the active and the clicked worksheetCtrl + ClickCommand + Click
Toggle scroll lockScrLkShift + F14
Toggle full screenCtrl + Shift + F11Command + Control + F





GENERAL - 1


DescriptionWindowsMac
Show Excel Options/Preferences dialog boxAlt + F > TCommand + ,
Show Help dialog boxF1Command + /
Show Cell Style dialog boxAlt + ‘Command + Shift + L
Show Spelling dialog boxF7Fn + F7
Show Thesaurus dialog boxShift + F7Fn + Shift + F7
Show Macro dialog boxAlt + F8Fn + Option + F8
Open VBA editorAlt + F11Fn + Option + F11
Cancel last actionCtrl + ZCommand + Z
Redo the cancelled last actionCtrl + YCommand + Y
Repeat last actionShift + ClickShift + Click
Copy selected cellsCtrl + CCommand + C
Cut selected cellsCtrl + XCommand + X
Paste from the clipboardCtrl + VCommand + V
Show Paste Special dialog boxCtrl + Alt + VCommand + Option + V
Show Find and Replace dialog box (Find)Ctrl + FCommand + F
Show Find and Replace dialog box (Replace)Ctrl + HControl + H
Find next (Find menu)Shift + F4Command + G
Find previous (Find menu)Ctrl + Shift + F4Command + Shift + G
Create chart in the same worksheetAlt + F1Fn + Option + F1
Create chart in a new worksheetF11



UMUM – 2


DescriptionWindowsMac
Duplicate objectCtrl + DCommand + D
Snap object to the gridlines (when moving/changing the object size)Alt + DragOption + Drag
Hide/show objectCtrl + 6Control + 6
Show right-click menuShift + F10Fn + Shift + F10
Show control menuAlt + Space



Excel Shortcut PDF

Need the PDF version of the excel shortcut keys list above? You can download it from the link below.

Download here

We hope you can master the shortcut keys that are useful for your excel work!



Additional Note

You can operate excel without a mouse/touchpad if you have memorized and mastered enough number of shortcut keys!

If you want to do that, try to adapt yourself by working in excel with just your keyboard. If you can do it smoothly for some time, you should be able to work in excel faster!



Related tutorials you should learn too:





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on




Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert