Notes: • To keep this reference available when you work, you may want to print this topic. To print this topic, press Ctrl+P. • Download our quick tips guide. • Get these keyboard shortcuts in a Word document: 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. Note: If an action that you use often does not have a shortcut key, you can to create one. Keyboard access to the ribbon 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. To display a tab on the Ribbon, press the key for the tab—for example, press the letter N for the Insert tab or M for the Formulas tab. This makes all the Key Tip badges for that tab's buttons appear, as shown in the following image.

Microsoft Excel - Keyboard shortcuts for Mac Excel. This topic itemizes all keyboard shortcuts for Excel 2016 for Mac. Keyboard shortcuts allow you to quickly complete commands and functions without using a mouse. For information about changing the key assignment of a keyboard shortcut, see Mac Help for your version of the Mac OS or see.

Then, press the key for the button you want. Will my old shortcuts still work? Keyboard shortcuts that begin with Ctrl will still work in Microsoft Excel 2013. For example, Ctrl+C still copies to the clipboard, and Ctrl+V still pastes from the clipboard.

Most of the old Alt+ menu shortcuts still work, too. However, you need to know the full shortcut from memory — there are no screen reminders of what letters to press. For example, try pressing Alt, and then press one of the old menu keys E (Edit), V (View), I (Insert), and so on. A box pops up saying you're using an access key from an earlier version of Microsoft Office. If you know the entire key sequence, go ahead and initiate the command.

If you don't know the sequence, press Esc and use Key Tip badges instead. Ctrl combination shortcut keys Key Description Ctrl+PgDn Switches between worksheet tabs, from left-to-right. Ctrl+PgUp Switches between worksheet tabs, from right-to-left. Ctrl+Shift+& Applies the outline border to the selected cells. Ctrl+Shift_ Removes the outline border from the selected cells.

Ctrl+Shift+~ Applies the General number format. Ctrl+Shift+$ Applies the Currency format with two decimal places (negative numbers in parentheses). Ctrl+Shift+% Applies the Percentage format with no decimal places. Ctrl+Shift+^ Applies the Scientific number format with two decimal places.

Drivers for windows 7 to see mac partitions. Ctrl+Shift+# Applies the Date format with the day, month, and year. Ctrl+Shift+@ Applies the Time format with the hour and minute, and AM or PM. Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. Ctrl+Shift+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report. Ctrl+Shift+: Enters the current time.