cell formatting

[Courtney]

Hopefully I'm asking this the right way...

Is there a way that I can extend the cell row to fit all
my text data without having to change the width of the
worksheet columns? Basiclly, what I want to happend is
when I print out the worksheet, all my comments that I
wrote in (e.g. cell "A1") will appear in the printout
instead of having the comments be "hidden" behind (e.g.
cell "B1")

I know there is a way to do this but I forgot!

Thanks.

 

[Andy B]

Hi

It will only hide behind the next cell if there is data in that cell. If B1
is empty, it will display all of A1 - until it gets to a used cell.

 

[JE McGimpsey]

Choose File/Page Setup/Sheet and choose either "As displayed on sheet"
or "at end of sheet" from the Comments dropdown in the "Print" area.

 

[JE McGimpsey]

Disregard - I misread the "comments" in your post.