Excel 2007 Shortcuts - Comprehensive

Front 1

ALT ’

Back 1

Format Style dialog box

Front 2

ALT =

Back 2

AutoSum

Front 3

ALT DOWN ARROW

Back 3

Display AutoComplete list

Front 4

ALT ENTER

Back 4

Start a new line in the same cell.

Front 5

ALT F1

Back 5

creates a chart of the data in the current range.

Front 6

ALT F11

Back 6

opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).

Front 7

ALT F2

Back 7

Save As

Front 8

ALT F4

Back 8

Exit

Front 9

ALT F8

Back 9

displays the Macro dialog box to create, run, edit, or delete a macro.

Front 10

ALT OR F10

Back 10

Activate the ribbon

Front 11

ALT PAGE DOWN

Back 11

moves one screen to the right in a worksheet.

Front 12

ALT PAGE UP

Back 12

moves one screen to the left in a worksheet.

Front 13

ALT SHIFT F1

Back 13

inserts a new worksheet.

Front 14

ALT SHIFT F10

Back 14

displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.

Front 15

ALT SHIFT F2

Back 15

Save

Front 16

CTRL '

Back 16

Copies a formula from the cell above the active cell into the cell or the Formula Bar.

Front 17

CTRL - (minus)

Back 17

Displays the Delete dialog box to delete the selected cells.

Front 18

CTRL ! (requires shift key)

Back 18

Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

Front 19

CTRL " (requires shift key)

Back 19

Copy Value from Cell Above

Front 20

CTRL # (requires shift key)

Back 20

Applies the Date format with the day, month, and year.

Front 21

CTRL $ (requires shift key)

Back 21

Applies the Currency format with two decimal places (negative numbers in parentheses).

Front 22

CTRL % (requires shift key)

Back 22

Applies the Percentage format with no decimal places.

Front 23

CTRL & (requires shift key)

Back 23

Applies the outline border to the selected cells.

Front 24

CTRL ( (requires shift key)

Back 24

Unhides any hidden rows within the selection.

Front 25

CTRL ) (requires shift key)

Back 25

Unhides any hidden columns within the selection.

Front 26

CTRL * (requires shift key)

Back 26

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.

Front 27

CTRL : (requires shift key)

Back 27

Enters the current time.

Front 28

CTRL ;

Back 28

Enters the current date.

Front 29

CTRL @ (requires shift key)

Back 29

Applies the Time format with the hour and minute, and AM or PM.

Front 30

CTRL ^ (requires shift key)

Back 30

Applies the Exponential number format with two decimal places.

Front 31

CTRL _ (requires shift key)

Back 31

Removes the outline border from the selected cells.

Front 32

