Hi,
I work on a shared workbook that gets sent back and forth on a daily basis.
Sometimes, the other person will resize the cells causing text to be hidden.
As a result I have to resize the cells to fit text by highlighting the
columns then clicking on Format Rows and then presto, I can view all text.
However, when I go to print my text is hidden as it was before.
What can I do?

Thanks.

Perhaps shared does change things, as I would think it should print what you have,
but try saving the file first. If you can't save then save it with a new name and print.
Let us know what happened because I'm not sure of answer.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"TP" wrote in message ...
Hi,
I work on a shared workbook that gets sent back and forth on a daily basis.
Sometimes, the other person will resize the cells causing text to be hidden.
As a result I have to resize the cells to fit text by highlighting the
columns then clicking on Format Rows and then presto, I can view all text.
However, when I go to print my text is hidden as it was before.
What can I do?

Thanks.

Any chance you have a macro that runs when you print the workbook?

TP wrote:

Hi,
I work on a shared workbook that gets sent back and forth on a daily basis.
Sometimes, the other person will resize the cells causing text to be hidden.
As a result I have to resize the cells to fit text by highlighting the
columns then clicking on Format Rows and then presto, I can view all text.
However, when I go to print my text is hidden as it was before.
What can I do?

Thanks.

--

Dave Peterson