Workplace Skills: Excel operations

Shortcut Key: Move and scroll up, down, left, or right in the worksheet move the cell arrow
Move to the edge of the current data area: Ctrl + arrow
Move to the beginning of the row: Home
Move to the beginning of the worksheet: Ctrl + home
Move to the last cell of the worksheet. : Ctrl + end
Move a screen down: Page down
Move one screen up: page up
Move the screen to the right: Alt + Page down
Move the 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 the previous workbook or window: Ctrl + Shift + F6
Move to the next pane of the split workbook: F6
Move to the previous pane of the split workbook: Shift + F6
Scroll and display the active cells: Ctrl + backspace
The "locate" dialog box is displayed: F5
Show "Search" dialog box: Shift + F5
Repeat the previous "Search" Operation: Shift + F4
Move Between unlocked cells in the worksheet: Tab

2> move in worksheet when the Excel shortcut is in end Mode
Enable or disable the end mode: End
Move in data blocks in one row or column: end, arrow key
Move to the last cell of the worksheet.: end, home
Move to the right of the current row to the last non-blank cell. : End, enter

3> move in worksheet when the Excel shortcut is in scroll lock mode
Turn on or off the scroll lock: Scroll lock
Move to the cell: Home in the upper left corner of the window.
Move to the cell at the bottom right corner of the window: End
Scroll up or down a row: Up or down
Scroll a column to the left or right: Left or right arrow

4> Excel shortcut keys used to preview and print documents
Display "print" dialog box: Ctrl + P
In print preview:
When you zoom in, move the: Arrow keys in the document.
When the display is reduced, one page will be rolled down each time in the document: page up
When the display is reduced, scroll to the first page: Ctrl + up arrow
Scroll down to the last page: Ctrl + down arrow

5> Excel shortcut keys for worksheets, charts, and macros
Insert a new worksheet: Shift + F11
Create a chart using the current region: F11 or Alt + F1
Display "macro" dialog box: Alt + F8
Show "Visual Basic Editor": Alt + F11
Insert Microsoft Excel 4.0 macro Worksheet: 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 worksheet and the next worksheet in the workbook: Shift + Ctrl + Page down
Select the current workbook or the previous workbook: Shift + Ctrl + page up

6> select a chart worksheet with an Excel shortcut
Select the next worksheet in the workbook: Ctrl + Page down
Select the previous worksheet in the workbook: Ctrl + page up, end, Shift + enter

7> Excel shortcut for entering data in the worksheet
Complete the cell input and move down in the selected area: Enter
Fold in cells: Alt + enter
Fill the selected cell area with the current input item: Ctrl + enter
Complete cell input and move up in the selected area: Shift + enter
Complete the cell input and move right in the selected area: Tab
Complete the cell input and move left in the selected area: Shift + Tab
Cancel Cell input: ESC
Delete the character on the left of the insertion point, or delete the selected area: backspace
Delete the characters on the right of the insert point, or delete the selected region: Delete
Delete the text inserted to the end of the row: Ctrl + Delete
Move one character up/down: arrow key
Move to the beginning of the line: Home
Repeat the last operation: F4 or Ctrl + Y
Edit cell annotation: Shift + F2
Name created by row or column flag: Ctrl + Shift + F3
Fill down: Ctrl + d
Fill in to the right: Ctrl + R
Definition name: Ctrl + F3

8> set data format for Excel shortcuts
Show "style" dialog box: Alt + '(Marker)
Display "cell format" dialog box: Ctrl + 1
Apply the "regular" numeric format: Ctrl + Shift + ~
The application uses the "coin" format with two decimal places: Ctrl + Shift + $
Percentage format for applications without decimal places: Ctrl + Shift + %
The application uses the "scientific notation" numeric format with two decimal places: Ctrl + Shift + ^
Application year month Day "date" Format: Ctrl + Shift + #
Apply the hour and minute "time" format, and indicate the morning or afternoon: Ctrl + Shift + @
The application has a thousands separator and a negative number is expressed as "-": Ctrl + Shift +!
Outer border of the application: Ctrl + Shift + &
Delete outer border: Ctrl + Shift + _
Apply or cancel the font in bold format: Ctrl + B
Apply or cancel the font skew format: Ctrl + I
Apply or cancel the underline format: Ctrl + u
Apply or cancel the strikethrough format: Ctrl + 5
Hide rows: Ctrl + 9
Unhide rows: Ctrl + Shift + (left parenthesis
Hide column: Ctrl + 0 (0)
Unhide column: Ctrl + Shift +) parentheses

