Excel for princetoneclub.org 365 Excel because that princetoneclub.org 365 because that Mac Excel because that the web Excel 2021 Excel 2021 because that Mac Excel 2019 Excel 2019 because that Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel because that iPad Excel for iPhone Excel because that Android tablet computers Excel 2010 Excel 2007 Excel for Mac 2011 Excel for Android phones Excel for home windows Phone 10 Excel mobile More...Less

Many users uncover that making use of an exterior keyboard with keyboard shortcuts because that Excel help them work an ext efficiently. Because that users through mobility or vision disabilities, key-board shortcuts deserve to be simpler than utilizing the touchscreen, and also are crucial alternative to utilizing a mouse. 


Notes: 

The shortcuts in this topic describe the US keyboard layout. Keys for other layouts can not correspond specifically to the secrets on a united state keyboard.

You are watching: The notes pane is ____ until you tap or click the notes button on the status bar to open the pane.

A plus authorize (+) in a shortcut way that you have to press multiple tricks at the same time.

A comma authorize (,) in a shortcut way that you should press multiple keys in order.


This post describes the keyboard shortcuts, duty keys, and some other usual shortcut tricks in Excel because that Windows.


Notes: 

To quickly discover a shortcut in this article, you deserve to use the Search. Press Ctrl+F, and then kind your search words.


In this topic

Ribbon keyboard shortcuts

keyboard shortcuts for formatting cells

Frequently supplied shortcuts

This table perform the most frequently used shortcuts in Excel.

To execute this

Press

Close a workbook

Ctrl+W

Open a workbook

Ctrl+O

Go to the Home tab

Alt+H

Save a workbook

Ctrl+S

Copy

Ctrl+C

Paste

Ctrl+V

Undo

Ctrl+Z

Remove cabinet contents

Delete

Choose a to fill color

Alt+H, H

Cut

Ctrl+X

Go come Insert tab

Alt+N

Bold

Ctrl+B

Center align cell contents

Alt+H, A, C

Go come Page Layout tab

Alt+P

Go to Data tab

Alt+A

Go to View tab

Alt+W

Open paper definition menu

Shift+F10, or

Context key

Add borders

Alt+H, B

Delete column

Alt+H, D, C

Go to Formula tab

Alt+M

Hide the selected rows

Ctrl+9

Hide the selected columns

Ctrl+0

optimal of page

Ribbon keyboard shortcuts

The ribbon groups related options on tabs. For example, top top the Home tab, the Number group consists of the Number Format option. Press the Alt crucial to display screen the ribbon shortcuts, called crucial Tips, as letters in small images beside the tabs and alternatives as presented in the image below.

*

You can integrate the vital Tips letters through the Alt key to do shortcuts called accessibility Keys because that the ribbon options. Because that example, press Alt+H to open up the Home tab, and Alt+Q to move to the Tell me or Search field. Press Alt again to check out KeyTips because that the options for the selected tab.

In Office 2013 and Office 2010, many of the old Alt key menu shortcuts still work, too. However, you need to recognize the full shortcut. For example, press Alt, and then press one of the old menu keys E (Edit), V (View), ns (Insert), and also so on. A notification pops up speak you"re utilizing an access an essential from an previously version of princetoneclub.org Office. If you know the entire key sequence, walk ahead and use it. If girlfriend don"t understand the sequence, push Esc and also use crucial Tips instead.

Use the accessibility keys for ribbon tabs

To go directly to a tab on the ribbon, press one of the following access keys. Additional tabs may show up depending top top your an option in the worksheet.

To do this

Press

Move to the Tell me or Search field on the Ribbon and form a find term for help or aid content.

Alt+Q, then enter the search term.

Open the File page and also use Backstage view.

Alt+F

Open the Home tab and also format text and also numbers and use the uncover tool.

Alt+H

Open the Insert tab and also insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes.

Alt+N

Open the Page Layout tab and also work with themes, web page setup, scale, and alignment.

Alt+P

Open the Formulas tab and also insert, trace, and customize functions and calculations.

Alt+M

Open the Data tab and also connect to, sort, filter, analyze, and work with data.

Alt+A

Open the Review tab and check spelling, include notes and also threaded comments, and protect sheets and also workbooks.

Alt+R

Open the View tab and also preview page breaks and layouts, show and also hide gridlines and also headings, collection zoom magnification, control windows and also panes, and also view macros.

Alt+W

top of web page

Work in the ribbon with the keyboard

To execute this

Press

Select the energetic tab ~ above the ribbon, and activate the accessibility keys.

Alt or F10. To move to a different tab, use access keys or the arrow keys.

Move the emphasis to commands on the ribbon.

Tab crucial or Shift+Tab

Move down, up, left, or right, respectively, amongst the items on the Ribbon.

Arrow keys

Activate a selected button.

Spacebar or Enter

