Microsoft Office Tutorials and References
In Depth Information
Select a Range
3
chapter
Working with Ranges
Select an Entire Row
1 Position the mouse
over the header of the
row you want to select
( changes to ).
2 Click the row header.
C Excel selects the entire
row.
To select multiple rows,
click and drag across the
row headers or hold down
and click each row
header.
Select an Entire Column
1 Position the mouse
over the header of the
column you want to
select ( changes to ).
2 Click the column header.
D Excel selects the entire
column.
To select multiple
columns, click and drag
across the column
headers, or hold down
and click each
column header.
Are there keyboard techniques I can use to
select a range?
Yes. To select a rectangular range, navigate to
the first cell that you want to include in the
range, hold down , and then press or
to extend the selection. To select an entire
row, navigate to any cell in the row and press
+ . To select an entire column,
navigate to any cell in the column and then
press
Is there an easy way to select every cell in
the worksheet?
Yes. There are two methods you can use.
Either press + , or click the Select All
button ( ) in the upper-left corner of the
worksheet ( A ).
+
.
 
Search JabSto ::




Custom Search