Excel 2007 common shortcut keys and function keys

In the daily work, we all like to use Excel to make forms, in the sense that it brings convenience, fast, at the same time, have you ever thought that you can use Excel in the function keys and shortcuts, you can make daily work more efficient, together with the full use of Excel shortcut keys, you can make your table use more efficient.

function keys and shortcuts in Excel

The following list contains Ctrl combination shortcuts, function keys, some other common shortcut keys, and their functional descriptions.

Tip You might want to print this topic so that you can refer to it as you work. To print this topic, press CTRL+P.

Note If you frequently use an action that does not have a shortcut key, you can create a shortcut by recording macro.

Ctrl combination shortcut keys

Key description

ctrl+shift+ (Unhide all hidden rows in the selection.)

ctrl+shift+) Unhide all hidden columns in the selection.

The original Excel shortcut key can not only help us improve work efficiency, but also to solve the problem, and quickly look at the general operation of Excel needs to use the shortcut keys and function keys bar.

ctrl+shift+& applies the outer box to the selected cells.

Ctrl+shift_ deletes the outer border from the selected cells.

Ctrl+shift+~ applies the general number format.

ctrl+shift+$ applies a currency format with two-bit decimals (negative numbers are placed in parentheses).

ctrl+shift+% applies the percent format without decimal places.

ctrl+shift+^ applies an "exponential" format with two decimal places.

ctrl+shift+# applies a date format with days, months, and years.

ctrl+shift+@ applies a "time" format with hours and minutes and AM or PM.

ctrl+shift+! Applies the value format with two-bit decimal, thousand separator, and minus sign (-) for negative values.

Ctrl+shift+* selects the current range that surrounds the active cell (the data area enclosed by blank rows and blank columns).

In a PivotTable report, it selects the entire PivotTable report.

ctrl+shift+: Enter the current time.

ctrl+shift+ copies the value from the cell above the active cell to the cell or the formula bar.

The ctrl+shift+ plus sign (+) Displays the Insert dialog box for inserting blank cells.

CTRL + MINUS SIGN (-) Displays the Delete dialog box for removing the selected cells.

CTRL +; Enter the current date.

CTRL + ' Toggle the display of cell values and formulas on the worksheet.

CTRL + ' copies the formula from the cell above the active cell to the cell or the edit bar.

CTRL+1 Displays the Format Cells dialog box.

Ctrl+2 applies or cancels bold formatting.

Ctrl+3 applies or suppresses italic formatting.

Ctrl+4 apply or remove the underline.

Ctrl+5 apply or remove a line.

Ctrl+6 toggles between hidden objects, display objects, and display object placeholders.

Ctrl+8 Show or hide outline symbols.

Ctrl+9 hides the selected row.

Ctrl+0 hides the selected columns.

CTRL + A selects the entire worksheet.

If the worksheet contains data, press CTRL + A to select the current range, press CTRL + A again to select the current area and its total row, and the third time press CTRL + A to select the entire worksheet.

The Function Arguments dialog box is displayed when the insertion point is to the right of a function name in the formula.

When the insertion point is to the right of a function name in the formula, pressing CTRL+SHIFT+A inserts the parameter name and parentheses.

Ctrl+b applies or cancels bold formatting.

CTRL + C copies the selected cells.

If you press CTRL + two consecutive times, the Clipboard is displayed.

Ctrl+d Use the fill down command to copy the contents and formatting of the topmost cell in the selection to the cells below.

CTRL+F Displays the Find and Replace dialog box, where the Find tab is selected.

Pressing SHIFT+F5 also displays this tab, and pressing SHIFT+F4 repeats the last find action.

Press CTRL+SHIFT+F to open the Format Cells dialog box, where the Font tab is selected.

CTRL+G Displays the Locate dialog box.

Pressing F5 also displays this dialog box.

CTRL+H Displays the Find and Replace dialog box, where the Replace tab is selected.

Ctrl+i applies or suppresses italic formatting.

CTRL+K Displays the Insert Hyperlink dialog box for the new hyperlink, or displays the Edit Hyperlink dialog box for the selected existing hyperlink.

CTRL + N creates a new, blank workbook.

Ctrl+o Displays the Open dialog box to open or locate the file.

Press Ctrl+shift+o to select all cells that contain annotations.

CTRL+P Displays the Print dialog box.