Open the list for a selected command.

Down arrow key

Open the food selection for a selected button.

Alt+Down arrow key

When a menu or submenu is open, move to the next command.

Down arrow key

Expand or please the ribbon.

Ctrl+F1

Open a paper definition menu.

Shift+F10

Or, top top a windows keyboard, the Context an essential (between the appropriate Alt and also right Ctrl keys)

Move to the submenu once a main menu is open or selected.

Left arrowhead key

height of web page

Keyboard shortcuts for navigating in cells

To execute this

Press

Move to the previous cabinet in a worksheet or the previous choice in a dialog.

Shift+Tab

Move one cabinet up in a worksheet.

Up arrow key

Move one cell under in a worksheet.

Down arrow key

Move one cell left in a worksheet.

Left arrowhead key

Move one cell ideal in a worksheet.

Right arrowhead key

Move come the edge of the present data region in a worksheet.

Ctrl+Arrow key

Enter the finish mode, move to the following nonblank cabinet in the same tower or row as the energetic cell, and turn off end mode. If the cells are blank, move to the critical cell in the heat or column.

End, arrow key

Move come the critical cell ~ above a worksheet, come the lowest used row of the rightmost supplied column.

Ctrl+End

Extend the selection of cell to the last provided cell ~ above the worksheet (lower-right corner).

Ctrl+Shift+End

Move come the cabinet in the upper-left corner of the window when role Lock is rotate on.

Home+Scroll Lock

Move come the start of a worksheet.

Ctrl+Home

Move one screen down in a worksheet.

Page Down

Move come the following sheet in a workbook.

Ctrl+Page Down

Move one screen to the best in a worksheet.

Alt+Page Down

Move one display up in a worksheet.

Page Up

Move one display to the left in a worksheet.

Alt+Page Up

Move to the previous paper in a workbook.

Ctrl+Page Up

Move one cell to the ideal in a worksheet. Or, in a safeguarded worksheet, move between unlocked cells.

Tab key

Open the perform of validation selections on a cell that has data validation option applied to it.

Alt+Down arrow key

Cycle through floating shapes, together as text boxes or images.

Ctrl+Alt+5, then the Tab crucial repeatedly

Exit the floating form navigation and return to the regular navigation.

Esc

Scroll horizontally.

Ctrl+Shift, climate scroll your computer mouse wheel as much as go left, down to walk right

Zoom in.

CTRL+ALT+=

Zoom out.

CTRL+ALT+-

optimal of web page

Keyboard shortcuts for formatting cells

To do this

Press

Open the format Cells dialog.

Ctrl+1

Format fonts in the format Cells dialog.

Ctrl+Shift+F or Ctrl+Shift+P

Edit the energetic cell and also put the insertion suggest at the finish of that contents. Or, if modifying is turned off for the cell, move the insertion point into the formula bar. If modifying a formula, toggle suggest mode off or on for this reason you deserve to use arrow keys to develop a reference.

F2

Insert a note

Open and also edit a cabinet note

Shift+F2

Shift+F2

Insert a threaded comment

Open and also reply come a threaded comment

Ctrl+Shift+F2

Ctrl+Shift+F2

Open the Insert dialog come insert blank cells.

Ctrl+Shift+Plus sign (+)

Open the Delete dialog come delete selected cells.

Ctrl+Minus authorize (-)

Enter the existing time.

Ctrl+Shift+colon (:)

Enter the present date.

Ctrl+semi-colon (;)

Switch in between displaying cell worths or recipe in the worksheet.

Ctrl+grave accent (`)

Copy a formula native the cell over the energetic cell into the cell or the Formula Bar.

Ctrl+apostrophe (")

Move the selected cells.

Ctrl+X

Copy the selected cells.

Ctrl+C

Paste content at the insertion point, replacing any selection.

Ctrl+V

Open the Paste special dialog.

Ctrl+Alt+V

Italicize message or eliminate italic formatting.

Ctrl+I or Ctrl+3

Bold text or eliminate bold formatting.

Ctrl+B or Ctrl+2

Underline text or eliminate underline.

Ctrl+U or Ctrl+4

Apply or eliminate strikethrough formatting.

Ctrl+5

Switch between hiding objects, displaying objects, and displaying placeholders for objects.

Ctrl+6

Apply an outline border to the selected cells.

Ctrl+Shift+ampersand (&)

Remove the synopsis border from the selected cells.

Ctrl+Shift+underline (_)

Display or hide the outline symbols.

Ctrl+8

Use the Fill under command come copy the contents and also format the the topmost cell of a selected variety into the cells below.

Ctrl+D

Apply the general number format.

See more: Star Wars Commander Base Layout Level 5 Base Layouts, Best Base Layout Level 5

Ctrl+Shift+tilde authorize (~)

Apply the currency format v two decimal areas (negative number in parentheses).