Ctrl+A is a shortcut key for selecting all in excel tables. We often use many shortcut keys when using excel tables, but many novices may not be familiar with all the shortcut keys of excel tables. Here I send you an encyclopedia of Excel spreadsheet shortcuts, which can be collected for emergencies when necessary.

Ctrl+Home quickly moves to the beginning cell of the worksheet.

Ctrl+End quickly moves to the end of the worksheet area.

Turn the page to the previous page

PageDown turn to the next page

Tab key moves to the right

Shift+Tab key moves to the left.

Ctrl+ left arrow key moves to the left area.

Ctrl+ right arrow key moves to the right area.

Ctrl+ up arrow moves to the upper area.

Ctrl+ down arrow moves to a lower area.

Ctrl+Backspace key moves to the active cell.

Alt+PageUp moves one screen to the left.

Alt+PageDown moves one screen to the right.

F2 Press F2 in the cell to edit.

Alt+=+ automatic summation

Ctrl+Shift+9 unhide the row.

Ctrl+Shift+0 unhide the column.

Ctrl+Shift+~ is set to a common format.

Ctrl+Shift+ 1 is set to a number format.

Ctrl+Shift+2 is set to time format.

Ctrl+Shift+3 is set to date format.

Ctrl+Shift+4 is set to currency format.

Ctrl+Shift+5 is set to percentage format.

Ctrl+Shift+6 is set to scientific counting format.

Ctrl+Shift+7 applies a border.

Ctrl+Shift+- Unborder

Ctrl+Shift+8 Select the area to use.

Ctrl+~ Toggles whether formulas are displayed in cells.

Ctrl+2 toggles whether the cell range is bold.

Ctrl+3 toggles whether the cell range is italicized.

Ctrl+4 toggles whether the cell range is underlined.

Ctrl+5 toggles whether to delete the cell range.

Ctrl+9 hides the row where the cell range is located.

Ctrl+0 hides the column where the cell range is located.

ctrl+； Insert current date

ctrl+Shift+； Insert current time

Ctrl+Shift+' copies the value of the above cell into this cell.

Ctrl+B bold cell font

Ctrl+C copies the contents of a cell range.

Ctrl+Insert copies the contents of a cell range.

Ctrl+X cuts the contents of the cell range.

Ctrl+V paste cell contents

Ctrl+I makes the cell font italic.

Ctrl+U underlines the cell text.

Ctrl+Shift+F activates the font drop-down list box on the toolbar.

Ctrl+Shift+P activates the font size drop-down list box on the toolbar.

Ctrl+6 toggles whether to make some buttons on the toolbar available, that is, not grayed out.

Ctrl+7 toggles whether to display the standard toolbar.

Alt+- Pop up the shortcut menu in the upper left corner of Excel.

Alt+ spacebar pops up the shortcut menu in the upper left corner of Excel.

Shift+F8 can continuously select nonadjacent areas.

Shift+Ctrl+O Select the cells with comments in the worksheet.

Shift+ left arrow key to select the left area.

Shift+ Right arrow to select the area on the right.

Shift+ up arrow key to select the area up.

Shift+ down arrow to select the area down.

Shift+ space selects the row of the cell.

Alt+F activates the file menu.

Alt+E activates the edit menu.

Alt+V activates the view menu.

Alt+I activates the insert menu.

Alt+O activates the format menu.

Alt+T activates the tools menu.

Alt+D activates the data menu.

Alt+W activates the window menu.

Alt+H activates the help menu.

Move to the next worksheet in the workbook.

Move to the previous worksheet in the workbook Ctrl+PageUp

Select the current worksheet and the next worksheet.

Deselect multiple worksheets.

Select another worksheet Ctrl+PageUp.

Select the current worksheet and the previous worksheet Shift+Ctrl+PageUp.

Rename the current worksheet Alt+O H R

Move or copy the current worksheet

Delete the current worksheet

Move down one page.

Move up one page.

Move one screen Alt+page down to the right.

Move one screen Alt+page to the left.

Switch to the next pane in the split worksheet Ctrl+F6.

In a split worksheet, press Shift+F6 to switch to the previous pane.

Scroll to display the active cell Ctrl+Backspace.

The Positioning dialog box F5 pops up.

The search dialog box Shift+F5 pops up.

Find the next shift +F4

Move Tab between unlocked cells on a protected worksheet.

Move carriage return from top to bottom in the selected area.

In the selected area, move Shift+Enter from bottom to top.

Move from left to right in the selected area. If you select a cell in a single column, the tab will move down.

Move from right to left in the selected area. If cells in a single column are selected, Shift+Tab will move up.

Move clockwise to the next corner of the selected area.

In nonadjacent selected areas, switch to the next selected area. Right Ctrl+Alt+ Right Arrow key.

Switch left to the next nonadjacent selected area.

Turn End mode on or off.

Turn the scroll lock on or off.

Scroll up or down a line of up or down keys.

Scroll a column of left or right keys to the left or right.

Excel selects cells, rows and columns, and object shortcuts.

Select the entire column Ctrl+ space bar.

Select the entire line Shift+ space bar.

Select the entire worksheet ctrl+a.

