Lesson for Day Thirteen
In this lesson, we
will review and learn to:
Align
text or data within a cell
Change
cell or column width
Check
spelling
Center, align, indent, or rotate data in a cell
In cells that have the default General format, text data is
left-aligned, and numbers, dates, and times are right-aligned. Changing the
alignment does not change the type of data.
To center or align data that spans several columns or rows, such as
column and row labels, you can merge a selected range of cells and align the
text within the resulting merged cell.
Change column width
- Drag the boundary on the
right side of the column heading until the column is the width you want.
The displayed column width is the average number of digits 0 through
9 of the standard font that fit in a cell.
Tips
- Fit the
contents To make the column width fit the contents,
double-click the boundary to the right of the column heading. To do the
same for all columns on the worksheet, click the Select All button,
and then double-click a boundary to the right of one of the column
headings.
- Change multiple
columns To change the column width for multiple columns,
select the columns you want to change, and then drag a boundary to the
right of a selected column heading. To change the column width for all
columns on the worksheet, click the Select All button, and then
drag the boundary of any column heading.
- Manually change the width
To manually change the width, select the column, point to Column on
the Format menu, click Width, and then enter a number.
Check spelling
Use the F7 function key on
your keyboard to check spelling.