Keyboard shortcuts in Excel are indispensable tools for enhancing your efficiency and productivity while working with spreadsheets. By mastering these shortcuts, you can significantly reduce the time spent on routine tasks, allowing for quicker data manipulation, analysis, and formatting. Whether you’re a seasoned professional or a new user, incorporating these shortcuts into your daily workflow can transform your Excel experience, making it more fluid and less time-consuming. Embrace the full potential of keyboard shortcuts in Excel to streamline your processes and elevate your data management skills.
Notes:
- This topic’s shortcuts make use of the US keyboard layout. It’s possible that the keys on a US keyboard don’t exactly match the keys in foreign layouts.
- If a shortcut contains a plus sign (+), pressing multiple keys simultaneously is required.
- When a shortcut contains the comma symbol (,), it signifies that you must press several keys sequentially.
This Tutorial Covers:
- Shortcuts that are frequently used
- keyboard shortcuts for a ribbon
- For ribbon tabs, use the Access keys
- Using the keyboard, work in the ribbon
- Keyboard shortcuts for cell navigation
- Formatting cells with keyboard shortcuts
- Excel 2013’s Paste Special dialog box keyboard shortcuts
- Shortcuts on the keyboard for selecting items and taking action
- Keyboard shortcuts for using the formula bar, functions, and data
- Shortcuts on the keyboard for updating external data
- Keyboard shortcuts for Power Pivot
- Function keys
- Other helpful shortcuts
1. Shortcuts that are frequently used
The Excel shortcuts that are most often used are included in this table.
| To carry out this | Press |
| Close a workbook. | Ctrl+W |
| Open a workbook. | Ctrl+O |
| Go to the Home tab. | Alt+H |
| Save a workbook. | Ctrl+S |
| Copy selection. | Ctrl+C |
| Paste selection. | Ctrl+V |
| Undo recent action. | Ctrl+Z |
| Remove cell contents. | Delete |
| Choose a fill color. | Alt+H, H |
| Cut selection. | Ctrl+X |
| Go to the Insert tab. | Alt+N |
| Apply bold formatting. | Ctrl+B |
| Center aligns cell contents. | Alt+H, A, C |
| Go to the Page Layout tab. | Alt+P |
| Go to the Data tab. | Alt+A |
| Go to the View tab. | Alt+W |
| Open the context menu. | Shift+F10 or Windows Menu key |
| Add borders. | Alt+H, B |
| Delete column. | Alt+H, D, C |
| Go to the Formula tab. | Alt+M |
| Hide the selected rows. | Ctrl+9 |
| Hide the selected columns. | Ctrl+0 |
2. Keyboard shortcuts for a ribbon
On tabs in the ribbon, relevant options are grouped. The Number Format option, for instance, can be found under the Number group on the “Home” tab. By holding down the Alt key, the Key Tips, also known as the shortcuts on the ribbon, will appear as miniature images next to the tabs and options.
For the ribbon options, you may create shortcuts known as Access Keys by combining the Key Tips letters with the Alt key. For instance, press Alt+Q to get to the Tell me or Search field and Alt+H to enter the Home tab. To view KeyTips for the options for the chosen tab, press Alt once again.
The text box labeled “Search” at the top of the app window may instead be called “Tell Me” depending on the version of Microsoft 365 you are using. Both provide a mostly comparable experience, however there are some different options and search results.
The majority of the outdated Alt key menu shortcuts still function in Office 2013 and Office 2010. You must, however, be aware of the complete shortcut. To use one of the classic menu keys, such as E (Edit), V (View), I (Insert), and so on, hit Alt first. You are utilizing an access key from a previous version of Microsoft 365, according to a message that appears. Use the whole key sequence if you are familiar with it. Press Esc and utilize Key Tips if you’re unsure about the order.
3. For ribbon tabs, use the Access keys
Keyboard shortcuts for excel, press one of the following access keys to jump to a specific tab on the ribbon. Depending on the worksheet decision you make, other tabs can be displayed.
| To carry out this | Press |
| Enter a search phrase for support or Help content in the Tell me or Search section on the ribbon. | Alt+Q, then enter the search term. |
| Activate the File menu. | Alt+F |
| Use the Find tool and the “Home” tab to format text and numbers. | Alt+H |
| PivotTables, charts, add-ons, Sparklines, images, shapes, headers, and text fields can all be added by using the Insert tab. | Alt+N |
| Work with themes, page configuration, scale, and alignment by using the Page Layout tab. | Alt+P |
| Insert, trace, and customize functions and calculations by selecting the Formulas tab. | Alt+M |
| Open the Data tab to access, organize, filter, and collaborate with data. | Alt+A |
| Check spelling, add notes and threaded comments, and protect worksheets and sheets by opening the Review tab. | Alt+R |
| View macros, manage windows and panes, control zoom magnification, display and conceal gridlines and headings, and preview page breaks and layouts by selecting the View tab. | Alt+W |
4. Using the keyboard, work in the ribbon
| To carry out this | Press |
| The access keys are activated after choosing the active tab on the ribbon. | Alt or F10. To move to a different tab, use access keys or the arrow keys. |
| Shift the focus to the ribbon’s commands. | Tab key or Shift+Tab |
| Move among the things on the ribbon by going down, up, left, or right, as appropriate. | Arrow keys |
| Display the tooltip for the focussed ribbon element. | Ctrl+Shift+F10 |
| turn on the chosen button. | Spacebar or Enter |
| For a chosen command, display the list. | Down arrow key |
| Select a button to reveal the menu for it. | Alt+Down arrow key |
| Go to the subsequent command once a menu or submenu has been opened. | Down arrow key |
| Retract or extend the ribbon. | Ctrl+F1 |
| Activate the context menu. | Shift+F10
Or, on a Windows keyboard, the Windows Menu key (usually between the Alt Gr and right Ctrl keys) |
| When a main menu is opened or selected, go to the submenu. | Left arrow key |
| Switch between several control groups. | Ctrl+Left or Right arrow key |
5. Keyboard shortcuts for cell navigation
| To carry out this | Press |
| Go to the previous worksheet cell or dialog box choice by selecting the previous one. | Shift+Tab |
| Upward cell movement on a worksheet. | Up arrow key |
| On a worksheet, move one cell below. | Down arrow key |
| On a worksheet, move one cell to the left. | Left arrow key |
| On a worksheet, move one cell to the right. | Right arrow key |
| Go to the worksheet’s edge where the current data region is located. | Ctrl+Arrow key |
| Turn on End mode, then move to the subsequent non-blank cell in the same column or row as the current cell. Move to the last cell in the row or column if the cells are empty. | End, Arrow key |
| On a worksheet, go to the final cell in the lowest-used row of the rightmost-used column. | Ctrl+End |
| extend the selection of cells to the worksheet’s most recently used cell (lower-right corner). | Ctrl+Shift+End |
| When scroll lock is on, move to the cell in the upper-left corner of the window. | Home+Scroll lock |
| Go to the start of the worksheet. | Ctrl+Home |
| In a worksheet, scroll down one screen. | Page down |
| Go to the following workbook page. | Ctrl+Page down |
| In a worksheet, jog one screen to the right. | Alt+Page down |
| In a worksheet, forward one screen. | Page up |
| In a worksheet, slide one screen to the left. | Alt+Page up |
| In a workbook, go to the previous sheet. | Ctrl+Page up |
| On a worksheet, move one cell to the right. Alternately, navigate between unlocked cells in a worksheet that is protected. | Tab key |
| On a cell where the data validation option has been applied, open the list of validation options. | Alt+Down arrow key |
| Floating forms like text boxes and graphics can be cycled through. | Ctrl+Alt+5, then the Tab key repeatedly |
| Return to standard navigation after leaving the floating shape navigation. | Esc |
| horizontally scroll. | Ctrl+Shift, then scroll your mouse wheel up to go left, down to go right |
| Zoom in. | Ctrl+Alt+Equal sign ( = ) |
| Zoom out. | Ctrl+Alt+Minus sign (-) |
6. Formatting cells with keyboard shortcuts
| To carry out this | Press |
| dialog box for formatting cells is opened. | Ctrl+1 |
| In the Format Cells dialog box, format fonts. | Ctrl+Shift+F or Ctrl+Shift+P |
| Put the insertion point at the end of the contents of the active cell after editing it. The insertion point can also be moved inside the formula bar if editing is disabled for the cell. You can use the arrow keys to construct references when modifying a formula by switching Point mode on or off. | F2 |
| Add a note here. | Shift+F2 |
| Edit a cell note by opening it. | Shift+F2 |
| Place a threaded remark here. | Ctrl+Shift+F2 |
| Open a threaded remark and respond to it. | Ctrl+Shift+F2 |
| To insert blank cells, open the Insert dialog box. | Ctrl+Shift+Plus sign (+) |
| To delete a selection of cells, open the Delete dialog box. | Ctrl+Minus sign (-) |
| Enter the time right now. | Ctrl+Shift+Colon (:) |
| Type the current date here. | Ctrl+Semicolon (;) |
| Change the worksheet’s display of cell values or formulas. | Ctrl+Grave accent (`) |
| The active cell’s neighboring cell’s formula should be copied into the active cell or the formula bar. | Ctrl+Apostrophe (‘) |
| The chosen cells are moved. | Ctrl+X |
| The chosen cells are copied. | Ctrl+C |
| Replace any selection at the insertion point by pasting content. | Ctrl+V |
| Activate the Paste Special dialog box. | Ctrl+Alt+V |
| Remove the italic formatting or italicize the content. | Ctrl+I or Ctrl+3 |
| Bold text should not be used. | Ctrl+B or Ctrl+2 |
| Text can be underlined or not. | Ctrl+U or Ctrl+4 |
| Formatting strikethrough can be applied or removed. | Ctrl+5 |
| Alternate between displaying placeholders for things, displaying objects, and hiding objects. | Ctrl+6 |
| Apply a border outline to the chosen cells. | Ctrl+Shift+Ampersand sign (&) |
| The selected cells should no longer have an outline border. | Ctrl+Shift+Underscore (_) |
| You can show or conceal the outline symbols. | Ctrl+8 |
| To duplicate the contents and formatting of the top cell in a given range in the cells below, use the Fill Down command. | Ctrl+D |
| The General Number Format should be used. | Ctrl+Shift+Tilde sign (~) |
| Apply the two-place decimal currency format (negative numbers in parentheses). | Ctrl+Shift+Dollar sign ($) |
| Use the percentage format without any commas. | Ctrl+Shift+Percent sign (%) |
| Use a two-decimal place format for scientific numbers. | Ctrl+Shift+Caret sign (^) |
| Use the day, month, and year together with the Date format. | Ctrl+Shift+Number sign (#) |
| Use the Time format with AM or PM, the hour, and the minute. | Ctrl+Shift+At sign (@) |
| For negative quantities, use the Number format with two decimal places, thousands separator, and minus sign (-). | Ctrl+Shift+Exclamation point (!) |
| Launch the dialog box for adding a hyperlink. | Ctrl+K |
| Verify the active worksheet’s or the selected range’s spelling. | F7 |
| Show the Quick Analysis options for the selected data-containing cells. | Ctrl+Q |
| The Create Table dialog box to appear. | Ctrl+L or Ctrl+T |
| The Workbook Statistics dialog box should be opened. | Ctrl+Shift+G |
7. Excel 2013’s Paste Special dialog box keyboard shortcuts
Using the Paste Special options in Excel 2013, you can paste a specific portion of the copied data, such as its formatting or value. Press Ctrl+Alt+V or Alt+E+S to bring up the Paste Special dialog box once you’ve copied the data.
Advice: Another option is Home > Paste > Paste Special.
Press the letter that corresponds to the underlined option in the dialog box to select it. For instance, select the Comments option by pressing the letter C.
| To carry out this | Press |
| Paste all cell’s data, including formatting. | A |
| Just copy and paste the formulas that you put into the formula area. | F |
| Only paste the values (not the formulas). | V |
| Paste only the formatting that was copied. | T |
| Paste only cell-attached comments and notes. | C |
| Copy the cells, then only paste the data validation settings. | N |
| Copy the contents and formatting of all the cells, then paste them. | H |
| Paste without borders all of the cell contents. | X |
| Merely copy the column widths from the copied cells. | W |
| Copy the copied cells, then only paste the formulas and number formats. | R |
| Paste only the values from copied cells—not formulas or number formats. | U |
8. Shortcuts on the keyboard for selecting items and taking action
| To carry out this | Press |
| Choose the whole worksheet. | Ctrl+A or Ctrl+Shift+Spacebar |
| In a workbook, choose the current and following sheets. | Ctrl+Shift+Page down |
| In a workbook, choose the current and previous sheet. | Ctrl+Shift+Page up |
| Add one more cell to the selection of cells. | Shift+Arrow key |
| The last non-blank cell in the same column or row as the active cell, or the next non-blank cell if the following cell is blank, is included in the selection of cells. | Ctrl+Shift+Arrow key |
| Enable extend mode and extend a selection with the arrow keys. Click once more to turn off. | F8 |
| Using the arrow keys, you can add a non-adjacent cell or range to a group of cells. | Shift+F8 |
| The same cell should now have a new line. | Alt+Enter |
| The current entry should be placed in the designated cell range. | Ctrl+Enter |
| Fill out a cell entry, then choose the cell above it. | Shift+Enter |
| In a worksheet, select a column in its entirety. | Ctrl+Spacebar |
| Choose a whole worksheet row. | Shift+Spacebar |
| When an object is selected on a worksheet, select all of the selected items. | Ctrl+Shift+Spacebar |
| extend the cell selection all the way to the worksheet’s top. | Ctrl+Shift+Home |
| If the worksheet has data, choose the current area. To pick the current region and its summary rows, press once more. To select the full worksheet, press a third time. | Ctrl+A or Ctrl+Shift+Spacebar |
| Choose the area that is currently around the active cell. | Ctrl+Shift+Asterisk sign (*) |
| Whenever a menu or submenu is present, choose the first command on the menu. | Home |
| If at all feasible, repeat the last instruction or deed. | Ctrl+Y |
| Reverse the previous action. | Ctrl+Z |
| Extend grouped rows or columns. | While hovering over the collapsed items, press and hold the Shift key and scroll down. |
| Grouped rows or columns are collapsed. | While hovering over the expanded items, press and hold the Shift key and scroll up. |
9. Keyboard shortcuts for using the formula bar, functions, and data
| To carry out this | Press |
| Put the insertion point at the end of the active cell’s contents when editing it. Alternately, shift the insertion point inside the formula bar if editing is disabled for the cell. Toggle Point mode on or off while changing a formula so you may use the arrow keys to make references. | F2 |
| Resize or minimize the formula bar. | Ctrl+Shift+U |
| You can delete a formula or cell entry. | Esc |
| Enter a value in the formula bar, then choose the cell below. | Enter |
| When the cursor is in the formula bar, move it to the end of the text. | Ctrl+End |
| From the cursor location to the end, select the entire formula bar’s text. | Ctrl+Shift+End |
| Calculate every worksheet across all active workbooks. | F9 |
| The worksheet that is now active. | Shift+F9 |
| Calculate all worksheets, whether or not they have changed since the last calculation, in all open workbooks. | Ctrl+Alt+F9 |
| Calculate all cells in all open workbooks, including cells that are not designated as requiring calculation, after checking dependent formulas. | Ctrl+Alt+Shift+F9 |
| Show the Error Checking button’s menu or message. | Alt+Shift+F10 |
| When the insertion point is in a formula to the right of a function name, the Function Arguments dialog box will be displayed. | Ctrl+A |
| When the insertion point is in a formula to the right of a function name, add argument names and parentheses. | Ctrl+Shift+A |
| Put the AutoSum formula there. | Alt+Equal sign ( = ) |
| Use Flash Fill to automatically identify patterns in surrounding columns so that the current column is filled | Ctrl+E |
| If a cell reference or range is chosen, the formula will iterate through every possible combination of absolute and relative references. | F4 |
| Put a function in. | Shift+F3 |
| In the cell or the formula bar, paste the value from the cell above the active cell. | Ctrl+Shift+Straight quotation mark (“) |
| Embed a chart with the data from the current range. | Alt+F1 |
| In a separate Chart sheet, make a chart showing the data in the current range. | F11 |
| Specify a name for references. | Alt+M, M, D |
| Use the Paste Name dialog box to paste a name (if names have been defined in the workbook). | F3 |
| Go to the first field of the following data form record. | Enter |
| You can add, edit, run, or remove a macro. | Alt+F8 |
| the Microsoft Visual Basic For Applications Editor should be opened. | Alt+F11 |
| Activate the Power Query Editor. | Alt+F12 |
10. Shortcuts on the keyboard for updating external data
To update information from external data sources, press the following keys.
| To carry out this | Press |
| Stop a refresh operation. | Esc |
| Refresh data in the current worksheet. | Ctrl+F5 |
| Refresh all data in the workbook. | Ctrl+Alt+F5 |
11. Keyboard shortcuts for Power Pivot
With Power Pivot in Microsoft 365, Excel 2021, Excel 2019, Excel 2016, and Excel 2013, use the keyboard shortcuts listed below.
| To carry out this | Press |
| For the selected cell, column, or row, open the context menu. | Shift+F10 |
| Choose the whole table. | Ctrl+A |
| Copy the chosen data. | Ctrl+C |
| Get rid of the table. | Ctrl+D |
| Detach the table. | Ctrl+M |
| Table name change. | Ctrl+R |
| File saving. | Ctrl+S |
| Repeat what you just did. | Ctrl+Y |
| Reverse the previous action. | Ctrl+Z |
| choosing the current column. | Ctrl+Spacebar |
| Choose the present row. | Shift+Spacebar |
| From the current cell to the last cell of the column, choose every cell. | Shift+Page down |
| From the current cell to the first cell of the column, choose every cell. | Shift+Page up |
| From the cell you are in until the last cell of the row, choose every cell. | Shift+End |
| From the current cell to the first cell of the row, choose every cell. | Shift+Home |
| Go back to the prior table. | Ctrl+Page up |
| Go to the following table. | Ctrl+Page down |
| Go to the top-left cell of the chosen table’s first row. | Ctrl+Home |
| Go to the final cell in the table’s lower-right corner. | Ctrl+End |
| Go to the top cell in the chosen row. | Ctrl+Left arrow key |
| Go to the final cell in the chosen row. | Ctrl+Right arrow key |
| Go to the specified column’s first cell. | Ctrl+Up arrow key |
| Go to the final cell in the chosen column. | Ctrl+Down arrow key |
| Dialog boxes can be closed, and processes like paste operations can be stopped. | Ctrl+Esc |
| Launch the AutoFilter Menu window. | Alt+Down arrow key |
| Launch the Go To dialog window. | F5 |
| All formulas in the Power Pivot window should be recalculated. See Recalculate Formulas in Power Pivot for further details. | F9 |
12. Function keys
| Key | Description |
| F1 | F1 alone: opens the task pane for Excel Help. |
| Pressing Ctrl+F1 will show or hide the ribbon. | |
| Using Alt+F1, you can embed a chart showing the data for the current range. | |
| To insert a new worksheet, use Alt+Shift+F1. | |
| Toggle full screen mode with Ctrl+Shift+F1. | |
| F2 | F2 by itself: modify the selected cell and position the insertion point near the conclusion of its content. Alternately, shift the insertion point inside the formula bar if editing is disabled for the cell. Toggle Point mode on or off while changing a formula so you may use the arrow keys to make references. |
| F2 + Shift: Adds or modifies a cell note. | |
| The print preview box is visible by pressing Ctrl+F2 in the Backstage view’s Print tab. | |
| F3 | With just F3, the Paste Name dialog box is shown. If names have been defined in the worksheet, they are only available. |
| Shift+F3: Brings up the dialog box for Inserting Function. | |
| F4 | F4 by itself: if possible, repeats the last command or action. |
| F4 cycles through all possible pairings of absolute and relative references when a cell reference or range is selected in a formula. | |
| Ctrl+F4 closes the window for the selected worksheet. | |
| Excel is closed with Alt+F4. | |
| F5 | By alone, F5 presents the Go To dialog box. |
| The selected workbook window’s window size is restored by pressing Ctrl+F5. | |
| F6 | F6 by itself: toggles the Zoom controls, ribbon, task window, and worksheet. When navigating between panes and the ribbon area in a worksheet that has been divided, pressing F6 also selects the divided panes. |
| Shift+F6 toggles between the task window, ribbon, zoom controls, and the worksheet. | |
| Switches between two Excel windows using Ctrl+F6. | |
| Switches between all of the Excel windows with Ctrl+Shift+F6. | |
| F7 | The active worksheet or the selected range can be checked for spelling by pressing F7 alone. |
| When the workbook window is not maximized, pressing the keys Ctrl and F7 executes the Move command. To move the window, use the arrow keys; once you’re done, press Enter or Esc to cancel. | |
| F8 | F8 alone itself: enables or disables expand mode. The selection is extended using the arrow keys when in extend mode, which is indicated as Extended Selection in the status line. |
| By pressing Shift + F8, you can use the arrow keys to pick a group of cells and then add a non-adjacent cell or range to it. | |
| When a workbook is not maximized, the Size command is executed by pressing Ctrl+F8. | |
| In order to create, run, amend, or delete a macro, press Alt + F8. | |
| F9 | With just F9, all worksheets in all open workbooks are calculated. |
| Calculates the active worksheet using Shift+F9. | |
| All worksheets in all open workbooks are calculated when Ctrl+Alt+F9 is pressed, regardless of whether they have changed since the last calculation. | |
| The combination Ctrl+Alt+Shift+F9 double-checks dependent formulae before calculating every cell in every open worksheet, even those that are not designated as having to be calculated. | |
| Ctrl+F9 will reduce the size of the workbook window to an icon. | |
| F10 | F10 by itself: turns off or on key tips. (Pressing Alt has a similar effect.) |
| To view the context menu for a selected item, press Shift + F10. | |
| The menu or message for an error checking button is displayed by pressing Alt+Shift+F10. | |
| When pressing Ctrl+F10, the selected workbook window is maximized or restored. | |
| F11 | F11 by itself: generates a separate Chart page with a chart of the data in the current range. |
| Inserts a new worksheet with Shift+F11. | |
| Alt+F11 launches the Microsoft Visual Basic For Applications Editor, where you can use Visual Basic for Applications to construct a macro (VBA). | |
| F12 | Using just F12, the Save As dialog box is displayed. |
13. Other helpful shortcuts
| Key | Description |
| Alt | shows the new shortcuts (Key Tips) on the ribbon. |
| For instance, | |
| To go to Page Layout view, press Alt, W, and P on the spreadsheet. | |
| Alt, W, L changes the worksheet’s display to Normal. | |
| Alt, W, I change the worksheet’s display to Page Break Preview. | |
| Arrow keys | On a worksheet, move one cell up, down, left, or right. |
| In a worksheet, using the Ctrl+Arrow key advances to the edge of the current data region. | |
| The selection of cells is extended by one cell by pressing Shift + Arrow. | |
| Ctrl+Shift+Arrow expands the selection of cells to the next non-blank cell if the next cell is not blank or to the final non-blank cell in the same column or row as the active cell. | |
| When a menu or submenu is open, the Down or Up arrow key picks the next or previous command. These keys allow you to go up and down the ribbon tab group while a ribbon tab is selected. | |
| Arrow keys are used in dialog boxes to navigate between alternatives within a set of options or within an open drop-down list. | |
| A selected drop-down list is opened with the Down or Alt+Down arrow key. | |
| Backspace | Deletes the leftmost character in the formula bar. |
| the active cell’s content is cleared. | |
| It eliminates the character to the left of the insertion point when in cell editing mode. | |
| Delete | Removes the data and formulas from a set of selected cells without changing the cell’s format, any threaded comments, or any notes. |
| It eliminates the character immediately to the right of the insertion point when in cell editing mode. | |
| End | Turns on or off End mode. The next non-blank cell in the same column or row as the current cell can be reached by using an arrow key while in End mode. After pressing the arrow key, End mode automatically exits. Before tapping the following arrow key, make sure you press End once again. When End Mode is active, it is indicated in the status bar. |
| Pressing End and an arrow key advance to the last cell in the row or column if the cells are empty. | |
| When a menu or submenu is shown, End also chooses the last command on the menu. | |
| When used to advance to the last cell on a worksheet, Ctrl+End selects the rightmost column’s lowest used row. Ctrl+End moves the cursor to the end of the text if it is in the formula bar. | |
| The selection of cells is extended by Ctrl+Shift+End to include the worksheet’s most recently used cell (lower-right corner). Ctrl+Shift+End selects all text in the formula bar from the cursor location to the end if the cursor is inside the formula bar; the formula bar’s height is unaffected. | |
| Enter | picks the cell below and completes a cell entry using the formula bar or the cell (by default). |
| It advances to the first field of the following record in a data form. | |
| opens a chosen menu (press F10 to bring up the menu bar) or executes a chosen command. | |
| It executes the command associated with the dialog box’s default command button, which is frequently the OK button and has a bold outline. | |
| New lines are started in the same cell with Alt+Enter. | |
| The current entry is added to the selected cell range by pressing Ctrl+Enter. | |
| Shift+Enter finishes typing in a cell and chooses the cell above it. | |
| Esc | Deletes a formula or cell entry from the formula bar. |
| closes a dialog box, message window, or open menu or submenu. | |
| Home | moves the cursor to the start of a row in a worksheet. |
| when Scroll lock is activated, it moves to the cell in the upper-left corner of the window. | |
| Whenever a menu or submenu is visible, choosing the first command from the menu is done. | |
| The shortcut key Ctrl+Home jumps to the worksheet’s start. | |
| The selection of cells is extended to the worksheet’s very first row by pressing Ctrl+Shift+Home. | |
| Page down | moves a worksheet down one screen. |
| In a worksheet, Alt+Page down shifts the cursor one screen to the right. | |
| To access the following sheet in a worksheet, press Ctrl+Page down. | |
| In a worksheet, pressing Ctrl+Shift+Page down selects the current and following sheet. | |
| Page up | moves a spreadsheet up one screen. |
| In a worksheet, Alt+Page up slides the screen to the left by one. | |
| In a worksheet, Ctrl+Page up navigates to the prior sheet. | |
| In a worksheet, pressing Ctrl+Shift+Page up selects the current and previous sheet. | |
| Shift | To relocate the selected cells and drop them in a new spot, hold down the Shift key while dragging a selected row, column, or set of cells. |
| Spacebar | does the action for the selected button in a dialog box, or checks or unchecks a checkbox. |
| A worksheet’s full column can be selected with Ctrl+Spacebar. | |
| In a worksheet, Shift+Spacebar selects an entire row. | |
| The full worksheet is selected with Ctrl+Shift+Spacebar. | |
| Ctrl+Shift+Spacebar chooses the current region if the worksheet has data. The current region and its summary rows are selected when Ctrl+Shift+Spacebar is pressed a second time. The full worksheet is selected when Ctrl+Shift+Spacebar are pressed three times. | |
| Ctrl+Shift+Spacebar selects all worksheet objects while one object is chosen. | |
| The Excel window’s Control menu can be accessed by pressing Alt + Space. | |
| Tab key | moves a worksheet cell one space to the right. |
| moves between unlocked cells in a worksheet that is password-protected. | |
| advances a dialog box to the next item or group of options. | |
| Shift+Tab navigates to the previous worksheet cell or dialog box selection. | |
| Ctrl+Tab toggles between two Excel windows or opens the next tab in a dialog box (if none are active). | |
| Ctrl+Shift+Tab toggles between all of the Excel windows or the previous tab in an open dialog box (if there isn’t one open). |
Application of Keyboard shortcuts in Excel to improve your efficiency
- Quick Navigation: Use keyboard shortcuts like Ctrl + Arrow keys to quickly navigate to the edge of data regions within a spreadsheet, improving speed and efficiency.
- Data Manipulation: Employ shortcuts such as Ctrl + D (Fill Down) and Ctrl + R (Fill Right) to copy cell contents or formulas to adjacent cells, streamlining data entry and consistency.
- Formatting Cells: Utilize shortcuts like Ctrl + B (Bold), Ctrl + I (Italic), and Ctrl + U (Underline) to quickly format cell text, enhancing readability and presentation.
- Worksheet Management: Manage worksheets using Ctrl + PgUp and Ctrl + PgDn to switch between tabs, and Ctrl + Shift + “+” to insert new worksheets, optimizing workbook organization.
- Formula Operations: Apply shortcuts such as Ctrl + Shift + Enter to enter array formulas, and F2 to edit the active cell, speeding up formula creation and modification.
- Data Selection and Analysis: Use Ctrl + Shift + L to toggle filters, and Ctrl + A to select all data in a range, facilitating quick data analysis and decision-making processes.
You may be interested:
