Microsoft Office Tutorials and References
In Depth Information
Understanding Cells and Ranges
You can set the row height manually, however, by using any of the following techniques. As
with columns, you can select multiple rows.
Drag the lower row border with the mouse until the row is the desired height.
Choose Home Cells Format Row Height and enter a value (in points) in the
Row Height dialog box.
Double-click the bottom border of a row to set the row height automatically to
the tallest entry in the row. You can also choose Home
Cells
Format
Autofi t
Row Height for this task.
Changing the row height is useful for spacing out rows and is almost always preferable to
inserting empty rows between lines of data.
Understanding Cells and Ranges
A cell is a single element in a worksheet that can hold a value, some text, or a formula. A
cell is identifi ed by its address , which consists of its column letter and row number. For
example, cell D9 is the cell in the fourth column and the ninth row.
A group of cells is called a range . You designate a range address by specifying its upper-left
cell address and its lower-right cell address, separated by a colon.
Here are some examples of range addresses:
C24
A range that consists of a single cell.
A1:B1
Two cells that occupy one row and two columns.
A1:A100
100 cells in column A.
A1:D4
16 cells (four rows by four columns).
C1:C1048576
An entire column of cells; this range also can be expressed as C:C.
A6:XFD6
An entire row of cells; this range also can be expressed as 6:6.
A1:XFD1048576
All cells in a worksheet. This range also can be expressed as either A:XFD
or 1:1048576.
Selecting ranges
To perform an operation on a range of cells in a worksheet, you must fi rst select the range.
For example, if you want to make the text bold for a range of cells, you must select the
range and then choose Home
Font
Bold (or press Ctrl+B).
 
Search JabSto ::




Custom Search