Excel / / +. Quick Reference – The Most Important Keyboard Shortcuts for. Finance (IB, PE, HF/AM, ER, CF, etc.) Arrow Keys. Move Around. Key. Alone. Shift. Ctrl. Alt. Ctrl + Shift. F1. Help. What's This Help. Insert Chart Sheet. F2. Edit Mode. Edit Comment. Save As. F3. Paste Name Formula. Excel keyboard shortcuts and function keys for U.S. keyboard layout for Windows.
|Language:||English, Spanish, Dutch|
|Genre:||Business & Career|
|ePub File Size:||24.88 MB|
|PDF File Size:||14.76 MB|
|Distribution:||Free* [*Regsitration Required]|
Microsoft Excel Keyboard Shortcuts. CTRL combination shortcut keys. CTRL+Shift+. Unhides any hidden rows within the selection. CTRL+Shift+). Microsoft Excel Keyboard Keys. Source: homeranking.info homeranking.info General. Description. Shortcut Key. New file. Ctrl + N. Open file. time-saving Hotkeys for Excel exportable, wiki-style reference lists for Keyboard Shortcuts/Hotkeys. Function keys in Excel
Moves to the beginning of a row in a worksheet. I'm constantly gathering information about Excel shortcuts and hotkeys. Start this Excel test now. Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. Displays the Spelling dialog box to check spelling in the active worksheet or selected range. Displays the Print tab in Microsoft Office Backstage view. Moves to the beginning of a row in a worksheet.
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. Keyboard shortcuts that begin with Ctrl will still work in Microsoft Excel However, you need to know the full shortcut from memory — there are no screen reminders of what letters to press. 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. Applies the Number format with two decimal places, thousands separator, and minus sign - for negative values. Selects the current region around the active cell the data area enclosed by blank rows and blank columns.
When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. Displays the Find and Replace dialog box, with the Find tab selected. Displays the Find and Replace dialog box, with the Replace tab selected. Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
Displays the Quick Analysis options for your data when you have cells that contain that data selected. Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. Uses the Undo command to reverse the last command or to delete the last entry that you typed. Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
Displays the Paste Name dialog box. Available only if names have been defined in the workbook Formulas tab, Defined Names group, Define Name. Switches between the worksheet, Ribbon, task pane, and Zoom controls. Displays the Spelling dialog box to check spelling in the active worksheet or selected range. Turns extend mode on or off. Left or Right arrow key selects the tab to the left or right when the Ribbon is selected. When a Ribbon tab is selected, these keys navigate the tab buttons.
When a Ribbon tab is selected, these keys navigate up or down the tab group. It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again.
This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Excel If you are using Microsoft Excel Starter , be aware that not all the features listed for Excel are supported in Excel Starter This makes all the Key Tip badges for that tab's buttons appear. Download or print a Quick Reference Card: Keyboard Shortcuts - Ctrl keys. Keyboard Shortcuts - Function keys. Available only if there are existing names in the workbook. Keyboard Shortcuts - Miscellaneous.
END turns End mode on. In End mode, you can then press an arrow key to move to the next nonblank cell in the same column or row as the active cell. If the cells are blank, pressing END followed by an arrow key moves to the last cell in the row or column.
When a cell reference or range is selected in a formula, F4 cycles through the various combinations of absolute and relative references. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.
You can always ask an expert in the Excel Tech Community , get support in the Answers community , or suggest a new feature or improvement on Excel User Voice.
Keyboard shortcuts in Excel for Mac. Overview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. Excel functions alphabetical. Excel functions by category. Basic tasks using a screen reader with Excel. Use a screen reader to explore and navigate Excel. Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance.
The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.
If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk. Office Accessibility. Keyboard shortcuts in Excel for Windows. Expand your Office skills. Get new features first. Was this information helpful? Yes No. Any other feedback? How can we improve it? Send No thanks. Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.
Contact Support. To do this. Open the Home tab and format text and numbers and use the Find tool. Open the Page Layout tab and work with themes, page setup, scale, and alignment. Open the Formulas tab and insert, trace, and customize functions and calculations. Open the Data tab and connect to, sort, filter, analyze, and work with data. Open the Review tab and check spelling, add comments, and protect sheets and workbooks.
Select the active tab of the ribbon, and activate the access keys. Alt or F To move to a different tab, use access keys or the arrow keys. Move down, up, left, or right, respectively, among the items on the Ribbon. Move to the previous cell in a worksheet or the previous option in a dialog box. Move to the last cell on a worksheet, to the lowest used row of the rightmost used column. Extend the selection of cells to the last used cell on the worksheet lower-right corner.
Move to the cell in the upper-left corner of the window when Scroll Lock is turned on. Open the list of validation choices on a cell that has data validation option applied to it.
Exit the floating shape navigation and return to the normal navigation. Switch between displaying cell values or formulas in the worksheet. Copy a formula from the cell above the active cell into the cell or the Formula Bar. Switch between hiding objects, displaying objects, and displaying placeholders for objects. Apply the Currency format with two decimal places negative numbers in parentheses. Display the Quick Analysis options for selected cells that contain data.
Turn extend mode on and use the arrow keys to extend a selection.
Press again to turn off. Add a non-adjacent cell or range to a selection of cells by using the arrow keys.
Select the current region around the active cell or select an entire PivotTable report. Select the first command on the menu when a menu or submenu is visible. Select all text in the formula bar from the cursor position to the end. Copy the value from the cell above the active cell into the cell or the formula bar. Create a chart of the data in the current range in a separate Chart sheet. Paste a name from the Paste Name dialog box if names have been defined in the workbook.
F1 alone: F4 alone: F5 alone: F9 alone: F10 alone: Turns key tips on or off. Pressing Alt does the same thing. F11 alone: Creates a chart of the data in the current range in a separate Chart sheet. F12 alone: Displays the Key Tips new shortcuts on the ribbon.
Alt, W, L switches the worksheet to Normal view.
Move one cell up, down, left, or right in a worksheet. Deletes one character to the left in the Formula Bar. Arrow Left Nudge the selected shape left.
Arrow Right Nudge the selected shape right. Add ctrl for moving pixel-by-pixel. Work with Text Arrow Left Move one character to the left. Arrow Right Move one character to the right.
Arrow Up Move up one line. Arrow Down Move down one line. End Move to the end of a line.
Home Move to the beginning of a line. Backspace Delete one character to the left. Delete Delete one character to the right. Arrow Keys Move left and right, up and down, among collections or clips.
Delete Delete selected clip or category. Home Move to the beginning of a row and select the first item.
End Move to the end of a row and select the last item. Esc Exit a dialog box. Press either of these keys again to move back to the document and cancel the access keys. Enter Activate a command or control in the Ribbon so you can modify a value. Enter Finish modifying a value in a control in the Ribbon, and move focus back to the document. F1 Get help on the selected command or control in the Ribbon. If no Help topic is associated with the selected command, the Help table of contents for that program is shown instead.
Excel Shortcuts Comments Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell. Deletes one character to the left in the Formula Bar. In cell editing mode, it deletes the character to the left of the insertion point. Removes the cell contents data and formulas from selected cells without affecting cell formats or comments.
Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. Selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar.
Cancels an entry in the cell or Formula Bar.
Moves to the beginning of a row in a worksheet. Moves one cell to the right in a worksheet. Display the Format Cells with Fonts Tab active. Edits the active cell and positions the insertion point at the end of the cell contents.
Switches between the worksheet, Ribbon, task pane, and Zoom controls. Performs the Move command on the workbook window when it is not maximized. Turns extend mode on or off.
Performs the Size command on the Control menu for the workbook window when a workbook is not maximized. Rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. Displays the menu or message for a smart tag. Selects the current region around the active cell the data area enclosed by blank rows and blank columns.
Selects the entire worksheet. Inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula. Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
Inserts the contents of the Clipboard at the insertion point and replaces any selection. Displays the Paste Special dialog box. Uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.
Enlarge the selected shape horizontally. Reduce the selected shape horizontally. Enlarge the selected shape vertically.