cell formatting

  • Thread starter Thread starter Courtney
  • Start date Start date
C

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.
 
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.
 
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.
 
Back
Top