MsWord Shortcut Keys

Ms Word SHORTCUT KEYS

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Move cursor left	Ctrl + Left arrow key	Option + Left arrow key	Move cursor one word to the left
Move cursor right	Ctrl + Right arrow key	Option + Right arrow key	Move cursor one word to the right
Move cursor up	Ctrl + Up arrow key	Command + Up arrow key	Move the cursor up by one paragraph
Move cursor down	Ctrl + Down arrow key	Command + Down arrow key	Move cursor down by one paragraph
Move cursor to end of line	End	Command + Right arrow key + End	Move cursor to the end of the current line
Move cursor to beginning of line	Home	Command + Left arrow + Home	Move cursor to the beginning of the current line
Move  cursor screen top	Ctrl + Alt + Page up	Command + Home For MacBook: Command + Fn + Right arrow key	Takes the cursor to the top of the document
Move cursor to document bottom	Ctrl + Alt + Page down	Command + End On MacBook: Command + Fn + Left arrow key	Takes the cursor to the bottom of the document
Move cursor one screen up	Page up	Command + Page up  MacBook: Command + Up arrow key	Takes the cursor to one screen above the current one, if the document is long enough
Move cursor one screen down	Page down	Command + Page down MacBook: Command + Fn + Down arrow key	Takes the cursor one screen below the current one
Move cursor to next page’s top	Ctrl + Page down	Command + Page down  For MacBook: Command + Fn + Down arrow key	Moves the cursor to the top of the next page
Move cursor to top of previous page	Ctrl + Page up	Command + Page up On MacBook: Command + Fn + Up arrow key	Moves the cursor to the top of previous page
Move cursor to end of document	Ctrl + End	Command + End	Moves the cursor to the end of document
Move the cursor to beginning of document	Ctrl + Home	Command + Home	Moves the cursor to the beginning of document
Move cursor to the previous revision	Shift + F5	NA	Moves the cursor to the location of previous revision
Select floating shapes, text boxes and images	Shift + F5 + Tab	NA	Select and cycle through floating shapes, text boxes and images
Display ‘Go To’ dialog box	Ctrl + G	NA	Displays ‘Go To’ dialog box to navigate to specific locations

Select text and graphics

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Selext text	Shift + Arrow keys	Shift + Arrow keys	Selects text letter by letter
Select word to the left	Ctrl + Shift + Left Arrow key	Shift + Option + Left Arrow key	Selects all the text on the left
Select word to the right	Ctrl + Shift + Right Arrow key	Shift + Option + Right Arrow key	Selects all the text on the right
Select the beginning of current line	Shift + Home	Shift + Home	Selects the beginning of the current line from current position
Select the end of current line	Shift + End	Shift + End	Selects the end of the current line from current position
Select the beginning of paragraph	Ctrl + Shift + Up arrow key	Command + Shift + Up arrow key	Selects the beginning of the current paragraph from current position
Select the end of paragraph	Ctrl + Shift + Down arrow key	Command + Shift + Down arrow key	Selects the end of the current paragraph from current position
Select the top of the screen	Shift + Page up	Shift + Page up	Selects the top of the screen from the current position
Select the bottom of the screen	Shift + Page down	Shift + Page down	Selects the bottom of the screen from the current position
Select the beginning of the document	Ctrl + Shift + Home	Command + Shift + Home	Selects the beginning of the document from the current position
Select the end of the document	Ctrl + Shift + End	Command + Shift + End	Selects the end of the document from the current position
Select the bottom of the window	Ctrl + Shift + Page down key	Command + Shift + Option + Page down key	Selects the bottom of the window from the current position
Select whole document content	Ctrl + A	Command + A	Selects all the content in the document

