M
maclaren
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?
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?