Excel shortcut summary

A lot of cattle and gods in Excel can basically use the mouse and keyboard to achieve the purpose of fast operation, you can use the flow of water to describe, you also want to implement Excel for fast operation must understand and fully grasp the Excel shortcuts, the following small series Just to sort out the shortcuts of Excel. Move and scroll up, down, left or right in the worksheet Move the cell arrow keys to the edge of the current data area CTRL+ Arrow keys move to the beginning of the line HOME moves to the beginning of the worksheet CTRL+HOME moves to the last cell of the worksheet grid. CTRL+END moves down one screen PAGE DOWN moves up one screen PAGE UP moves one screen to the right ALT+PAGE DOWN moves left one screen ALT+PAGE UP moves to the next worksheet in the workbook CTRL+PAGE DOWN moves to work Move the previous worksheet CTRL+PAGE UP to the next workbook or window CTRL+F6 or CTRL+TAB to move to the previous workbook or window CTRL+SHIFT+F6 to move to the next window in the split workbook F6 moves to the previous pane in the split workbook SHIFT+F6 scrolls and displays the active cell CTRL+BACKSPACE display "Location" dialog box F5 shows "Find" dialog SHIFT+F5 repeat One "Find" operation SHIFT+F4 moves between non-locked cells in the protection worksheet. Moves in the worksheet when the TAB is in END mode. Opens or closes in the worksheet. END mode END moves in units of data in one row or column. END, the arrow keys move to the last cell of the worksheet. END, HOME moves to the right in the current row to the last non-blank cell. END, ENTER is in the "scroll lock" mode when moving in the worksheet to open or close the scroll lock SCROLL LOCK moves to the upper left corner of the window where the cell HOME moves to the cell at the lower right corner of the window END scrolls up or down Scroll up or down a row of left or right arrow keys on a line to preview and print the document display <;Print” Dialog CTRL+P When zoomed in, when in print preview, Moving arrow keys in the document When zooming out, scrolling one page at a time in the document PAGE UP When zooming out, scroll to the first page CTRL + up arrow When scrolling down, scroll to the last page CTRL + down arrow for work Tables, charts, and macros are inserted into the new worksheet SHIFT+F11 to create a chart using the current area &nnbsp; SHIFT+PAGE DOWN to expand the selected area up one screen SHIFT+PAGE UP selects an object, selects all on the worksheet Object CTRL+SHIFT+SPA CEBAR toggles between hidden objects, display objects and object placeholders CTRL+6 Show or hide "General" toolbar CTRL+7 Use the arrow keys to start the function of expanding the selected area F8 Add cells from other areas to In the selected area, SHIFT+F8 expands the selected area to the cell SCROLLLOCK in the upper left corner of the window, and SHIFT+HOME expands the selected area to the cell SCROLLLOCK, SHIFT+END in the lower right corner of the window.