Commonly used Excel shortcut – Do excel work fast

0
43
excel shortcut

This article continues to be a small series of computer technology network for everyone to bring the tutorial is: “Commonly used Excel shortcuts summary”, I believe that everyone on excel this software is not a small bar, right? Today’s computer technology network Theencarta for everyone to share is some shortcuts, I hope to help everyone!

50+ Commonly used Excel shortcut 

      • Move and scroll in the worksheet
      • Move 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 the home HOME
      • Move to the beginning of the worksheet CTRL+HOME
      • Move to the last cell of 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 the previous workbook or window CTRL+SHIFT+F6
      • Move to the next pane F6 in the split workbook
      • Move to the previous pane in the split workbook SHIFT+F6
      • Scroll and display the active cell CTRL+BACKSPACE
      • Display the Positioning dialog box F5
      • Display the Find dialog SHIFT+F5
      • Repeat the last “find” operation SHIFT+F4
    • Move TAB between unlocked cells in the protection sheet
    • Move in the worksheet while in END mode
    • Turn END mode on or offEND
    • Move END in units of data blocks in a row or column, arrow keys
    • Move to the last cell of the worksheet. END, HOME
    • Moves to the right in the current line to the last non-blank cell. END, ENTER
    • Move in the worksheet while in “roll lock” mode
    • Turn scroll lock SCROLL LOCK on or off
    • Move to the cell HOME at the top left corner of the window
    • Move to the cell at the bottom right corner of the window END
    • Scroll up or down one line up arrow or down arrow
    • Scroll left or right with a column of left or right arrow keys
    • Used to preview and print documents
    • Display the “Print” dialog box CTRL+P
    • When in print preview
    • Move the arrow keys in the document when zoomed in
    • When zooming out, scroll one page per page in the document PAGE UP
    • When zooming out, scroll to the first page CTRL+Up Arrow
    • When zooming out, scroll to the last page CTRL+down arrow
    • For worksheets, charts, and macros
    • Insert new worksheet SHIFT+F11
    • Create a chart F11 or ALT+F1 that uses the current region
    • Display the “Macro” dialog box ALT+F8
    • Display “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
    • O)
    • Select cells in the row that do not match the values ​​of the active cells in the row. CTRL+\
    • Select cells in the column that do not match the values ​​of the active cells in the column. CTRL+SHIFT+|
    • Select the direct reference cell of the formula in the currently selected area CTRL+[ (left bracket)
    • Select all cells in the currently selected region that are directly or indirectly referenced by the formula CTRL+SHIFT+{left brace
    • Only select the cell where the formula that directly references the current cell is located CTRL+] (right square bracket)
    • Select all cells with formulas that directly or indirectly reference the current cell CTRL+SHIFT+}right braces
    • Only select visible cells in the currently selected area ALT+; (semicolon)
    • Select chart worksheet
    • Select the next worksheet in the workbook. CTRL+PAGE DOWN
    • Select the previous worksheet in the workbook. CTRL+PAGE UP

LEAVE A REPLY

Please enter your comment!
Please enter your name here