Adjusting Columns

If you find that text in cell C2 is overflowing into cell D2,

1. Move the mouse pointer over to the C column label.

2. Carefully place the mouse over the common border between columns C and D.

The pointer changes to a two-headed arrow.

3. Press the left mouse button and slowly drag to the right.

Column C gradually widens

4. Release the mouse button.

Column C becomes wide enough to enclose the entire text in it, and all columns in front of it shift to the right.

5. Type the text shown against each of the remaining cells. Do not forget to press Tab after typing each text item.

6. After you have entered text in the various cells, adjust their column width to make your worksheet look like this:

Consider these issues when creating a worksheet:

• Which items are data or numbers that you will type
• What do you want to calculate from the data
• Which number are constants and used in a variety of calculations
• What arrangement in the columns and rows will make it easiest for you and your intended audience to work with the spreadsheet?

The suggested order for entering data in a spreadsheet is:

1. Type the text information to create a structure.
2. Type the data.
3. Create formulas using cell references to do calculations on the data.
4. Format the text and numbers to make it easier to read.