Edit text and graphics

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Delete word on the left	Ctrl + Backspace	Command + Delete	Deletes one word to the left
Delete word on the right	Ctrl + Delete	Fn + Delete	Deletes one word to the right
Enable Office Clipboard	Alt + H, F, O	NA	Opens and enables the Clipboard task pane to copy and paste content between MS Office apps
Move content to specific location	F2 + Cursor + Enter	NA	Moves the selected content to a specific location through the cursor
Copy content to specific location	Shift + F2 + Cursor + Enter	NA	Copies the selected content to a specific location through the cursor
Define AutoText block	Alt + F3	NA	Enters content into AutoText block
Copy formatting	Ctrl + Shift + C	Command + Option + Shift + C	Copies the selected formatting
Paste formatting	Ctrl + Shift + V	Command + Option + Shift + V	Pastes the selected formatting
Copy header/footer from previous section	Alt + Shift + R		Copies the content of header or footer from a previous section
Display the Replace dialog box	Ctrl + H	Ctrl + H	Displays the Replace dialog box to find and replace text or any specific formatting
Display the Object dialog box	Alt + N, J, J	NA	Displays the Object dialog box insert a file object into the document
Insert SmartArt graphic	Alt + N, M	Command + Ctrl + M	Inserts a SmartArt graphic into the document
Insert WordArt graphic	Alt + N, W	Command + Ctrl + W	Inserts a WordArt graphic into the document

Work with tables

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Move to next cell in a row and select content	Tab key	Tab key	Moves to the next cell and selects the content contained in it
Move to previous cell in a row and select content	Shift + Tab	Shift + Tab	Moves to the previous cell and selects the content contained in it
Move to first cell in row	Alt + Home	Control + Home	Move to the first cell in a row
Move to last cell in row	Alt + End	Control + End	Move to the last cell in a row
Move to the first cell in column	Alt + Page up	Control + Page up	Move to the first cell in a column
Move to the last cell in a column	Alt + Page down	Control + Page down	Move to the last cell in a column
Move to previous row	Up arrow key	NA	Moves to the previous row
Move to next row	Down arrow key	NA	Moves to the next row
Move one row up	Alt + Shift + Up arrow key	NA	Moves to one row above
Move one row down	Alt + Shift + Down arrow key	NA	Moves to one row below

Work with text in other languages

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Display Language dialog box	Alt + R, U, L	NA	Displays the Language dialog box to set proofing language
Set default languages	Alt + R, L	NA	Sets the default language

Work with web content

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Insert hyperlink	Ctrl + K	Command + K	Inserts a link to website in the document
Go back one page	Alt + Left arrow key	NA	Goes back one page
Go forward one page	Alt + Right arrow key	NA	Goes forward one page
Refresh page	F9	NA	Refreshes the page contents

Work with mail merge and fields

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Preview mail merge	Alt + Shift + K	NA	Previews the mail merge
Merge document	Alt + Shift + N	NA	Merges the documents
Print merged document	Alt + Shift + M	NA	Prints the merged documents
Edit mail-merge document	Alt + Shift + E	NA	Edits a mail-merged document
Insert a merge field	Alt + Shift + F	NA	Inserts a merge field
Insert DATE field	Alt + Shift + D	Ctrl + Shift + D	Inserts a DATE field in the document
Insert LISTNUM field	Ctrl + Alt + L	Command + Option + Shift + L	Insert a LISTNUM field in the document
Insert PAGE field	Alt + Shift + P	Ctrl + Shift + P	Inserts a PAGE field in the document
Insert TIME field	Alt _ Shift + T	Ctrl + Shift + T	Inserts a TIME field in the document
Insert empty field	Ctrl + F9	Command + F9	Inserts an empty field in the document
Update selected fields	F9	F9	Updates the selected fields
Switch between selected filed code and its result	Shift + F9	Shift + F9	Switches between selected field code and its result
Unlink a field	Ctrl + Shift + F9	NA	Unlinks a field
Switch between all filed code and its result	Alt + F9	Option + F9	Switches between all field codes and its result
Go to next field	F11	NA	Goes to the next field
Go to previous field	Shift + F11	NA	Goes to the previous field
Lock field	Ctrl + F11	Command + F11	Locks a field
Unlock a field	Ctrl + Shift + F11	Command + Shift + F11	Unlocks a locked field

