Keyboard Shortcuts by Key

This section lists the available keyboard shortcuts according to their position on the keyboard.

Table B-1. Function Keys

Press

To

F1

Display the Help window.

Ctrl+F1

Show/hide the ribbon.

Alt+F1

Insert a chart as an object.

Shift+Alt+F1

Insert a new worksheet.

Ctrl+Alt+F1

Insert a Microsoft Excel 4 macro worksheet.

F2

Toggle Selection, Edit, and Enter/Point modes.

Shift+F2

Insert/edit a comment.

Alt+F2

Display the Save As dialog box.

Shift+Alt+F2

Save

Ctrl+Alt+F2

Display the Open dialog box.

Shift+Ctrl+Alt+F2

Display the Print dialog box.

F3

Display the Paste Name dialog box.

Shift+F3

Display the Insert Function dialog box.

Ctrl+F3

Display the Name Manager dialog box.

Shift+Ctrl+F3 ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.