Microsoft Office Tutorials and References
In Depth Information
Editing a Spreadsheet
Changing the size of rows and
columns with the mouse
Using the mouse can be a quick way to modify the sizes of rows and columns.
To change the height of a row or the width of a column, follow these steps:
1. Move the mouse pointer over the bottom line of a row heading, such
as the 2 or 18 heading. (Or move the mouse pointer over the right line
of the column heading, such as A or D.)
The mouse pointer turns into a two-way pointing arrow.
2. Hold down the left mouse button and drag (move) the mouse.
Excel resizes your row or column.
3. Release the left mouse button when you’re happy with the size of your
row or column.
Typing the size of rows and columns
If you need to resize a row or column to a precise value, it’s easier to type
a specific value into the Row Height or Column Width dialog box instead.
To type a value into a Row Height or Column Width dialog box, follow these
steps:
1. Click the Home tab.
2. Click the row or column heading that you want to resize.
Excel highlights your entire row or column.
3. Click the Format icon that appears in the Cells group.
A pull-down menu appears, as shown in Figure 8-17.
4. Click Height (if you selected a row) or Width (if you selected a
column).
The Row Height or Column Width dialog box appears.
5. Type a value and then click OK.
Excel resizes your row or column.
Excel measures column width in characters. (A cell defined as 1 character
width can display a single letter or number.) Excel measures row height by
points where 1 point equals 1⁄72 inch.
 
Search JabSto ::




Custom Search