The best keyboard shortcuts to speed your day

Applies to
Microsoft Excel 2000

Some of the more common tasks in Microsoft Excel have keyboard shortcuts. For example, to insert cells, position the cursor and press CTRL+SHIFT+PLUS SIGN. The dialog box that asks which type to insert appears.

Picture of the Insert dialog box. Press CTRL+SHIFT+PLUS SIGN to insert cells

If you are entering data in a column that repeats what is already in the column, try pressing ALT+DOWN ARROW. The AutoComplete list appears for you to choose from.

Picture of the AutoComplete list. Press ALT+DOWN ARROW to display the AutoComplete list

Then use the UP ARROW and DOWN ARROW keys until the one you want is selected, and press ENTER.

There are other useful keyboard shortcuts to use for speeding your day.

Press To
SHIFT+F11 or ALT+SHIFT+F1 Insert a new worksheet
CTRL+SHIFT+PLUS SIGN Insert blank cells
F11 or ALT+F1 Create a chart that uses the current range
ALT+DOWN ARROW Display the AutoComplete list
CTRL+; (semicolon) Enter the date
CTRL+SHIFT+: (colon) Enter the time
CTRL+ENTER Fill the selected cell range with the current entry
SHIFT+F5 Display the Find dialog box
SHIFT+F4 Repeat the last Find action (same as Find Next)
F5 Display the Go To dialog box
CTRL+1 Display the Format Cells dialog box

For more information about keyboard shortcuts, type shortcuts in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.