Ribbon Keyboard shortcuts

ACTION	WINDOWS SHORTCUT KEY	RESULT
Display ribbon shortcuts	Alt / F10	Displays the ribbon shortcut keys within the document
Move to commands on the ribbon	Tab / Shift + Tab	Moves to the commands section on the ribbon
Move between commands on the ribbon	Ctrl + Left arrow / right arrow key	Move between different commands on the ribbon
Show Tooltip	Ctrl + Shift + F10	This shortcut shows the Tooltip for the ribbon specific element
Activate selected button	Spacebar / Enter	Activates the selected button on the ribbon
Open the menu for selected buuton	Alt + Down arrow key	Opens up the menu for a selected button in the ribbon
Move to submenu within a menu	Left arrow key	When opened a menu for the selected button, this shortcut further opens the submenu
Expand or minimise ribbon	Ctrl + F1	Expands or minimises the ribbon
Open Home tab from the ribbon	Alt + H	Opens the Home tab from the ribbon
Open File tab from the ribbon	Alt + F	Opens the File tab from the ribbon
Open Insert tab from the ribbon	Alt + N	Opens the Insert tab from the ribbon
Open Design tab from the ribbon	Alt + G	Opens the Design tab from the ribbon
Open Layout tab from the ribbon	Alt + P	Opens the Layout tab from the ribbon
Open References tab from the ribbon	Alt + S	Opens the References tab from the ribbon
Open Review tab from the ribbon	Alt + R	Opens the Review tab from the ribbon
Open View tab from the ribbon	Alt + W	Opens the View tab from the ribbon

Work with reference citations and indexing

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Mark table of content entry	Alt + Shift + O	NA	Marks a table of contents entry
Mark a table of citation	Alt + Shift + I	NA	Marke a table of citation entry
Choose citation options	Alt + Shift + F12, Spacebar	NA	Chooses from different citation options
Mark index entry	Alt + Shift + X	NA	Marks an index entry
Insert footnote	Ctrl + Alt + F	Command + Option + F	Inserts a footnote into the document
Insert endnote	Ctrl + Alt + D	Command + Option + E	Inserts an endnote into the document
Go to next footnote	Alt + Shift + >	NA	Goes to the next footnote
Go to previous footnote	Alt + Shift + <	NA	Goes to the previous footnote

Review a document

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Insert comments	Ctrl + Alt + M	Command + Option + A	This shortcut adds comments into the document
Toggle changing tracking	Ctrl + Shift + E	Command + Shift + E	Turn change tracking on or off
Close Reviewing Pane	Alt + Shift + C	NA	Closes the Reviewing Pane
Move to the start of the comment	NA	Home	Moves directly to the beginning of a comment
Open Thesaurus	Shift + F7	Shift + F7	Simply opens Thesaurus

Work with document view

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Switch to Read Mode view	Alt + W, F	NA	This shortcut switches to the Read Mode view
Switch to Print Layout view	Ctrl + Alt + P	NA	This shortcut switches to the Print Layout view
Switch to Outline view	Ctrl + Alt + O	NA	This shortcut switches to the Outline view mode
Switch to Draft view	Ctrl + Alt + N	NA	This shortcut switches to the Draft view mode

Useful function key shortcuts

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Display Word help task pane	F1	NA	Displays the Word help task pane for finding resolutions to queries
Move selected text or graphic	F2	NA	Moves the selected text or graphic to a new location
Switch between upper, lower and title case	F3	NA	Switches between upper, lower and title case
Repeat command	F4	NA	Repeats the previous command or action such as applying formatting to text
Go To dialog box	F5	NA	Displays the Go To dialog box
Switch between task pane, status and ribbon	F6	NA	Switches between the task pane, status and ribbon
Display Editor task pane	F7	NA	Displays the Editor task pane to check grammar and spelling mistakes in the document
Extends selection	F8	NA	Extends the selection to the whole sentence
Update selected fields	F9	NA	Updates the selected field in a document
Toggle KeyTips	F10	NA	Toggles on or off KeyTips
Move to next field	F11	NA	Moves over to the next field
Display Save As dialog box	F12	Command + Shift + S	Displays the Save As dialog to save the changes and create a new file of the Word file

