A question that everyone (who has ever worked on a spreadsheet) has asked at one time or another is, "Where did all my numbers go?" or same question, "Where did all of those ####### come from and why are they in my spreadsheet?"
The problem is the number trying to be displayed in a particular cell does not have enough width to display properly. To clear up the problem we just need to make the column wider. You can do this many ways.
Here are two ways to change the column width
The problem is the number trying to be displayed in a particular cell does not have enough width to display properly. To clear up the problem we just need to make the column wider. You can do this many ways.
Here are two ways to change the column width
- Select the column (or columns) with the problem by clicking on their labels (letters). Then you choose the MENU FORMAT. Go down to COLUMN and over to WIDTH and type in a new number for the column width.
- Move the arrow to the right side of the column label and click and drag the mouse to the right (to make wider) or left (to make smaller). Let up on the mouse button when the column is wide enough.Notice the cursor changes to a vertical line with arrows pointing left and right.