Freeze panes + cropping of text

G

Guest

I have chosen to freeze panes in an Excel spreadsheet with three rows at the
top of a table and two columns on the left. The table covers A1:S364.

The problem arises when I review the notes (at the bottom after a table) and
the title of the page once printed.

As these rows are longer than the cells they are in and cross between the
columns which are frozen and columns which are not, they are automatically
cropped.

Currently in order for the notes to be displayed I have to merge the cell
with the notes in up to and including all cells where the frozen panes start,
wrap the text and increase the row height.

Is there a way around this so I can have a note on one line across where
panes are frozen?
 
D

Don Guillett

One way might be to insert a text box shape, put in your text and make sure
that print shape is clicked (default)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top