Microsoft Excel Shortcut Keys Pdf
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.
Microsoft Excel Shortcut Keys Pdf
Keyboard Shortcuts In Access 2013: Access Web App Shortcut Keys, Desktop Database Shortcut Keys For Access, Shortcut Keys For Working With Text And Data In Access, Shortcut keys for navigating records in Access, Shortcut Keys For Access Ribbon Commands, and more.
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.
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. 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.
Excel Keyboard Shortcuts Cheat Sheet
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. Ctrl+Shift+' Copies the value from the cell above the active cell into the cell or the Formula Bar. Ctrl+Shift+Plus (+) Displays the Insert dialog box to insert blank cells. Ctrl+Minus (-) Displays the Delete dialog box to delete the selected cells. Ctrl+; Enters the current date.