Excel 快捷键大全(3)

excel shortcut..

Shortcuts Used With Files and Folders

ALT+1

Go to the previous folder

ALT+2 or ..

Up One Level : open the folder up one level above the open folder

ALT+3

Search the Web button: close the dialog box and open your Web search page

ALT+4

Delete the selected folder or file

ALT+5

Create New Folder

ALT+6

Views: switch among available folder views

ALT+7 or ALT+L

Tools button: show the Tools menu

SHIFT+F10

Display a shortcut menu for a selected item such as a folder or file

TAB

Move between options or areas in the dialog box

F4 or ALT+I

Open the Look in list

F5

Refresh the file list

Shortcuts Used in Printing

CTRL+P or CTRL+SHIFT+F12

Display the Print dialog box.

Shortcuts Used in Print Preview… (Use Alt P V)

Arrow keys

Move around the page when zoomed in.

PAGE UP or PAGE DOWN

Move by one page when zoomed out.

CTRL+UP ARROW or CTRL+LEFT ARROW

Move to the first page when zoomed out.

CTRL+DOWN ARROW or CTRL+RIGHT ARROW

Move to the last page when zoomed out.

Worksheet Controls

SHIFT+F11 or ALT+SHIFT+F1

Insert a new worksheet.

CTRL+PAGE DOWN

Move to the next sheet in the workbook.

CTRL+PAGE UP

Move to the previous sheet in the workbook.

SHIFT+CTRL+PAGE DOWN

Select the current and next sheet. To cancel selection of multiple sheets,

press CTRL+PAGE DOWN or, to select a different sheet, press CTRL+PAGE UP.

SHIFT+CTRL+PAGE UP

Select the current and previous sheet.