Preview and print documents

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Print document	Ctrl + P	Command + P	Prints the current document
Switch to print preview	Ctrl + Alt + I	Ctrl + Alt + I	Switches to the print preview mode
Move around the preview page when zoomed	Arrow keys	Arrow keys	Move around the preview page when zoomed in
Move between print preview pages	Page Up / Page Down	Page Up / Page Down	Move through the different pages of the document while in the preview mode
Move to first page in preview mode	Ctrl + Home	NA	Directly move to the first page of the document in preview mode
Move to last page in preview mode	Ctrl + End	NA	Directly move to the last page of the document in preview mode

ACTION	WINDOWS SHORTCUT KEY	MAC SHORTCUT KEY	RESULT
Open existing document	Ctrl + O	Command + O	Takes to the document Open page
New document	Ctrl + N	Command + N	Takes to the new document creation screen
Save	Ctrl + S	Command + S	Saves the current project
Close	Ctrl + W	Command + W/F4	Closes the current document
Cut	Ctrl + X	Command + X/F2	Cut the selected content to clipboard
Copy	Ctrl + C	Command + C/F3	Copy selected content to clipboard
Paste	Ctrl + V	Command + V/F4	Paste selected content to clipboard
Select all	Ctrl + A	Command + A	Select all the content of the document
Bold text	Ctrl + B	Command + B	Make selected text appear bold
Italic text	Ctrl + I	Command + I	Makes the selected text appear Italic
Underline	Ctrl + U	Command + U	Apply underline format to selected area
Decrease font size	Ctrl + [ (Left bracket)	Command + Shift + < (Left angle bracket)	Decreases the font size of the selected text
Increase font size	Ctrl + ] (Right bracket)	Command + Shift + > (right angle bracket)	Increases font size by one point
Center the text	Ctrl + E	Command + E	Align the selected paragraph to center
Alight left	Ctrl + L	Command + L	Align the selected section to left
Align right	Ctrl + R	Command + R	Align the selected text to left
Cancel command	Esc	NA	Cancel a command assigned
Undo	Ctrl + Z	Command + Z/F1	Undo previous action
Redo	Ctrl + Y	Command + Y	Redo previous action
Zoom	Alt + W, Q (Adjust zoom level accordingly)	Command + + (zoom in)  Command + – (zoom out)	Adjust Zoom levels of document
Split	Ctrl + Alt + S		Split document view
Revert split view	Alt + Shift + C or Ctrl + Alt + S		Revert back from document split view

Excel Shortcut Keys

 

 Useful Excel Shortcuts

 

General

Open help

F1

 

Undo last action

Ctrl + Z

 

Redo last action

Ctrl + Y

 

Copy selection

Ctrl + C

 

Repeat last action

F4

 

Cut selection

Ctrl + X

 

Paste content from clipboard

Ctrl + V

 

Display the Paste Special dialog box

Ctrl + Alt + V

 

Display find and replace with Find tab selected

Ctrl + F

 

Display find and replace with Replace tab selected

Ctrl + H

 

Find previous match (after initial Find)

Ctrl + Shift + F4

 

Find next match (after initial Find)

Shift + F4

 

Insert embedded chart

Alt + F1

 

Insert chart in new sheet

F11

 

Toggle Autofilter

Ctrl + Shift + L

 

Activate filter

Alt + ↓

 

Create table

Ctrl + T OR Ctrl + L

 

Select table row

Shift + Space

 

Select table column

