The letter must come first (i.e. B4, NOT 4B) and there may NOT be any spaces between the letter and the number.
We will learn later why it is important to understand how to name cells.
Name Box Selected Cell
Longggggggg Data
Information that is “too wide” for a cell
The word “Name” is in cell A5
The words “Hours Worked” are in cell B5 (NOT in cell C5). However, since the information is too wide for cell B5, it looks like it extends into cell C5.
You can determine that the information is really only IN cell B5 by selecting cell B5 and looking at the formula bar and then selecting cell C5 and looking at the formula bar.
“Hours Worked” is in cell B5 (look at formula bar) “Hours Worked” is NOT in cell C5 (formula bar is empty)
Information that is “Chopped Off”
If there is information in the cell to the right, then the original cell still contains all of the data, but the data appears to be “chopped off”.
You can see the complete data by selecting the cell and looking in the formula bar.
Change the Width of a Column or the Height of a Row
Make a column wider
To make Column B wider, point the cursor to the column separator between columns B and column C.
The cursor changes to a “Double headed arrow”.
Now, click the left mouse button and without letting go of the button, drag the separator to the right to make the column wider (or to the left to make the column narrower).
Column is now wider Drag column separator to the right
Getting the Exact Width
To get the “exact” width, double click on the separator instead of dragging it.
Column is now EXACTLY the correct width Double click here
