Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I set different print areas in the same Excel sheet?
I know very little about Excel since until recently all of my work was in
Microsoft Word. However, people now email Excel documents to me to print and I get more confused with each one. Is it possible to set three different-sized print areas in one sheet, each with a different percentage of size adjustment? There are times when many pages of a sheet will go from A-H and the last one or two will go from A-AS. When each sheet is set to fit on a legal size page, the A-H pages are as microscopic as the last ones. What, if anything, could I do to even out the appearance and readability? I'm sure that to a seasoned user this is a stupid question. But it's been driving me crazy! Thanks in advance for being there. |
#2
|
|||
|
|||
You can use "Custom Views", which, in addition to displaying pre-set "named"
views, also can print out these views with their own particular print settings. Lookup "Views" - "Custom" in the help files. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Island Girl" wrote in message ... I know very little about Excel since until recently all of my work was in Microsoft Word. However, people now email Excel documents to me to print and I get more confused with each one. Is it possible to set three different-sized print areas in one sheet, each with a different percentage of size adjustment? There are times when many pages of a sheet will go from A-H and the last one or two will go from A-AS. When each sheet is set to fit on a legal size page, the A-H pages are as microscopic as the last ones. What, if anything, could I do to even out the appearance and readability? I'm sure that to a seasoned user this is a stupid question. But it's been driving me crazy! Thanks in advance for being there. |
#3
|
|||
|
|||
Thanks a million. I'm gonna give that a try!
"Ragdyer" wrote: You can use "Custom Views", which, in addition to displaying pre-set "named" views, also can print out these views with their own particular print settings. Lookup "Views" - "Custom" in the help files. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Island Girl" wrote in message ... I know very little about Excel since until recently all of my work was in Microsoft Word. However, people now email Excel documents to me to print and I get more confused with each one. Is it possible to set three different-sized print areas in one sheet, each with a different percentage of size adjustment? There are times when many pages of a sheet will go from A-H and the last one or two will go from A-AS. When each sheet is set to fit on a legal size page, the A-H pages are as microscopic as the last ones. What, if anything, could I do to even out the appearance and readability? I'm sure that to a seasoned user this is a stupid question. But it's been driving me crazy! Thanks in advance for being there. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Will Not Print Text Boxes | Excel Discussion (Misc queries) | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) | |||
Non-Breaking Space + Print Issue | Charts and Charting in Excel |