Excel for couchsurfingcook.com 365 Excel for couchsurfingcook.com 365 because that Mac Excel for the net Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel because that iPad Excel because that iPhone Excel because that Android tablets Excel for Android phones Excel for home windows Phone 10 Excel cell phone More...Less

Many users uncover that using an outside keyboard with key-board shortcuts for Excel helps them work an ext efficiently. Because that users v 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 key-board layout. Secrets for various other layouts can not correspond exactly to the tricks on a us keyboard.

You are watching: To quickly jump to the first cell in a worksheet press ____.

A plus sign (+) in a shortcut means that you must press multiple keys at the very same time.

A comma sign (,) in a shortcut way that you have to press multiple secrets in order.


This short article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows.


Notes: 

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


In this topic

Ribbon keyboard shortcuts

key-board shortcuts because that formatting cells

Frequently used shortcuts

This table list the most commonly used shortcuts in Excel.

To perform 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 to Insert tab

Alt+N

Bold

Ctrl+B

Center align cell contents

Alt+H, A, C

Go to Page Layout tab

Alt+P

Go to Data tab

Alt+A

Go come 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

peak of web page

Ribbon keyboard shortcuts

The ribbon groups related choices on tabs. For example, ~ above the Home tab, the Number group includes the Number Format option. Push the Alt key to display screen the ribbon shortcuts, called crucial Tips, as letter in small images next to the tabs and choices as displayed in the photo below.

*

You can integrate the crucial Tips letters with the Alt vital to do shortcuts called access Keys for 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. Push Alt again to watch KeyTips because that the options for the selected tab.

In Office 2013 and also Office 2010, most of the old Alt key menu shortcuts tho work, too. However, you need to understand the full shortcut. Because that example, push Alt, and also 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 key from an previously version that couchsurfingcook.com Office. If you recognize the entire crucial sequence, go ahead and also use it. If girlfriend don"t recognize the sequence, push Esc and also use vital Tips instead.

Use the accessibility keys for ribbon tabs

To go directly to a tab top top the ribbon, press among the following access keys. Added tabs may show up depending ~ above your selection in the worksheet.

To carry out this

Press

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

Alt+Q, then go into the search term.

Open the File page and use Backstage view.

Alt+F

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

Alt+H

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

Alt+N

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

Alt+P

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

Alt+M

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

Alt+A

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

Alt+R

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

Alt+W

top of web page

Work in the ribbon through the keyboard

To perform this

Press

Select the active tab ~ above the ribbon, and activate the access keys.

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

Move the emphasis to regulates on the ribbon.

Tab an essential 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 perform for a selected command.

Down arrowhead key

Open the menu for a selected button.

Alt+Down arrowhead key

When a food selection or submenu is open, move to the following command.

Down arrow key

Expand or fallen the ribbon.

Ctrl+F1

Open a paper definition menu.

Shift+F10

Or, on a windows keyboard, the Context key (between the ideal Alt and also right Ctrl keys)

Move to the submenu as soon as a main menu is open up or selected.

Left arrow key

top of page

Keyboard shortcuts because that navigating in cells

To carry out this

Press

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

Shift+Tab

Move one cell up in a worksheet.

Up arrowhead key

Move one cell down in a worksheet.

Down arrow key

Move one cabinet left in a worksheet.

Left arrowhead key

Move one cell appropriate in a worksheet.

Right arrow key

Move to the leaf of the present data region in a worksheet.

Ctrl+Arrow key

Enter the end mode, move to the following nonblank cabinet in the same shaft or row as the active cell, and turn off end mode. If the cells space blank, move to the critical cell in the row or column.

End, arrowhead key

Move to the critical cell on a worksheet, to the lowest supplied row the the rightmost supplied column.

Ctrl+End

Extend the choice of cells to the last provided cell top top the worksheet (lower-right corner).

Ctrl+Shift+End

Move to the cabinet in the upper-left corner of the home window when role Lock is turn on.

Home+Scroll Lock

Move to the start of a worksheet.

Ctrl+Home

Move one screen down in a worksheet.

Page Down

Move come the next sheet in a workbook.

Ctrl+Page Down

Move one screen to the appropriate in a worksheet.

Alt+Page Down

Move one display screen up in a worksheet.

Page Up

Move one screen 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 appropriate in a worksheet. Or, in a safeguarded worksheet, move between unlocked cells.

Tab key

Open the list of validation selections on a cabinet that has actually data validation option applied to it.

Alt+Down arrow key

Cycle with floating shapes, such as message boxes or images.

Ctrl+Alt+5, then the Tab key repeatedly

Exit the floating form navigation and return come the normal navigation.

Esc

Scroll horizontally.

Ctrl+Shift, climate scroll your mouse wheel up to go left, under to go right

Zoom in.

CTRL+ALT+=

Zoom out.

CTRL+ALT+-

height of page

Keyboard shortcuts for formatting cells

To perform this

Press

Open the layout Cells dialog.

Ctrl+1

Format fonts in the layout Cells dialog.

Ctrl+Shift+F or Ctrl+Shift+P

Edit the active cell and also put the insertion allude at the finish of that is contents. Or, if modifying is turned turn off for the cell, relocate the insertion allude into the formula bar. If modifying a formula, toggle suggest mode turn off or on for this reason you deserve to use arrow keys to produce 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 sign (-)

Enter the present time.

Ctrl+Shift+colon (:)

Enter the present date.

Ctrl+semi-colon (;)

Switch between displaying cell values or recipe in the worksheet.

Ctrl+grave accent (`)

Copy a formula indigenous the cell above the active 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 unique dialog.

Ctrl+Alt+V

Italicize text or eliminate italic formatting.

Ctrl+I or Ctrl+3

Bold message or eliminate bold formatting.

Ctrl+B or Ctrl+2

Underline text or remove underline.

Ctrl+U or Ctrl+4

Apply or eliminate strikethrough formatting.

Ctrl+5

Switch in 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 native the selected cells.

Ctrl+Shift+underline (_)

Display or hide the overview symbols.

Ctrl+8

Use the Fill down command to copy the contents and also format that the topmost cell of a selected range into the cells below.

Ctrl+D

Apply the basic number format.

See more: " Pretty Little Liars 15 : Toxic Ebook By Sara Shepard, Toxic By Sara Shepard

Ctrl+Shift+tilde sign (~)

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