Excel because that bsci-ch.org 365 Excel for bsci-ch.org 365 for Mac Excel because that the net Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 because that Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel for iPad Excel because that iPhone Excel for Android tablets 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 utilizing an external keyboard with keyboard shortcuts for Excel helps them work much more efficiently. For users v mobility or vision disabilities, keyboard shortcuts can be less complicated than making use of the touchscreen, and also are critical alternative to using a mouse. 


The shortcuts in this topic refer to the US keyboard layout. Tricks for other layouts could not correspond specifically to the keys on a us keyboard.

You are watching: Which of the following keys moves the insertion point to the end of data in a cell

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

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

This write-up describes the keyboard shortcuts, role keys, and also some other common shortcut keys in Excel because that Windows.


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

In this topic

Ribbon key-board shortcuts

keyboard shortcuts because that formatting cells

Frequently offered shortcuts

This table perform the most generally used shortcuts in Excel.

To perform this


Close a workbook


Open a workbook


Go come the Home tab


Save a workbook








Remove cell contents


Choose a fill color

Alt+H, H



Go come Insert tab




Center align cell contents

Alt+H, A, C

Go come Page Layout tab


Go to Data tab


Go come View tab


Open paper definition menu

Shift+F10, or

Context key

Add borders

Alt+H, B

Delete column

Alt+H, D, C

Go come Formula tab


Hide the selected rows


Hide the selected columns


optimal of web page

Ribbon key-board shortcuts

The ribbon groups related choices on tabs. For example, top top the Home tab, the Number group includes the Number Format option. Push the Alt key to display the ribbon shortcuts, called an essential Tips, as letters in tiny images alongside the tabs and alternatives as displayed in the image below.


You can incorporate the key Tips letters through the Alt an essential to do shortcuts called access Keys because that the ribbon options. Because that example, push Alt+H to open up the Home tab, and also Alt+Q to move to the Tell me or Search field. Press Alt again to watch KeyTips for the alternatives for the selected tab.

In Office 2013 and Office 2010, most of the old Alt key menu shortcuts quiet work, too. However, you require to know the full shortcut. For example, press Alt, and also then press among the old menu keys E (Edit), V (View), ns (Insert), and also so on. A notice pops up speak you"re making use of an access key from an earlier version that bsci-ch.org Office. If you know the entire vital sequence, walk ahead and use it. If friend don"t recognize the sequence, press Esc and also use vital Tips instead.

Use the accessibility keys because that ribbon tabs

To go directly to a tab ~ above the ribbon, press among the following access keys. Additional tabs may appear depending on your an option in the worksheet.

To carry out this


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

Alt+Q, then get in the find term.

Open the File page and use Backstage view.


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


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


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


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


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


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


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


peak of page

Work in the ribbon v the keyboard

To carry out this


Select the energetic tab on the ribbon, and activate the access keys.

Alt or F10. To relocate to a different tab, use accessibility keys or the arrowhead keys.

Move the focus to commands on the ribbon.

Tab key 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 arrowhead key

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

Down arrowhead key

Expand or please the ribbon.


Open a paper definition menu.


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

Move come the submenu when a main menu is open up or selected.

Left arrowhead key

peak of page

Keyboard shortcuts for navigating in cells

To carry out this


Move come the previous cabinet in a worksheet or the previous alternative in a dialog.


Move one cabinet 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 arrow key

Move one cell appropriate in a worksheet.

Right arrowhead key

Move come the sheet of the current data region in a worksheet.

Ctrl+Arrow key

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

End, arrow key

Move to the last cell top top a worksheet, come the lowest supplied row of the rightmost used column.


Extend the an option of cell to the last provided cell on the worksheet (lower-right corner).


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

Home+Scroll Lock

Move come the start of a worksheet.


Move one screen down in a worksheet.

Page Down

Move come the following sheet in a workbook.

Ctrl+Page Down

Move one display screen to the ideal in a worksheet.

Alt+Page Down

Move one display screen 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 cabinet to the best in a worksheet. Or, in a defended worksheet, move in between unlocked cells.

Tab key

Open the perform of validation options on a cabinet that has actually data validation option used to it.

Alt+Down arrow key

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

Ctrl+Alt+5, climate the Tab vital repeatedly

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


Scroll horizontally.

Ctrl+Shift, then scroll your mouse wheel up to go left, down to walk right

Zoom in.


Zoom out.


top of web page

Keyboard shortcuts because that formatting cells

To execute this


Open the format Cells dialog.


Format fonts in the layout Cells dialog.

Ctrl+Shift+F or Ctrl+Shift+P

Edit the energetic cell and also put the insertion point at the finish of that contents. Or, if editing and enhancing is turned off for the cell, relocate the insertion point into the formula bar. If editing and enhancing a formula, toggle suggest mode off or on for this reason you have the right to use arrowhead keys to produce a reference.


Insert a note

Open and edit a cell note



Insert a threaded comment

Open and also reply to a threaded comment



Open the Insert dialog come insert empty cells.

Ctrl+Shift+Plus authorize (+)

Open the Delete dialog to delete selected cells.

Ctrl+Minus sign (-)

Enter the present time.

Ctrl+Shift+colon (:)

Enter the current date.

Ctrl+semi-colon (;)

Switch between displaying cell values or formulas in the worksheet.

Ctrl+grave accent (`)

Copy a formula native the cell above the active cell right into the cabinet or the Formula Bar.

Ctrl+apostrophe (")

Move the selected cells.


Copy the selected cells.


Paste content at the insertion point, replacing any selection.


Open the Paste distinct dialog.


Italicize text 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 remove strikethrough formatting.


Switch in between hiding objects, displaying objects, and displaying placeholders because that objects.


Apply an overview border to the selected cells.

Ctrl+Shift+ampersand (&)

Remove the summary border from the selected cells.

Ctrl+Shift+underline (_)

Display or hide the overview symbols.


Use the Fill down command to copy the contents and also format of the topmost cabinet of a selected selection into the cell below.


Apply the general number format.

See more: Does Pat Sajak Wear A Hairpiece, Is Pat Sajak Actually Bald

Ctrl+Shift+tilde authorize (~)

Apply the currency format v two decimal locations (negative numbers in parentheses).