cell too small (excel 2000)

Topic

New Reply

I recently printed a report, only to discover that there were two lines of data in one cell.
On one printer, the report only printed the first line.
On a second printer, it printed both lines.
On a third printer it overtyped the second line over the contents of the cell below.
The first case is of highest concern, since I could be losing data (horizontally and vertically) without getting any warning.

Reply | Quote

Replies

Not knowing what data you have, you could use the AutoFit to Selection command in the Format menu. Another thing to try is to choose Wrap Text under the Alignment tab / Format Cells. You may have reset the print area.

Brent

Reply | Quote

Can we assume that when you say “two lines of data in one cell”, you mean that the data contains a lot of characters and is wrapping on screen in the formula bar and in in-cell editing?

If Brent hasn’t solved your problem, another thought is to expand the column width. Click on the column header to select the column containing this cell, move the cursor near the right edge of the column header until the “Cross with arrows” pointer appears, and double click.

Reply | Quote

…. I was in a hurry to get to a meeting and didn’t specify Format / Column / AutoFit to Selection. Sorry about that.

Brent

Reply | Quote

It’s just a thought, but could it be that there are some non-printable characters in the strings (control-characters, which might be interpreted differently according to your printer settings?). You can get rid of this by using the CLEAN worksheetfunction. e.g. if your line of data is in cell A1, put =CLEAN(A1) in cell B1 and have a look if it prints differently.

Reply | Quote