Keyboard Shortcuts for Microsoft Excel 2007

Document Contents

🔺Finding and using keyboard shortcuts

🔺Microsoft Office basics.............

🔺Use dialog boxes........

🔺Use edit boxes within dialog boxes.......

🔺Use the Open and Save As dialog boxes..

🔺Undo and redo actions...........

🔺Access and use task panes and galleries...

🔺Close a task pane

🔺Move a task pane........

🔺Resize a task pane.

🔺Access and use smart tags......

🔺Navigating the Office Fluent Ribbon..

🔺Change the keyboard focus without using the mouse..

🔺 Common tasks in Microsoft Excel.............

🔺 CTRL combination shortcut keys......

🔺 Function keys......

🔺 Other useful shortcut keys..............

Enters the current date.

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

Copies a formula from the cell above the active cell into the

cell or the Formula Bar.

Displays the Format Cells dialog box.

Applies or removes bold formatting.

Applies or removes italic formatting.

Applies or removes underlining.

Applies or removes strikethrough.

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

Displays or hides the outline symbols.

Hides the selected rows.

Hides the selected columns.

Selects the entire worksheet.

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

Download Microsoft Excel Shortcut Pdf

When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.

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