Press Ctrl+shift+p to open the Format Cells dialog box, where the Font tab is selected.

Ctrl+r Use the Fill Right command to copy the contents and formatting of the leftmost cell in the selected range to the right cell.

Ctrl+s saves the active file with its current file name, location, and file format.

CTRL+T Displays the Create Table dialog box.

Ctrl+u apply or remove the underline.

Pressing Ctrl+shift+u toggles between expanding and collapsing the formula bar.

CTRL + V inserts the contents of the Clipboard at the insertion point and replaces any selection. You can use this shortcut only after you have cut or copied the object, text, or cell contents.

Ctrl+w Closes the selected workbook window.

Ctrl+x cuts the selected cells.

Ctrl+y repeats the previous command or action, if possible.

Ctrl+z Use the Undo command to undo the previous command or delete the last item you typed.

When an AutoCorrect smart tag is displayed, press Ctrl+shift+z to undo or redo the last AutoCorrect action by using the Undo or repeat command.

function keys

Key description

F1 Displays the Microsoft Office Excel Help task pane.

Press CTRL+F1 to show or hide the Ribbon.

Press ALT+F1 to create a chart of the data in the current scope.

Press ALT+SHIFT+F1 to insert a new worksheet.

F2 edits the active cell and places the insertion point at the end of the cell contents. If you disable editing in a cell, it also moves the insertion point to the formula bar.

Press SHIFT+F2 to add or edit cell annotations.

Press CTRL+F2 to display the Print preview window.

F3 Displays the Paste Name dialog box.

Press SHIFT+F3 to display the Insert Function dialog box.

F4 repeats the previous command or action, if possible.

Press CTRL+F4 to close the selected workbook window.

F5 Displays the Locate dialog box.

Press CTRL+F5 to restore the window size of the selected workbook window.

F6 switch between the worksheet, the Ribbon, the task pane, and the zoom control. In Split (by clicking the View menu, click the In a worksheet that manages this window, freeze panes, split Windows command, and when you switch between panes and ribbon areas, press F6 to include the split panes.)

Press SHIFT+F6 to toggle between the worksheet, zoom Control, task pane, and Ribbon.

If more than one workbook window is open, press CTRL+F6 to switch to the next workbook window.

F7 Displays the spelling checker dialog box to check the spelling in the active worksheet or selected range.

If the workbook window is not maximized, press CTRL+F7 to perform the move command on the window. Use the arrow keys to move the window, press Enter when you are finished, or press ESC to cancel.

F8 to turn expansion mode on or off. In extended mode, extended selection appears in the status row, and pressing an arrow key expands the selection.

By pressing SHIFT+F8, you can use the arrow keys to add a cell or range that is not adjacent to the selected range of cells.

When the workbook is not maximized, press Ctrl+f8 to perform the size command (on the Control menu in the workbook window).

Press Alt+f8 to display the Macros dialog box for creating, running, editing, or deleting macros.

F9 calculates all worksheets in all open workbooks.

Press SHIFT+F9 to calculate the active worksheet.

Press CTRL+ALT+F9 to calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

If you press CTRL+ALT+SHIFT+F9, the related formulas are reviewed, and then all the cells in all open workbooks are evaluated, including cells that are not marked for calculation.

Press CTRL+F9 to minimize the workbook window to an icon.

F10 turn on or off the key prompt.

Press SHIFT+F10 to display the shortcut menu for the selected item.

Press ALT+SHIFT+F10 to display the menu or message for the smart tag. If more than one smart tag is present, press the key combination to switch to the next smart tag and display its menu or message.

Press CTRL+F10 to maximize or restore the selected workbook window.

F11 The chart that creates the data in the current scope.

Press SHIFT+F11 to insert a new worksheet.

Pressing ALT+F11 opens the Microsoft Visual Basic Editor, where you can use Visual Basic for Applications (VBA) to

Create a macro.

F12 Displays the Save As dialog box.

Other useful shortcut keys

Key description

The arrow keys move one cell up, down, left, or right in the worksheet.

Press CTRL + The ARROW keys to move to the current data range data region: a range of cells that contains data, which is surrounded by blank cells or datasheet borders. ) on the edge.

Press the shift+ arrow key to enlarge the cell selection by one cell.

