MS Excel shortcut keys list: 90 useful shortcuts to master Microsoft Excel on Windows and Mac

Excel provides a myriad of shortcut keys to accomplish various actions within the spreadsheet

Microsoft Excel is the go-to software for many when it comes to storing and analysing data. It boasts of several advanced features and options that other spreadsheet programs don’t provide, especially offline ones. Along with that, ease of operation is also another factor that has led to the popularity of MS Excel among students, working professionals, and businesses. To further enhance the experience of its users, Excel provides a myriad of shortcut keys to accomplish various actions within the spreadsheet. By now, you may be aware of the most common ones but there are a lot more shortcuts in Excel that can help in getting things done more efficiently and quickly. That said, in this guide we’ve listed various MS Excel shortcut keys for both Windows and Mac that you can use to complete your tasks in a jiffy. So without further ado, let’s begin.

What are shortcut keys?

Shortcuts keys are a series or combination of certain buttons to quickly complete an action as opposed to a conventional method. In the case of Microsoft Excel, there are tons of shortcuts through which the user can achieve a predefined action without relying too much on the options displayed on the screen. These shortcuts can generally be performed on a keyboard which makes things much more efficient.

Excel shortcut keys for Windows and Mac

MS Excel is widely used on Windows and macOS for various purposes. Below are the shortcut keys one can use in their workflow and quickly get the tasks done.

Frequently used Excel shortcut keys

These are the frequently used Excel shortcut keys for Windows and Mac.

ActionWindows shortcut keyMac shortcut keyResult
Save a fileCtrl + SCommand + SSave an Excel file
Save asF12Command + Shift + S

Save as a new excel file

Go to Home tabAlt + HCtrl + HomeDirectly go to the home tab in the ribbon bar
CopyCtrl + CCommand + CCopy the contents in a cell
PasteCtrl + VCommand + VPaste the contents of a previously copied cell
UndoCtrl + ZCommand + ZUndo a recent action
FindCtrl + FCommand + FFind certain contents in the worksheet
Remove cell contentDelete DeleteDelete the contents of a cell
Choose a fill colourCtrl + H, HToggle the cell colour selector
Cut selectionCtrl + XCommand + XCut and copy contents of a cell
Go to Insert tabAlt + NDirectly go to the Insert tab on the ribbon bar
BoldCtrl + BCommand + BApply bold formatting to cell contents
ItalicsCtrl + iCommand + iApply italics formatting to cell contents
UnderlineCtrl + UCommand + UApply underline formatting to cell contents
Center alignmentAlt + H, A, CCommand + EAlign the cell content to center
Go to Page Layout tabAlt + PDirectly go to the Page Layout tab
Go to Data tabAlt + ADirectly go to the Data tab
Go to View tabAlt + WDirectly go to the View tab
Add bordersAlt + H, BCommand + Option + 0Add borders to the cells

Delete column

Alt + H, D, CCommand + Hyphen (-)Delete the whole column
Go to Formula tabAlt + MDirectly go to the Formula tab
Hide rowsCtrl + 9Command + 9Hide the selected rows
Hide columnsCtrl + 0Command + 0Hide the selected columns
Insert sheetShift + F11Shift + Fn + F11Inserts a new sheet into the Excel workbook
Delete sheetAlt + E + LDeletes a sheet in the workbook

Navigation Excel shortcut keys

Always reaching out for the mouse to navigate through an Excel worksheet can be cumbersome. Navigation shortcut keys allow the user to quickly move along various places in Excel.

ActionWindows shortcut keyMac shortcut keyResult
Move screen up / downPg Up / Pg DnPage Up / Page DownThis shortcut takes you one screen up or down within the worksheet
Move screen left / rightAlt + Pg Up / Alt + Pg DnOption + Page Up / Option + Page DownThis shortcut takes you one screen left or right within the worksheet
Move worksheet tab to left / rightCtrl + Pg Dn / Ctrl + Pg UpCtrl + Page Down / Ctrl + Page UpSwitch between several worksheets in Excel
Move cell up / downUp arrow / down arrowUp arrow / down arrowNavigate through the top and bottom cells
Move to the right cellTabRight arrowInstantly move to the next right cell
Move cell to the leftShift + TabLeft arrowInstantly move to the left cell
Move to beginning of a rowHomeHomeInstantly move to the first cell within a row
Move to beginning of worksheetCtrl + HomeCtrl + HomeInstantly move to the top most left cell within the worksheet
Move to last cell with contentCtrl + EndControl + EndInstantly move to the last cell containing content

Move to the left most cell

Ctrl + left arrowCommand + left arrowMove to the left most cell in a row
Move to the right most cellCtrl + right arrowCommand + right arrowMove to the right most cell in a row
Toggle worksheet, ribbon bar and zoom controlsF6F6Easily switch between the worksheet, ribbon bar and zoom controls
Switch to next worksheetCtrl + F6Command + ~Switch to the next worksheet If more than one worksheet is opened

Cell formatting Excel shortcut keys

Want to change the look of the cells or content in Excel? These cell formatting excel shortcut keys will help you with that.

ActionWindows shortcut keyMac shortcut keyResult
Apply borderCtrl + Shift + &Command + Option + 0This shortcut applies border to selected cells
Format cells dialog boxCtrl + 1Command + 1Summon the format cells dialog box within the worksheet
Style dialog box / Modify cell style dialog boxAlt + ‘Option + ‘Summons the style dialog box (Windows) or Modify cell style dialog box (Mac)
Remove borderCtrl + Shift + _Command + Option + – This shortcut removes borders from selected cells
Currency formatCtrl + Shift + $Control + Shift + $Applies currency format with two decimal places
Number formatCtrl + Shift + ~Control + Shift + ~Applies the number formatting to a cell
Date formatCtrl + Shift + #Control + Shift + #Applies the date format to a cell
Time formatCtrl + Shift + @Control + Shift + @Applies the time 12-hour clock format to a cell
Insert hyperlinkCtrl + KCommand + KInserts a hyperlink to a cell
StrikethroughCtrl + 5Command + Up arrow + XApply strikethrough formatting to cell contents
Increase font sizeAlt + H + FGCommand + Up arrow + >Increase font size of cell(s) by one step
Decrease font sizeAlt + H + FKCommand + Up arrow + <Decrease font size of cell(s) by one step
Format painterCtrl + Alt + VApply cell formating to another cell(s)

Excel shortcut keys to make selections

Easily select various elements within the Excel sheet with these shortcut keys.

ActionWindows shortcut keyMac shortcut keyResult
Select rowShift + SpaceUp arrow + SpaceThis shortcut selects an entire row
Select columnCtrl + Space⌃ + SpaceThis shortcut selects an entire column
Select worksheetCtrl + ACommand + AThis shortcut selects the entire worksheet’s content
Select adjacent cellsShift + ClickUp arrow + ClickThis shortcut adds adjacent cells to a selection
Cancel selectionEscEscUnselect any form of selection in the worksheet
Extend selection to rightShift + right arrowShift + right arrowEasily select cells to the right one by one
Extend selection to leftShift + left arrowShift + left arrowEasily select cells to the left one by one
Extend selection to downShift + down arrowShift + down arrowEasily select cells to the bottom one by one
Extend selection to topShift + up arrowShift + up arrow

Easily select cells on the top one by one

Extend selection to left screenAlt + Shift + Pg DnFn + Shift + Command + DownExtend the cell selection to one screen on the left
Extend selection to right screenAlt + Shift + Pg UpFn + Shift + Command + UpExtend the cell selection to one screen on the right
Extend selection to bottomShift + Pg UpFn + Shift + UpExtend the cell selection to one screen on the bottom
Extend selection to topShift + Pg DnFn + Shift + DownExtend the cell selection to one screen on the top
Select cells to the leftCtrl + Shift + HomeFn + Control + Shift + Left arrowSelect all cells to the left in a row
Select cells to the right Ctrl + Shift + EndFn + Control + Shift + right arrowSelect all cells to the right in a row

Workbook shortcut keys

There are shortcuts in Excel specifically for the workbook which lets the users perform actions outside of the cells.

ActionWindows shortcut keyMac shortcut keyResult
Close workbookCtrl + WCommand + WThis shortcut closes the workbook but Excel remains opened
Open workbookCtrl + OCommand + OThis shortcut opens an existing Excel file
Create new workbookCtrl + NCommand + NThis shortcut creates a new workbook in Excel
Next workbookCtrl + Tab^ + TabGo to next workbook in Excel
Previous workbookCtrl + Shift + Tab^ + Up arrow + TabGo to the previous workbook in Excel
Minimise workbookCtrl + F9Command + MMinimises the current workbook
Maximise workbookCtrl + F10NAMaximises the current workbook
Insert new worksheetShift + F11Up arrow + F11Inserts new worksheet into Excel
Next PaneF6F6Moves to the next pane
Previous PaneShift + F6Up arrow + F6Moves to the previous pane
Switch TabsCtrl + Pg Up / Pg DnFn + ^ + Up arrow / Down arrowEasily switch between various tabs in Excel

Pivot table shortcut keys

A pivot table converts the data in a manner that allows users to easily analyse, identify and calculate the particular data. There are several shortcuts for the same as well.

ActionWindows shortcut keyMac shortcut keyResult
Open pivot table wizardAlt + D + PCommand + ⌥ + POpens a pivot table wizard dialog box
Create pivot chartAlt + F1Creates a new pivot chart on the current worksheet
Create pivot chart on new worksheetF11Fn + F11Creates a new pivot chart on a new worksheet
Hide pivot table itemCtrl + –

Ctrl + –

Hides an item within pivot table
Group pivot table itemsAlt + Shift + Right arrowCommand + Up arrow + KMakes a group of the items in a pivot table
Ungroup pivot table itemsAlt + Shift + Left arrowCommand + Up arrow + JUngroups the items in a pivot table
Select pivote tableCtrl + ACommand + ASelects the entire pivot table

Mouse shortcut keys in Excel

Mouse plays a major role in navigating and selecting various options in Excel. Here are some of the Excell shortcuts you can perform using a mouse:

ActionWindows shortcut keyMac shortcut keyResult
Zoom in / Zoom outCtrl + Mouse^ + MouseEasily zoom in and zoom out within a worksheet by scrolling the mouse wheel or the trackpad
Drag and copyCtrl + Drag⌥ + DragSelect and copies the cells
Drag and cutDragDragSelects and cuts the content from the cells
Drag and insertShift + DragUp arrow + DragInserts copied content to cells
Drag to worksheet

Alt + Drag

Command + DragSelects cell(s) and moves them to another worksheet in the same workbook
Drag to duplicate worksheetCtrl + Drag⌥ + DragSelects cell(s) and creates a duplicate worksheet with those cells