Excel common shortcut keys

Source: Internet
Author: User
Tags extend split

Move and scroll through worksheets

Move the cell arrow keys up, down, left, or right

Move to the edge of the current data area Ctrl + ARROW keys

Move to the beginning of 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

Scrolls and displays 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

Move TAB between unlocked cells in a protected worksheet

Move on a worksheet while in end mode

Turn end mode end on or off

Move the end in a row or column as a block of data, 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 through a worksheet while in scroll lock mode

Turn on or off SCROLL lock SCROLL lock

Move to cell home in the upper-left corner of the window

Move to cell end in the lower-right corner of the window

Scroll up or down one row of arrow or DOWN ARROW keys

Scroll one column left or right ARROW key to left or right

For previewing and printing documents

Display the Print dialog box ctrl+p

When in print preview

Move the arrow keys in the document when the display is enlarged

When you zoom out, scroll one page up in the document at a time

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 key

For worksheets, charts, and macros

Insert new worksheet shift+f11

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

Displays 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 the previous workbook shift+ctrl+page up

Use to enter data in a worksheet

Complete the cell entry and move the Enter down in the selected area

Fold rows in a cell alt+enter

Fills the selected range of cells with the current entry Ctrl+enter

Complete the cell entry and move up the Shift+enter in the selected area

Complete the cell entry and move the TAB right in the selected area

Complete the cell entry and move left Shift+tab in the selected area

Cancel Cell Entry ESC

Deletes the character to the left of the insertion point, or deletes the selected area BACKSPACE

Deletes the character to the right of the insertion point, or deletes the selected area delete

Delete the insertion point to the end of the line Ctrl+delete

Move one character arrow key up or down

Move to the beginning of home

Repeat the last action F4 or ctrl+y

Edit cell Annotation Shift+f2

Create name by row or column flag ctrl+shift+f3

Fill Down Ctrl+d

Fill Ctrl+r Right

Define name Ctrl+f3

Set data format

Display the Style dialog box ALT + ' (apostrophe)

Display the Format Cells dialog box ctrl+1

Apply the General number format ctrl+shift+~

Apply a "currency" format with two decimal places ctrl+shift+$

Apply a percent format with no decimal places ctrl+shift+%

Apply the "scientific notation" number format with two decimal places ctrl+shift+^

Apply Date format ctrl+shift+#

Apply the hour and minute "time" format and indicate the morning or afternoon ctrl+shift+@

Applies with a thousand separator and a minus sign (-) for negative numbers ctrl+shift+!

Apply the outer frame ctrl+shift+&

Remove outer border ctrl+shift+_

Apply or remove font bold formatting ctrl+b

Apply or remove font italic formatting ctrl+i

Apply or remove underline formatting ctrl+u

Apply or remove strikethrough formatting ctrl+5

Hide Rows Ctrl+9

Unhide Line ctrl+shift+ (left parenthesis

Hidden column ctrl+0 (0)

Unhide column ctrl+shift+) right parenthesis

Edit Data

Edit the active cell and place the insertion point at the end of the line F2

Cancel an entry in a cell or formula bar ESC

Edit the active cell and clear its contents BACKSPACE

Paste the name of the definition into the formula F3

Complete the cell Enter enter

Enter the formula as an array formula Ctrl+shift+enter

After you type the function name in the formula, show the Formula Palette Ctrl + A

Insert the variable name and parentheses for the function after you type the function name in the formula Ctrl+shift+a

Displays the spelling checker dialog box. F7 Key

Inserting, deleting, and copying selected areas

Copy selected area Ctrl + C

Cut the selected area Ctrl+x

Paste Selected Area Ctrl + V

Clears the contents of the selection DELETE

Delete selected Area Ctrl + HYPHEN

Undo the last Action Ctrl+z

Insert blank cell ctrl+shift+ Plus

Move within the selected area

Moves up and down in the selected area. ENTER

Moves from bottom to top in the selected area. Shift+enter

Moves from left to right in the selected area. TAB

Moves from right to left in the selected area. Shift+tab

Moves clockwise to the next corner of the selected range. Ctrl+period

Move right to nonadjacent selection ctrl+alt+ right ARROW key

Move left to nonadjacent selected area ctrl+alt+ left ARROW key

Select a cell, column, or row

Select the area around the current cell ctrl+shift+* (asterisk)

Extend the selection one cell width shift+ arrow keys

The selected range extends to the last Non-empty cell in the same column as the cell ctrl+shift+ arrow keys

Extend the selection to the beginning of the line Shift+home

Extend the selection to the beginning of the worksheet ctrl+shift+home

Extend the selected range to the last cell used in the worksheet ctrl+shift+end

Select an entire column Ctrl+spacebar

Select Entire Row Shift+spacebar

Select Entire Worksheet Ctrl + A

Select cells only if more than one cell is selected Shift+backspace

Extend the selection down one screen shift+page down

Extend the selection up one screen shift+page up

An object is selected and all objects on the worksheet are selected Ctrl+shift+spacebar

Toggle between hidden objects, display objects, and object placeholders Ctrl+6

Show or hide the Standard toolbar ctrl+7

Use the arrow keys to start the Extended Select Area feature F8

Add cells from another range to the selected area Shift+f8

Extend the selection to cell ScrollLock in the upper-left corner of the window, shift+home

Extend the selection to cell scrolllock in the lower-right corner of the window, shift+end

Expand the selected area when in end mode

Turn end mode end on or off

Extend the selected range to the last Non-empty cell end of the cell's same row, shift+ arrow keys

Extend the selection to the last cell end that contains data on the worksheet, Shift+home

Extend the selection to the last cell end in the current row, Shift+enter

Select a cell containing special characters

Select the current area around the active cell ctrl+shift+* (asterisk)

Selects the current array, which is the array to which the active cell belongs ctrl+/

Select all cell ctrl+shift+o with annotations (letter O)

Select the cell in the row that does not match the value of the active cell in the row. CTRL +

Select the cells in the column that do not match the values of the active cells in the column. ctrl+shift+|

Selects the direct reference cell ctrl+[(opening parenthesis) of a formula in the current selection

Selects all cells that are directly or indirectly referenced by the formula in the current selection ctrl+shift+{left curly braces

Select only the cell containing the formula that references the current cell CTRL +] (right bracket)

Select all cells with formulas that refer directly or indirectly to the right brace in the current cell ctrl+shift+}

Select only the visible cells in the current selection ALT +; Semicolon

Select chart sheet

Select the next sheet in the workbook. Ctrl+page down

Select the previous worksheet in the workbook. Ctrl+page up

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.