Print Title Columns

  • Thread starter Thread starter kcc
  • Start date Start date
K

kcc

This is a stupid thing that I'm pretty sure has no easy answer
other than to hope MS adds it for 2005, but I guess it's
worth seeing if anyone has a solution. I have a spreadsheet
that has column A set as Print Titles and several columns
that print on 2 pages with column A repeated as expected.
At the bottom of the page, I have some foot notes that are
on the page in column A, but they are wider than the column,
therefore on page 2, the labels cut off. Most users will be
looking at the file on screen, so I don't really want to put the
notes in the print footnotes. I've been thinking about an On
Print macro that copies the cells to the footnotes, but
thought I would check here for an easier answer.
kcc
 
If I understand you correctly you have comments in A near the end that
you do not want repeated on the page to the right. You will still print
that page to right. How about putting the comments into column B,
instead. They will extend to the right unless you have cell wrap on turned on.
 
Actually, my issue was the reverse. I want the comments on both pages.
Having said that, your answer implies the absurdly simple solution
of putting the comments in column B and H. The comments will show
twice on the screen and won't line up the way I would prefer, but I'd
rather live with that than add an unnecessary macro.
 
Back
Top