Text Scaling - Turn Off for Select Cells?

  • Thread starter Thread starter Jimmy Flies
  • Start date Start date
J

Jimmy Flies

Greetings all.

I'm generating reports for which I would like to include titles and
sub-titles that remain a constant size regardless of the sheet contents
below.

The reports will have data that varies in the amount of columns and/or
rows used.

My problem is that when the data is scaled to fit to one page wide and
any number of pages tall, the titles and sub-titles of the page change
in size.

Is there any way to prevent, say, the first three rows or selected
cells from scaling with the rest of the data?

[I've tried putting the titles in the header, but that scales as
well.]

Thanks in advance for your helpful replies!

Jimmy



------------------------------------------------




------------------------------------------------
 
And put any information that varies in the footer (page # of #).

Jimmy said:
Greetings all.

I'm generating reports for which I would like to include titles and
sub-titles that remain a constant size regardless of the sheet contents
below.

The reports will have data that varies in the amount of columns and/or
rows used.

My problem is that when the data is scaled to fit to one page wide and
any number of pages tall, the titles and sub-titles of the page change
in size.

Is there any way to prevent, say, the first three rows or selected
cells from scaling with the rest of the data?

[I've tried putting the titles in the header, but that scales as
well.]

Thanks in advance for your helpful replies!

Jimmy

------------------------------------------------




------------------------------------------------
Click to expand...
 
Thanks for the replies, Dave. Appreciate your thoughts.

(I do have page numbering in the header and, of course, I’d prefer that
it not be scaled along with the report data, if possible.)

Interesting thought about the pre-printed report forms. However, and I
probably didn’t make this clear in my original post, the majority of
our reports are provided electronically, so the printing won’t really
help. An interesting thought though that I will certainly consider
further.

Anyone else out there have any ideas on this? I’m researching far and
wide and can’t seem to come up with any solutions as of yet.

Thanks again!

Jimmy



------------------------------------------------
Message posted

-- View and post Excel related usenet messages directly from http://www.ExcelForum.com
at http://www.ExcelTip.com/
------------------------------------------------
 
Back
Top