O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Display ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required