What are the shortcut keys for selecting all rows in excel and selecting all rows in excel tables? If you master the shortcut keys of excel, you can skillfully apply excel. The following lists the most commonly used shortcut keys in excel for your reference.

Excel table select all rows shortcut key:

Shortcuts for all rows are not selected in the Excel table. Just click on the number in front of the line. As shown in the figure:

Excel shortcut encyclopedia:

I. menu and toolbar operations

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.

F 10 activation menu

Shfit+F 10 activates the right-click menu.

[Note] When using shortcut keys to activate the menu, you can use the up and down arrow keys to move in the menu bar. For submenus, you can use the left and right arrow keys to move. After moving to the desired menu command, press Enter to run the command.

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 buttons on some toolbars are available (that is, not grayed out).

ctrl+7(& amp； ) 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.

Second, the editing operation

F2 Press F2 in the cell to edit.

Shift+F2 Press Shift+F2 in the cell to annotate and edit the cell.

F4 repeats the previous operation, that is, if the previous operation is to bold a cell font, pressing F4 in another cell will directly bold the cell font.

Ctrl+Y repeats the previous operation, that is, if the previous operation is to bold a cell font, pressing F4 in another cell will directly bold the cell font.

Ctrl+Z undo operation

Shift+F4 finds empty cells in the cell range and moves between them. If the worksheet is empty, a message box "Excel cannot find the data being searched" will pop up.

F7 quickly calls up the spelling dialog box to check the spelling of the selected 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+D realizes the drop-down filling function. That is, after entering a number in a cell, select the column area containing the cell and press Ctrl+D, then the column area will be filled with the same value as the first cell.

Ctrl+R realizes the right padding function. That is, press Ctrl+R after selecting a row area in a cell, and the row area will be filled with the same value as the first cell.

Ctrl+I makes the cell font italic.

Ctrl+U underlines the cell text.

Ctrl+~ (`) toggles whether the formula is displayed in the cell.

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+Shift+9 () unhide the row.

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

Ctrl+Shift+0 () unhide the column.

Ctrl+- Delete the part where the cell is located, that is, the delete dialog box pops up. If the whole row or column is selected, it will be deleted directly, and the delete dialog box will not pop up. If you select a whole line and press this key combination, the line will be deleted.

Ctrl+Shift+~ (`) is set to common format.

Ctrl+Shift+ 1(！ ) is set to digital format.

Ctrl+Shift+2(@) is set to the 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(& amp； ) Apply borders

Ctrl+Shift+- Unborder

Ctrl+Shift+8(*) Select the area to use.

Alt+=(+) automatic summation

ctrl+； Insert current date

ctrl+Shift+； Insert current time

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

Insert insert mode

Delete delete

Third, mobile operation.

Home quickly moves to the beginning of a line.

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

The up, down, left and right arrows move the selected cell up, down, left and right, respectively.

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.

Fourth, select the operation.

Ctrl+A selects all cell ranges. If there is no cell range, or if you press this shortcut key outside the cell range, all cells in the entire worksheet will be selected. Pressing this key combination again will select all cells in the worksheet.

Ctrl+Shift+ Spaces selects all cell ranges. If there is no cell range, or if you press this shortcut key outside the cell range, all cells in the entire worksheet will be selected. Pressing this key combination again will select all cells in the worksheet.

F8 Enlarges the selected area. That is, if a cell is selected, pressing the directional arrow will select consecutive cells, or clicking a cell, then pressing F8, and then clicking another cell can select the area between two cells.

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.