I would do the following:

1. Highlight all columns you want to print.
2. Position the cursor between two columns, until it turns into a double headed
arrow.
3. Double click. This will adjust all columns wide enough to display all data.
4. Use Page Setup to adjust printing to 1 page wide.
5. Print (or Print Preview)

This will tell you whether all data can legibly print on a page. If it does,
great. If not, you will have to make the decision on how to print everything
legibly -- print landscape, smaller fonts, more pages, etc.

--
Regards,
Fred


"GEORGE ZEIGLER, SAN DIEGO"
wrote in message ...
David,

Thanks for these thoughts. Unfortunately, I am working with fixed column
widths and text sizes
I have a situation that has 9 adjacent cells in a row ... and the
spreadsheet has several hundred rows ... and I have to be able to print the
spreadsheet ...
there could be data in any one of the nine cells ... if I expand the column
width other cells won't print properly ... and if I shrink down 27 characters
into a small space, I won't be able to read the output when it's printed.

Thanks though for your ideas !!!

-GZ-

"David Biddulph" wrote:

If your problem is that the cell to the left isn't wide enough to display
its contents, then you have a number of options:
Widen the column, or
Reduce the font size, or
Format/ Cells/ Alignment, and select Wrap Text
--
David Biddulph

"GEORGE ZEIGLER, SAN DIEGO"
wrote in message
...
Thanks Max,

Here's my situation ... I have an alpha string of characters in a cell
directly to the left of the cell which tested for a formula and returned
the
value yielded by "". The string of alpha characters is about 20 characters
long, and I need to be able to see the string.

However the string is truncated when it hits the cell where the "" value
is
returned ... this makes me unable to see the string ... I'm thinking maybe
since there's a formula in the cell to the right, XL interprets the cell
as
"non-empty" and therefore causes the string in the cell to the left to be
truncated. I can't see anything in the "" cell, since it returns a null
set,
but it appears the formula itself is causing truncation.


"Max" wrote:

First thoughts .. pl remove the caps lock, it's difficult to read

If you mean return a null string ("") if D3 is blank
you could put it like this in say, E3: =IF(ISBLANK($D3),"",D3)

If you mean return a null string ("") if D3 is either blank or contains
zero
you could use in E3: =IF($D30,D3,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GEORGE ZEIGLER, SAN DIEGO" wrote:
I have tried every method I can think of to return a blank cell as the
result
of a formula

EXAMPLES:
IF($D31,D3,"") HOPING "" COULD BE INTERPRETED AS EMPTY STRING
(BLANK
IF($D31,D3,A2) WHERE A2 IS A BLANK CELL

NO MATTER WHAT I TRY, XL AWAYS RETURNS 0'S ... THIS DOESN'T WORK FOR MY
APPLICATION. I CAN'T SEEM TO FIND A WAY TO HAVE A FORMULA RETURN A
BLANK
CELL.

ANY HELP IS GREATLY APPRECIATED !!!

THANKS ... GEORGE ZEIGLER, SAN DIEGO.