OzGrid

General Shortcut Keys

< Back to Search results

 Category: [Excel]  Demo Available 

 

General Shortcut Keys

 

Alt or F10:

Turn key tips on or off

Alt+A:

Go to the Data tab

Alt+F:

Open the File tab menu

Alt+F1:

Create an embedded bar chart based on select data (same sheet)

Alt+F11:

Open the Microsoft Visual Basic For Applications Editor

Alt+F8:

Create, run, edit, or delete a macro

Alt+H:

Go to the Home tab

Alt+M:

Go to the Formulas tab

Alt+N:

Open the Insert tab

Alt+P:

Go to the Page Layout tab

Alt+Q:

Go to the “Tell me what you want to do” box

Alt+R:

Go to the Review tab

Alt+W:

Go to the View tab

Alt+X:

Go to the Add-ins tab

Alt+Y:

Go to the Help tab

Ctrl+F:

Search in a spreadsheet, or use Find and Replace

Ctrl+F1:

Show or hide the ribbon

Ctrl+F2: 

Switch to Print Preview

Ctrl+F4:

Close Excel

Ctrl+F9:

Minimize the workbook window

Ctrl+N:

Create a new workbook

Ctrl+O:

Open an existing workbook

Ctrl+S:

Save a workbook

Ctrl+Shift+U:

Expand or collapse the formula bar

Ctrl+Tab:

Switch between open workbooks

Ctrl+W:

Close a workbook

Ctrl+Y:

Redo an action

Ctrl+Z:

Undo an action

F1:

Open the Help pane

F11:

Create a bar chart based on selected data (on a separate sheet)

F12:

Open the Save As dialog box

F4:

Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.

F7:

Check spelling

F9:

Calculate all worksheets in all open workbooks

Shift+F11:

Insert a new worksheet

Shift+F3:

Insert a function

Shift+F9:

Calculate active worksheets

 

See also:

Formatting Cells Shortcut List

 

Free Training Course: Lesson 1 - Excel Fundamentals

 

See also: Index to Excel VBA Code; Index to Excel Freebies; Lesson 1 - Excel Fundamentals; Index to how to… providing a range of solutions

 

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.

 


Gallery



stars (0 Reviews)