Press the ctrl+shift+ arrow key to extend a cell's selection to the last Non-empty cell in the column or row in which the active cell is located, or if the next cell is empty, extend the selection to the next Non-empty cell.

When the Ribbon is selected, press LEFT ARROW or RIGHT arrow to select the tab to the left or right. When the submenu is open or selected, press these arrow keys to toggle between the main menu and the submenu. When the Ribbon tab is selected, press these keys to navigate the tab buttons.

When a menu or submenu is open, press the DOWN ARROW or up arrow to select the next or previous command. When the Ribbon tab is selected, press these keys to navigate up and down the tab group.

In the dialog box, press the arrow keys to move between options in the Open Drop-down list, or between options in a group of options.

Press the down ARROW or ALT + DOWN ARROW key to open the selected Drop-down list.

Backspace deletes one character to the left in the formula bar.

You can also clear the contents of the active cell.

In cell edit mode, pressing the key deletes the character to the left of the insertion point.

Delete Deletes cell contents (data and formulas) from the selected cells without affecting cell formatting or annotations.

In cell edit mode, pressing the key deletes the character to the right of the insertion point.

End when Scroll Lock is turned on, move to the cell in the lower-right corner of the window.

When a menu or submenu is visible, you can also select the Last command on the menu.

Press Ctrl+end to move to the last cell on the worksheet, that is, the bottom row you use and the intersection cell of the rightmost column you use. If the cursor is in the formula bar, pressing CTRL+END moves the cursor to the end of the text.

Press Ctrl+shift+end to extend a cell selection to the last cell (in the lower-right corner) that is used on the worksheet. If the cursor is in the formula bar, press Ctrl+shift+end to select all the text in the formula bar from the cursor position to the end, which does not affect the height of the formula bar.

Enter to complete the cell entry from the cell or formula bar, and (by default) select the following cell.

In a data form, press the key to move to the first field in the next record.

Open the selected menu (press F10 to activate the menu bar), or perform the action of the selected command.

In the dialog box, press the key to perform the action of the default command button in the dialog box (the button with the highlighted outline, usually the OK button).

Press Alt+enter to start a new row in the same cell.

Press Ctrl+enter to populate the selected range of cells with the current entry.

Press Shift+enter to complete the cell entry and select the cell above.

ESC cancels the entry in the cell or formula bar.

Closes an open menu or submenu, dialog box, or message window.

When you apply Full-screen mode, press the key to turn off this mode, return to normal screen mode, and display the Ribbon and status bar again.

Home moves to the beginning of a row in the worksheet.

When Scroll Lock is turned on, move to the cell in the upper-left corner of the window.

When a menu or submenu is visible, select the First command on the menu.

Press Ctrl+home to move to the beginning of the worksheet.

Press Ctrl+shift+home to extend the selection of a cell to the beginning of the worksheet.

Page down moves one screen down in the worksheet.

Press Alt+page down to move one screen to the right in the worksheet.

Press ctrl+page down to move to the next worksheet in the workbook.

Press Ctrl+shift+page down to select the current and next worksheets in the workbook.

Page up moves up one screen in the worksheet.

Press Alt+page up to move one screen to the left in the worksheet.

Press Ctrl+page up to move to the previous worksheet in the workbook.

Press Ctrl+shift+page up to select the current and previous worksheets in the workbook.

SPACEBAR in the dialog box, perform the action of the selected button, or select or clear the check box.

Press CTRL + SPACEBAR to select an entire column in the worksheet.

Press shift+ SPACEBAR to select the entire row in the worksheet.

Press ctrl+shift+ SPACEBAR to select the entire worksheet.

If the worksheet contains data, press ctrl+shift+ SPACEBAR to select the current area, and then press ctrl+shift+ SPACEBAR to select the current area and its total row, and the third time by pressing ctrl+shift+ SPACEBAR will select the entire worksheet.

When an object is selected, press ctrl+shift+ SPACEBAR to select all objects on the worksheet.

Press ALT + SPACEBAR to display the Control menu for the Microsoft Office Excel window.

Tab moves one cell to the right in the worksheet.

In a protected worksheet, you can move between unlocked cells.

In the dialog box, move to the next option or option group.

Press Shift+tab to move to the previous cell (in the worksheet) or the previous option (in the dialog box).

In the dialog box, press Ctrl+tab to switch to the next tab.

In the dialog box, press Ctrl+shift+tab to switch to the previous tab.