Microsoft Office Tutorials and References
In Depth Information
Decorating a Worksheet with Borders and Colors
Several at a time: Select several rows and drag the boundary between
one of the rows. When you do so, all rows change height. You can also
go to the Home tab, click the Format button, choose Row Height, and
enter a measurement in the Row Height dialog box.
Tall as the tallest entry: To make a row as tall as its tallest cell entry,
double-click the border below a row number (after you’ve selected a
row) or go to the Home tab, click the Format button, and choose AutoFit
Row Height.
Adjusting the width of columns
Here are ways to make columns wider or narrower:
One at a time: Move the mouse pointer onto the boundary between
column letters, and when the pointer changes to a cross, drag the
border between the columns. A pop-up box tells you what size the
column is.
Several at a time: Select several columns and drag the boundary
between one of the columns; all columns adjust to the same width. You
can also go to the Home tab, click the Format button, choose Column
Width, and enter a measurement in the Column Width dialog box.
As wide as their entries: To make columns as wide as their widest
entries, select the columns, go to the Home tab, click the Format button,
and choose AutoFit Column Width on the drop-down list. You can also
double-click the right border of a column letter. By ”auto-fitting”
columns, you can be certain that the data in each cell in a column appears
on-screen.
To change the 8.43-character standard width for columns in a worksheet, go
to the Home tab, click the Format button, choose Default Width on the
dropdown list, and enter a new measurement in the Standard Width dialog box.
Decorating a Worksheet with Borders and Colors
The job of gridlines is simply to help you line up numbers and letters in
cells. By default, gridlines aren’t printed, and because gridlines aren’t
printed, drawing borders on worksheets is absolutely necessary if you
intend to print your worksheet. Use borders to steer the reader’s eye to the
most important parts of your worksheet — the totals, column labels, and
heading labels. You can also decorate worksheets with colors. This part of
the chapter explains how to put borders and colors on worksheets.
 
Search JabSto ::




Custom Search