Ctrl + Space

 

Select table (when active cell is in table)

Ctrl + A

 

Clear slicer filter

Alt + C

 

Run Spellcheck

F7

 

Open Thesaurus

Shift + F7

 

Open Macro dialog box

Alt + F8

 

Open VBA Editor

Alt + F11

 

Duplicate object, formula, text

Ctrl + D

 

Snap to grid (whilst dragging)

Alt

 

Hide or show objects

Ctrl + 6

 

Open Modify Cell Style dialog box

Alt + '

 

Show right-click menu

Shift + F10

 

Display control menu

Alt Space

 

Worksheet

 

Insert new worksheet

Shift + F11

 

Go to next worksheet

Ctrl + PgDn

 

Go to previous worksheet

Ctrl + PgUp

 

Rename current worksheet

Alt + O , H R

 

Delete current worksheet

Alt + E , L

 

Move current worksheet

Alt + E , M

 

Move between the worksheet, Ribbon, task pane and zoom controls in a worksheet that has been split

F6 OR Shift + F6

 

Select adjacent worksheets

Ctrl + Shift + PgUp/PgDn

 

Select non-adjacent worksheets

Ctrl + Click

 

Toggle scroll lock

ScrLk

 

Toggle full screen

Ctrl + Shift + F1

 

Print

Ctrl + P

 

Open print preview window

Ctrl + F2

 

Set print area

Alt + P , R S

 

Clear print area

Alt + P , R C

 

Zoom in

Ctrl + Mouse Wheel Up

 

Zoom out

Ctrl + Mouse Wheel Down

 

Protect sheet

Alt + R , P S

Workbook

Create new workbook

Ctrl + N

 

Open workbook

Ctrl + O

 

Save workbook

Ctrl + S

 

Save as

F12

 

Go to next workbook

Ctrl + Tab

 

Go to previous workbook

Ctrl + Shift + Tab

 

Minimize current workbook window

Ctrl + F9

 

Maximize current workbook window

Ctrl + F10

 

Protect workbook

Alt + R , P W

 

Close current workbook

Ctrl + F4

 

Close Excel

Alt + F4

Ribbon

Expand or collapse ribbon

Ctrl + F1

 

Activate access keys

Alt

Move through Ribbon tabs and groups

→ ← ↑ ↓

Activate or open selected control

Space OR Enter

 

Confirm control change

Enter

 

Get help on selected control

F1

 

Drag and Drop (After Selecting Cells)

Drag and cut

Drag

Drag and copy

Ctrl + Drag

 

Drag and insert

Shift + Drag

 

Drag and insert copy

Ctrl + Shift + Drag

 

Drag to worksheet

Alt + Drag

 

Drag to duplicate worksheet

Ctrl + Drag

 

Navigation

Move one cell right

→

Move one cell left

←

Move one cell up

↑

Move one cell down

↓

 

Move one screen right

Alt + PgDn

 

Move one screen left

Alt + PgUp

 

Move one screen up

PgUp

 

Move one screen down

PgDn

 

Move to right edge of data region

Ctrl + →

 

Move to left edge of data region

Ctrl + ←

 

Move to top edge of data region

Ctrl + ↑

 

Move to bottom edge of data region

Ctrl + ↓

 

Move to beginning of row

Home

Move to last cell in worksheet that contains data

Ctrl + End

 

Move to first cell in worksheet

Ctrl + Home

 

Turn End mode on

End

 

Active Cell

Select active cell (when multiple cells already selected)

Shift + Backspace

 

Show the active cell on worksheet

Ctrl + Backspace

 

Move active cell clockwise to corners of selection

Ctrl + .

 

Move active cell down in selection - wrap to next column

Enter

 

Move active cell up in selection - wrap to previous column

Shift + Enter

 

Move active cell right in a selection - wrap to next row

Tab

 

Move active cell left in a selection - wrap to previous row

Shift + Tab

Selection

Select entire row

