This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Microsoft Excel for Windows. This includes the access keys that you can use for Ribbon commands. Note: • These shortcuts refer to the US keyboard layout.

How to install revit for mac devices. Move to the edge of the current data region in a worksheet. End, arrow key. Enter End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column.

Keys for other layouts might not correspond exactly to the keys on a US keyboard. • If a shortcut requires pressing two or more keys at the same time, this topic separates the keys with a plus sign (+).

If you have to press one key immediately after another, the keys are separated by a comma (,). TIPS: • To keep this reference available when you work, you may want to print this topic.

To print this topic, press CTRL+P. • To see an online workbook with this information,. This workbook lets you scroll, sort, and filter for any key combination. And, you can also download it. • Get these keyboard shortcuts in a Word document at this link: Frequently used shortcuts If you're new to the Ribbon, the information in this section can help you understand the Ribbon's keyboard shortcut model. The Ribbon comes with new shortcuts, called Key Tips, which you can make appear when you press the Alt key. The Ribbon groups related commands on tabs.

For example, on the Home tab, the Number group includes the Number Format command. This table lists the most frequently used shortcuts in Excel 2016.

The content area in the Excel workbook is generally small. The ribbon area occupies the top portion of excel containing tool icons and text descriptions for each menu tabs. When you have a larger excel sheets, you should get rid of the ribbon area to get convenient space. It also makes sense to show or hide that ribbon when you needed. In this article let us discuss how to show or hide ribbon in Excel on Windows and MacBook.

Though we have explained with Excel, all these tricks will work on all Microsoft Office applications like Excel, Word and PowerPoint. Related: Show or Hide Ribbon in Windows 1. Use Arrow Button The easiest way is to click the small up arrow shown at the right end of the ribbon. This will hide the ribbon showing all the menu items, thus allowing to have some visible area for cells. No Collapse Ribbon Option Here comes the use of handy. Simply press 'Ctrl + F1' keys to toggle the ribbon on or off.

This means you can hide and show the ribbon by pressing these shortcut keys. We recommend to use this shortcut keys instead of using the arrow or right click to hide ribbon. This should also work on Word, PowerPoint and all Microsoft applications.

Auto Hide Ribbon You can also automatically hide the ribbon and show only when you click on the top bar. Click on the arrow button showing next to minimize icon.