Microsoft Office Tutorials and References
In Depth Information
Whenever you make changes to cells in a worksheet, you can
save time by applying the changes to similar cells at the same
time. In Excel 2013, you can select groups of cells that aren’t
even next to each other. If your worksheet stores dates in cells
with other information in cells in between, you can select all the
date cells and apply a format to them at the same time.
Select a contiguous group of cells
1 In the group that you want to select, drag from the upper-left cell
to the lower-right cell.
Select a noncontiguous group of cells
1 Drag from the upper-left cell you want to select to the lower-right
cell to select the first set of cells.
2 Hold down the Ctrl key, and drag to select another set of cells.