Shift + Space

 

Select entire column

Ctrl + Space

 

Select current region if worksheet contains data. Press again to select current region and summary rows. Press again to select entire worksheet.

Ctrl + A

 

Expand selection

Shift + Click

 

Add non-adjacent cells to selection

Ctrl + Click

 

Move right between non-adjacent selections

Ctrl + Alt + →

 

Move left between non-adjacent selections

Ctrl + Alt + ←

 

Toggle 'Add to Selection' mode

Shift + F8

 

Exit 'Add to Selection' mode

Esc

Extend Selection

Extend selection right

Shift + →

 

Extend selection left

Shift + ←

 

Extend selection up

Shift + ↑

 

Extend selection down

Shift + ↓

 

Extend the selection to the last cell on the right that contains data, or to the next cell that contains data, or to the last column

Ctrl + Shift + →

 

Extend the selection to the last cell on the left that contains data, or to the next cell that contains data, or to the first column

Ctrl + Shift + ←

 

Extend the selection to the last cell up that contains data, or to the next cell that contains data, or to the first row

Ctrl + Shift + ↑

 

Extend the selection to the last cell down that contains data, or to the next cell that contains data, or to the last row

Ctrl + Shift + ↓

 

Extend selection up one screen

Shift + PgUp

 

Extend selection down one screen

Shift + PgDn

 

Extend selection right one screen

Alt + Shift + PgDn

 

Extend selection left one screen

Alt + Shift + PgUp

 

Extend selection to start of row(s)

Shift + Home

 

Extend selection to first cell in worksheet

Ctrl + Shift + Home

 

Extend selection to last cell in worksheet

Ctrl + Shift + End

 

Toggle 'Extend Selection' mode

F8

 

Cancel 'Extend Selection' mode

Esc

 

Select Special

Display 'Go To' dialog box

Ctrl + G OR F5

 

Select cells with comments

Ctrl + Shift + O

 

Select current region around active cell

Ctrl + Shift + *

 

Select current region

Ctrl + A

 

Select direct precedents

Ctrl + [

 

Select all precedents

Ctrl + Shift + {

 

Select direct dependents

Ctrl + ]

 

Select all dependents

Ctrl + Shift + }

 ct visible cells onlyAlt + ;dit Mode

Edit the active cell

F2

 

Insert or edit comment

Shift + F2

 

Delete comment

Shift + F10 , M

 

Cancel editing

Esc

 

Select one character right

Shift + →

 

Select one character left

Shift + ←

 

Move one word right

Ctrl + →

 

Move one word left

Ctrl + ←

 

Select one word right

Ctrl + Shift + →

 

Select one word left

Ctrl + Shift + ←

 

Select to beginning of cell

Shift + Home

 

Select to end of cell

Shift + End

 

Delete to end of line

Ctrl + Delete

 

Delete character to left of cursor

Backspace

 

Delete character to right of cursor

Delete

 

Start a new line in the same cell

Alt + Enter 

 

Entering Data

Enter data and move down

Enter

 

Enter data and move up

Shift + Enter

 

Enter data and move right

Tab

 

Enter data and move left

Shift + Tab

 

Enter data and stay in same cell

Ctrl + Enter

 

Enter same data in multiple cells (after copying, then selecting cells)

Enter

 

Insert current date

Ctrl + ;

 

Insert current time

Ctrl + Shift + :

 

Fill down from cell above

Ctrl + D

 

Fill right from cell on left

Ctrl + R

 

Copy formula from cell above (formula is exact copy)

Ctrl + '

 

Copy value from cell above

Ctrl + Shift + "

 

Insert hyperlink

Ctrl + K

 

Display AutoComplete list

Alt + ↓

 

Flash fill

Ctrl + E

Formatting

Format cells

Ctrl + 1

 

Display Format Cells with Font tab selected

Ctrl + Shift + F

 

Apply or remove bold

Ctrl + B

 

