Excel Common shortcut key Encyclopedia

Excel table simple but not easy, below share some commonly used shortcut keys, is said to be the investment bank practitioner commonly used, has the need friend to be able to study well the study ~

1> shortcuts Move and scroll the cell arrow keys up, down, left, or right on the worksheet

Move to the edge of the current data range: Ctrl + ARROW keys

Move to the beginning of the line: Home

Move to the beginning of a worksheet: Ctrl+home

Move to the last cell in the worksheet. : Ctrl+end

Move down one screen: PAGE down

Move up one screen: PAGE up

Move one screen to the right: Alt+page down

Move one screen to the left: Alt+page up

Move to the next worksheet in the workbook: Ctrl+page down

Move to the previous worksheet in the workbook: Ctrl+page up

Move to the next workbook or window: Ctrl+f6 or Ctrl+tab

Move to a previous workbook or window: Ctrl+shift+f6

Move to the next pane in a split workbook: F6

Move to the previous pane in the Split workbook: Shift+f6

Scroll and display the active cell: ctrl+backspace

Display the Locate dialog box: F5

Display the Find dialog box: Shift+f5

Repeat the last Find action: SHIFT+F4

To move between unlocked cells in a protected worksheet: TAB

2>excel in the worksheet when the shortcut key is in end mode

Turn end mode on or off: End

Move within a row or column as a block of data: end, arrow keys

Move to the last cell in the worksheet.: End, home

Moves to the right to the last nonblank cell in the current row. : End, ENTER

Move the 3>excel shortcut key to the worksheet while in scroll lock mode

Turn scroll LOCK on or off: SCROLL lock

Move to a cell in the upper-left corner of a window: Home

Move to the cell at the lower-right corner of the window: End

Scroll up or down one line: up ARROW or DOWN arrow

Scroll one column to the left or right: the left ARROW key or the RIGHT ARROW key

4>excel shortcut keys for previewing and printing documents

Display the Print dialog box: ctrl+p

When in print preview:

Move through the document when the display is enlarged: arrow keys

When you zoom out, scroll one page at a time in the document: Page UP

When the display is reduced, scroll to the first page: CTRL + UP ARROW keys

When the display is reduced, scroll to the last page: CTRL + DOWN ARROW keys

5>excel shortcut keys for worksheets, charts, and macros

Insert new worksheet: SHIFT+F11

Create a chart that uses the current area: F11 or ALT+F1

Display the Macros dialog box: Alt+f8

Display the Visual Basic Editor: alt+f11

Insert Microsoft EXCEL 4.0 macro sheet: ctrl+f11

Move to the next worksheet in the workbook: Ctrl+page down

Move to the previous worksheet in the workbook: Ctrl+page up

Select the current and next worksheets in the workbook: Shift+ctrl+page down

Select the current workbook or previous workbook: Shift+ctrl+page up