Excel selected Grid 11 Tips Summary

select cells that are not contiguous

With CTRL + Mouse click, you can select a discontinuous cell in any position.

Select any rectangular area

Shift+ two mouse clicks in different locations, you can select two rectangular cell ranges with diagonal corners.

Select the cursor to a range at the edge

Ctrl+shift+ the arrow key to select the most efficient data cell from the cell in the current cursor to the table that the arrow key refers to.

Select the cursor to the beginning cell

Shift+home, select the range of the current cursor to the cell at the beginning of the current line.

Select cursor to table first cell

Ctrl+shift+home selects the cell at the current cursor to the range of the first cell in the worksheet.

Select adjacent area or entire table

CTRL + A selects all area data adjacent to the current cell, including adjacent cells for adjacent cells. If pressed again, selects the entire worksheet, which contains blank areas with no data.

Select only the currently visible cells

ALT +; Select visible cells, excluding cells that are hidden. You can set the color for the selection, and then unhide to verify that the original hidden cell is not selected.

Quickly select a fixed cell

Use the Name box above the upper-left corner of the table, and enter the cell range coordinates (such as input a1:c12) to quickly select the specified cell or range of cells.

Locate a range of cells by criteria

Use F5 (or ctrl+g) to locate conditions by reference position or location area.

Pinpoint cells by search range

Use Ctrl+f to find, specify the range, the specified value for accurate positioning. When the results of the lookup are selected with Ctrl + A, all eligible cells in the table are automatically selected.

Automatically position cells in a cross-table union

Involves multiple, identically formatted worksheets, with SHIFT or CTRL with the mouse click on the sheet tab, into workgroup mode, and when you select a worksheet cell, it affects the same area of other worksheets within the group, and the corresponding cells in the other table are selected.