When multiple cells are selected, only the active cell Shift+Backspace is selected.

After selecting an object, select all the objects on the worksheet Ctrl+Shift+ SPACEBAR.

Toggles Ctrl+6 between hidden objects, displayed objects, and displayed object placeholders.

In the selected row, select the cell that does not match the value in the active cell Ctrl+\.

In the Selected column, select the cell Ctrl+Shift+| that does not match the value in the active cell.

Turn extended mode F8 on or off.

Extend the selected area to the beginning of the Shift+Home line.

Extend the selection to the beginning of the worksheet.

Extend the selection to the lower right corner of the last used cell on the worksheet.

Extend the selected area down by one screen Shift+PageDown.

Extend the selected area upward by one screen Shift+PageUp.

Extend the selected range to the lower right corner of the last used cell in the worksheet: End+Shift+Home.

Extend the selected area to the last cell of the current row End+Shift+Enter.

Expand the selected area to the cell ScrollLock+Shift+Home in the upper left corner of the window.

Expand the selected area to the cell ScrollLock+Shift+End in the lower right corner of the window.

Complete cell input and select the next cell and press enter.

Wrap Alt+Enter in a cell

Fills the selected cell range with the current entry.

Complete cell input and select the previous cell Shift+Enter up.

Complete cell entry and select the next cell tab on the right.

Complete cell input and select the previous cell Shift+Tab to the left.

Cancel cell input

Repeat the last operation F4 or CTRL+Y.

The name Ctrl+Shift+F3 is created by the column symbol.

Fill down Ctrl+D

Fill Ctrl+R to the right.

Define the name Ctrl+F3

Edit hyperlink Ctrl+K

Activate hyperlink carriage return

Enter the date ctrl+;

Enter time Ctrl+Shift+:

Displays the value drop-down list Alt+ down arrow in the current column of the list.

Create a chart and selected chart elements

Create a data chart in the current area F 1 1 or Alt+F 1.

Select the previous group of elements in the down arrow of the chart.

Select the next set of elements in the up arrow of the chart.

Select the next element in the group and right-click.

Select the previous element in the group left key.

Move to the same field of the next record down arrow.

Move to the same field in the previous record, and then press the up key.

Move to each field in the record, then to each command button tab and Shift+Tab.

Move to the first field Enter of the next record.

Move to the first field of the previous record.

Move down to the same field of the previous 10 records.

Start a new blank record Ctrl+Page Down.

Move to the same field of the last 10 record.

Move to the first record Ctrl+Page Up

Move to start or end field

Extend the selected range to the end of the field Shift+End.

Extend the selected area to the beginning of the field Shift+Home.

Move the characters in the field left or right.

Select a character on the left in the Shift+ Left Arrow field.

Select the character on the right in the Shift+ Right Arrow field.

Select the next down arrow in the AutoFilter list.

Select the previous up arrow in the AutoFilter list.

Turn off the autofilter list Alt+ up arrow for the current column.

Select the "All" home page of the first item in the autofilter list.

Select the end of the last item in the autofilter list.

Filter the area input according to the options in the AutoFilter list.

Show, hide, and summarize data shortcuts

Combine row or column Alt+Shift+ right arrow key

Ungroup rows or columns Alt+Shift+ left arrow key

Show or hide the outline symbol Ctrl+8.

Hide the selected row Ctrl+9

Hide the selected column Ctrl+0

Undo the last operation Ctrl+Z

Input and calculation formula

Type the formula =

After closing the editing state of the cell, move the * * point in the edit bar to F2.

Enter Ctrl+Shift+ Enter the formula as an array formula.

Cancel the input Esc in the cell or edit bar

Paste the defined name into formula F3.

Use the sum function * * "automatic sum" formula Alt+=

Copy the value in the cell above the active cell to the current cell or the edit bar Ctrl+Shift+ "

Copy the formula in the cell above the active cell to the current cell or the edit bar Ctrl+'

Toggles Ctrl+ ` between displaying cell values and displaying formulas.

The spelling check dialog box F7 pops up.

Edit cell annotation Shift+F2

Copy the selected cell Ctrl+C

Cut the selected cell Ctrl+X

Paste the copied cell ctrl+v.

Clear the contents of the selected cell.

Delete the selected cell Ctrl+ hyphen.

Insert blank cell Ctrl+Shift+ plus sign

Pop-up style dialog Alt+'

The cell format dialog Ctrl+ 1 pops up.

Uncheck the hidden state of all hidden lines in the selected area Ctrl+Shift+ (

Unhides all hidden columns in the selected area.

Apply the outer border Ctrl+Shift+& to the selected cell;

Uncheck the outer border of the selected cell Ctrl+Shift+_

Use the Borders tab in the Format Cells dialog box.

Apply or cancel top border Alt+T

Apply or cancel bottom border Alt+B

Apply or cancel left border Alt+L

Apply or cancel Alt+R in the right box.

If cells in multiple rows are selected, the horizontal separator Alt+H will be applied or cancelled.

If cells in multiple columns are selected, the vertical separator Alt+V is applied or cancelled.

Apply or cancel the lower diagonal border Alt+D

Apply or cancel the upper diagonal border Alt+U