#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Key/Legend

I have a Sheet in Excel (2003) in which Column A is repeated on every page.
There are three cells at the bottom of the page that contain information that
is used as an informational key/legend. Two of the three cells' contents
stretch across several columns. With a set print area, there are two pages.
On the second page, the cells that contain the "keys" or "legend" are cutoff
at the beginning of the second column. How do I get these cells to display
all their information on the second page?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 209
Default Key/Legend

Why don't you put the Legend in the footer...
From the top menu, select FILE then PAGE SETUP then HEADER/FOOTER then
CUSTOM FOOTER.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Dont_b_Flat88" wrote:

I have a Sheet in Excel (2003) in which Column A is repeated on every page.
There are three cells at the bottom of the page that contain information that
is used as an informational key/legend. Two of the three cells' contents
stretch across several columns. With a set print area, there are two pages.
On the second page, the cells that contain the "keys" or "legend" are cutoff
at the beginning of the second column. How do I get these cells to display
all their information on the second page?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Legend Deb Charts and Charting in Excel 1 October 22nd 07 11:49 PM
Legend Key Box tara Charts and Charting in Excel 3 September 9th 07 05:04 AM
Legend NAS Charts and Charting in Excel 2 December 1st 05 04:16 PM
Legend - Don't Want To See Bob Barnes Charts and Charting in Excel 3 October 7th 05 10:08 PM
Legend Alison Charts and Charting in Excel 3 June 17th 05 11:32 PM


All times are GMT +1. The time now is 05:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"