Apply or remove italics

Ctrl + I

 

Apply or remove underscore

Ctrl + U

 

Apply or remove strikethrough

Ctrl + 5

 

Align center

Alt + H , A C

 

Align left

Alt + H , A L

 

Align right

Alt + H , A R

 

Indent

Alt + H , 6

 

Remove indent

Alt + H , 5

 

Wrap text

Alt + H , W

 

Align top

Alt + H , A T

 

Align middle

Alt + H , A M

 

Align bottom

Alt + H , A B

 

Increase font size one step

Alt + H , F G

 

Decrease font size one step

Alt + H , F K

Number Formatting

Apply general format

Ctrl + Shift + ~

 

Apply number format

Ctrl + Shift + !

 

Apply time format

Ctrl + Shift + @

 

Apply date format

Ctrl + Shift + #

 

Apply currency format

Ctrl + Shift + $

 

Apply percentage format

Ctrl + Shift + %

 

Apply scientific format

Ctrl + Shift + ^

Borders

Open list of border styles from Ribbon

Alt + H , B

 

Add border around selected cells

Ctrl + Shift + &

 

Add or remove right border

Alt + H , B R

 

Add or remove left border

Alt + H , B L

 

Add or remove top border

Alt + H , B P

 

Add or remove bottom border

Alt + H , B O

 

Add all borders to all cells in selection

Alt + H , B A

 

Remove borders

Ctrl + Shift + -

Formulas

Begin entering a formula

= OR +

 

Toggle absolute and relative references (in cell edit mode)

F4

 

Open the Insert Function Dialog Box

Shift + F3

 

Autosum

Alt + =

 

Toggle displaying formulas on and off

Ctrl + `

 

Insert function arguments

Ctrl + Shift + A

 

Enter array formula

Ctrl + Shift + Enter

 

Calculate worksheets

F9

 

Calculate active worksheet

Shift + F9

 

Force calculate all worksheets

Ctrl + Alt + F9

 

Evaluate part of a formula (in cell edit mode)

F9

 

Expand or collapse the formula bar

Ctrl + Shift + U

 

Display function arguments dialog box

Ctrl + A

 

Open Name Manager

Ctrl + F3

 

Create name from values in row(s)/column(s)

Ctrl + Shift + F3

 

Paste name into formula

F3

 

Accept function with auto-complete

Tab

Rows and Columns

Display Insert Dialog box

Ctrl + +

 

Insert selected number of rows

Ctrl + +

 

Insert selected number of columns

Ctrl + +

 

Display Delete dialog box

Ctrl + -

 

Delete selected number of rows

Ctrl + -

 

Delete selected number of columns

Ctrl + -

 

Delete contents of selected cells

Delete

 

Hide columns

Ctrl + 0

 

Hide rows

Ctrl + 9

 

Unhide rows

Ctrl + Shift + 9

 

Group rows or columns (with rows/columns selected)

Alt + Shift + →

 

Ungroup rows or columns (with rows/columns selected)

Alt + Shift + ←

 

Open Group Dialog Box (no rows/cols selected)

Alt + Shift + →

 

Open Ungroup Dialog Box

Alt + Shift + ←

 

Hide or show outline symbols

Ctrl + 8

Pivot Tables

Create pivot table

Alt + N , V

 

Select entire pivot table

Ctrl + A

 

Group pivot table items

Alt + Shift + →

 

Ungroup pivot table items

Alt + Shift + ←

 

Hide (filter out) pivot table item

Ctrl + -

 

Unhide (clear filter on) pivot table item

Alt + H , S C

 

Insert pivot chart

Alt + N , S Z C

Dialog Boxes

Move to next control

Tab

 

Move to previous control

Shift + Tab

 

Move to next tab

Ctrl + Tab

 

Move to previous tab

Ctrl + Shift + Tab

 

Accept and apply

Enter

 

Check and uncheck box

Space

 

Cancel and close the dialog box

Esc