9> editing data with Excel shortcuts
Edit the active cell and place the insert point at the end of the line: F2
Cancel the entry in the cell or edit column: ESC
Edit the active cell and clear its original content: backspace
Paste the defined name into the formula: F3
Complete cell input: Enter
Enter the formula as an array formula: Ctrl + Shift + enter
After you type a function name in the formula, the formula palette Ctrl + A is displayed.
After you type a function name in the formula, insert the variable name and parentheses for the function: Ctrl + Shift +.
The spelling check dialog box is displayed. : F7 key

10> insert, delete, and copy selected areas for Excel shortcuts
Copy selected region: Ctrl + c
Cut selected area: Ctrl + x
Paste the selected area: Ctrl + V
Clear the content of the selected region: Delete
Delete selected region: Ctrl + hyphen
Undo the last operation: Ctrl + z
Insert blank cells: Ctrl + Shift + plus sign

11> move an Excel shortcut in the selected area
Move from top to bottom in the selected area: Enter
Move from bottom to top in the selected area: Shift + enter
Move from left to right in the selected area: Tab
Move from right to left in the selected area: Shift + Tab
Move clockwise to the next corner of the selected area: Ctrl + Period
Move right to a non-Adjacent Area: CTRL + ALT + right arrow
Move left to a non-Adjacent Area: CTRL + ALT + left arrow

12> select cells, columns, or rows for Excel shortcuts
Select the area around the current cell: Ctrl + Shift + * (asterisk)
Extend the width of a cell in the selected area: Shift + arrow
Expand the selected area to the last non-empty cell in the same column as the cell row: Ctrl + Shift + arrow
Expand the selected area to the beginning of the line: Shift + home
Extend the selected area to the start of the worksheet: Ctrl + Shift + home
Extend the selected area to the last cell used in the worksheet: Ctrl + Shift + end
Select the entire column: Ctrl + spacebar
Select the entire row: Shift + spacebar
Select the entire Worksheet: Ctrl +
If multiple cells are selected, only the following cells are selected: Shift + backspace.
Scale down the selected area: Shift + Page down
Expand the selected area to a screen: Shift + page up
Select an object and select all objects on the worksheet: Ctrl + Shift + spacebar
Switch between hidden objects, display objects, and object placeholders: Ctrl + 6
Display or hide "commonly used" toolbar: Ctrl + 7
Use the arrow keys to expand the selected area: F8
Add cells in other regions to the selected region: Shift + F8
Expand the selected area to the cells in the upper left corner of the window: scrolllock, Shift + home
Expand the selected area to the cells in the lower-right corner of the window: scrolllock, Shift + end

13> show the selected area when the Excel shortcut is in end Mode
Enable or disable the end mode: End
Extend the selected area to the last non-empty cells in the same row of cells: end, Shift + arrow
Extend the selected area to the last cell in the worksheet that contains data: end, Shift + home
Extend the selected area to the last cell in the current row: end, Shift + enter

14> select cells with special characters for Excel shortcuts
Select the current area around the active cell: Ctrl + Shift + * (asterisk)
Select the current array, which belongs to the active cell: Ctrl +/
Select All annotated cells: Ctrl + Shift + O (letter O)
Select the cells in the row that do not match the values of the active cells 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 + |
Directly reference cells of the formula in the selected area: Ctrl + [(left square brackets)
Select All cells directly or indirectly referenced by the formula in the selected area: Ctrl + Shift + {left braces
Select only the cell where the formula for directly referencing the current cell is located: Ctrl +] (right square brackets)
Select All cells with formulas. These formulas reference the current cell directly or indirectly: Ctrl + Shift +} Right braces.