Microsoft Office Tutorials and References
In Depth Information
Moving Data and
Top: Click a column header to
select that entire column.
Middle: Click a row number to
select that entire row.
Bottom: To select every cell in the
worksheet, click the gray box near
the top-left corner of the worksheet
In all these figures, the ribbon is
collapsed to give more room, as
described in the box on page 361.
• If you want to select multiple adjacent columns, click the leftmost column header
and then drag to the right until all the columns you want are selected. As you
drag, a tooltip appears indicating how many columns you’ve selected. For
example, if you’ve selected three columns, you’ll see a tooltip with the text 3C
(C stands for “column”).
• If you want to select multiple adjacent rows, click the topmost row header and
then drag down until all the rows you want are selected. As you drag, a tooltip
appears indicating how many rows you’ve selected. For example, if you’ve
selected two rows, you’ll see a tooltip with the text 2R (R stands for “row”).
• If you want to select all the cells in the entire worksheet, click the blank gray box
that’s just outside the top-left corner of the worksheet. This box is immediately
to the left of the column headers and just above the row headers.