CTRL `

Back 32

Alternates between displaying cell values and displaying formulas in the worksheet.

Front 33

CTRL ~ (requires shift key)

Back 33

Applies the General number format in Microsoft Excel.

Front 34

CTRL + (requires shift key)

Back 34

Displays the Insert dialog box to insert blank cells in Microsoft Excel.

Front 35

CTRL 0

Back 35

Hide columns

Front 36

CTRL 1

Back 36

Displays the Format Cells dialog box.

Front 37

CTRL 2

Back 37

Applies or removes bold formatting.

Front 38

CTRL 3

Back 38

Applies or removes italic formatting.

Front 39

CTRL 4

Back 39

Underline

Front 40

CTRL 5

Back 40

Applies or removes strikethrough.

Front 41

CTRL 6

Back 41

Alternates between hiding objects, displaying objects, and displaying placeholders for objects.

Front 42

CTRL 8

Back 42

Displays or hides the outline symbols.

Front 43

CTRL 9

Back 43

Hides the selected rows.

Front 44

CTRL A

Back 44

Stands for two things: All or Arguments. Selects the entire worksheet. If the worksheet contains data, __ selects the current region. Pressing __ a second time selects the current region and its summary rows. Pressing __ a third time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.

Front 45

CTRL ALT F9

Back 45

Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

Front 46

CTRL ALT SHIFT F9

Back 46

Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

Front 47

CTRL ARROW

Back 47

moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet.

Front 48

CTRL B

Back 48

Applies or removes bold formatting.

Front 49

CTRL C

Back 49

Copies the selected cells.

Front 50

CTRL D

Back 50

Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.

Front 51

CTRL END

Back 51

If the cursor is not in the formula bar, moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, moves the cursor to the end of the text.

Front 52

CTRL ENTER

Back 52

Fill the selected cell range with the current entry.

Front 53

CTRL F

Back 53

Displays the Find and Replace dialog box, with the Find tab selected. ___also displays this tab

Front 54

CTRL F1

Back 54

displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface.

Front 55

CTRL F10

Back 55

Maximize or restore window

Front 56

CTRL F11

Back 56

Inset 4.0 Macro sheet

Front 57

CTRL F12

Back 57

File Open

Front 58

CTRL F2

Back 58

displays the Print Preview window.

Front 59

CTRL F3

Back 59

Define name

Front 60

CTRL F4

Back 60

closes the selected workbook window.

Front 61

CTRL F5

Back 61

restores the window size of the selected workbook window in Microsoft Excel.

Front 62

CTRL F6

Back 62

switches to the next workbook window when more than one workbook window is open.

Front 63

CTRL F7

Back 63

performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.

Front 64

CTRL F8

Back 64

performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.

Front 65

CTRL F9

Back 65

Minimize workbook

Front 66

CTRL G

Back 66

Displays the Go To dialog box.

Front 67

CTRL H

Back 67

Displays the Find and Replace dialog box, with the Replace tab selected.

Front 68

CTRL HOME

Back 68

moves to the beginning of a worksheet.

Front 69

CTRL I

Back 69

Applies or removes italic formatting in Microsoft Excel.

Front 70

CTRL K

Back 70

Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.

Front 71

CTRL N

Back 71

Creates a new, blank workbook.

Front 72

CTRL O

Back 72

Displays the Open dialog box to open or find a file.

Front 73

CTRL P

Back 73

Displays the Print dialog box.

Front 74

CTRL PAGE DOWN

Back 74

moves to the next sheet in a workbook.

Front 75

CTRL PAGE UP

Back 75

moves to the previous sheet in a workbook.

Front 76

CTRL R

Back 76

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.

Front 77

CTRL S

Back 77

Saves the active file with its current file name, location, and file format.

Front 78

CTRL SHIFT A

Back 78

inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.

Front 79

CTRL SHIFT ARROW

Back 79

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

Front 80

CTRL SHIFT END

Back 80

Extends the selection of cells to the last used cell on the worksheet (lower-right corner).

Front 81

CTRL SHIFT F or CTRL SHIFT P

Back 81

opens the Format Cells dialog box with the Font tab selected.

Front 82

CTRL SHIFT F12

Back 82

Print

Front 83

CTRL SHIFT F3

Back 83

Create name by using names of row and column labels

Front 84

CTRL SHIFT F6

Back 84

Previous workbook window

Front 85

CTRL SHIFT HOME

Back 85

extends the selection of cells to the beginning of the worksheet.

Front 86

CTRL SHIFT O

Back 86

selects all cells that contain comments in Microsoft Excel.

Front 87

CTRL SHIFT PAGE DOWN

Back 87

selects the current and next sheet in a workbook.

Front 88

CTRL SHIFT PAGE UP

Back 88

selects the current and previous sheet in a workbook.

Front 89

CTRL SHIFT SPACEBAR

Back 89

selects the entire worksheet. If the worksheet contains data, ___ selects the current region. Pressing ___ a second time selects the current region and its summary rows. Pressing ___ a third time selects the entire worksheet.

Front 90

CTRL SHIFT TAB

Back 90

switches to the previous tab in a dialog box; In a workbook: activate previous workbook

Front 91

CTRL SHIFT U

Back 91

switches between expanding and collapsing of the formula bar.

Front 92

CTRL SHIFT Z

Back 92

uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.

Front 93

CTRL SPACEBAR

Back 93

selects an entire column in a worksheet.

Front 94

CTRL T

Back 94

Displays the Create Table dialog box in Microsoft Excel.

Front 95

CTRL TAB

Back 95

In a workbook: activate next workbook; In toolbar: next toolbar

Front 96

CTRL U

Back 96

Applies or removes underlining.

Front 97

CTRL V

Back 97

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.

Front 98

CTRL V

Back 98

Paste

Front 99

CTRL W

Back 99

Close

Front 100

CTRL W

Back 100

Closes the selected workbook window.

Front 101

CTRL X

Back 101

Cuts the selected cells.

Front 102

CTRL Y

Back 102

Repeats the last command or action, if possible in Microsoft Excel.

Front 103

CTRL Z

Back 103

Uses the Undo command to reverse the last command or to delete the last entry that you typed.

Front 104

DELETE

Back 104

Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments. In cell editing mode, it deletes the character to the right of the insertion point.

Front 105

END

Back 105

Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on. Also selects the last command on the menu when a menu or submenu is visible.

Front 106

ENTER

Back 106

Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default). In a data form, it moves to the first field in the next record. Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command. In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button).

Front 107

ESC

Back 107

Cancels an entry in the cell or Formula Bar in Microsoft Excel. Closes an open menu or submenu, dialog box, or message window. 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.

Front 108

F1

Back 108

Displays the Microsoft Office Excel Help task pane.

Front 109

F10

Back 109

Activate Menubar

Front 110

F11

Back 110

Creates a chart of the data in the current range.

Front 111

F12

Back 111

Displays the Save As dialog box.

Front 112

F2

Back 112

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.

Front 113

F3

Back 113

Displays the Paste Name dialog box.

Front 114

F4

Back 114

Repeats the last command or action, if possible; While typing a formula, switch between absolute/relative refs

Front 115

F5

Back 115

Displays the Go To dialog box.

Front 116

F6

Back 116

Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), ___ includes the split panes when switching between panes and the Ribbon area.

Front 117

F7

Back 117

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

Front 118

F8

Back 118

Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.

Front 119

F9

Back 119

Calculates all worksheets in all open workbooks.

Front 120

HOME

Back 120

Moves to the beginning of a row in a worksheet. Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on. Selects the first command on the menu when a menu or submenu is visible.

Front 121

PAGE DOWN

Back 121

Moves one screen down in a worksheet.

Front 122

PAGE UP

Back 122

Moves one screen up in a worksheet.

Front 123

SHIFT ARROW

Back 123

extends the selection of cells by one cell.

Front 124

SHIFT F10

Back 124

displays the shortcut menu for a selected item in Microsoft Excel.

Front 125

SHIFT F11

Back 125

inserts a new worksheet.

Front 126

SHIFT F12

Back 126

Save

Front 127

SHIFT F2

Back 127

adds or edits a cell comment.

Front 128

SHIFT F3

Back 128

displays the Insert Function dialog box.

Front 129

SHIFT F4

Back 129

repeats the last Find action.

Front 130

SHIFT F5

Back 130

Find

Front 131

SHIFT F6

Back 131

switches between the worksheet, Zoom controls, task pane, and Ribbon in a reverse direction.

Front 132

SHIFT F8

Back 132

enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.

Front 133

SHIFT F9

Back 133

calculates the active worksheet in Microsoft Excel.

Front 134

SHIFT SPACEBAR

Back 134

selects an entire row in a worksheet.

Front 135

SHIFT TAB

Back 135

moves to the previous cell in a worksheet or the previous option in a dialog box in Microsoft Excel.

Front 136

SPACEBAR

Back 136

In a dialog box, performs the action for the selected button, or selects or clears a check box.

Front 137

TAB

Back 137

Moves one cell to the right in a worksheet. Moves between unlocked cells in a protected worksheet. Moves to the next option or option group in a dialog box.