Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Island Girl
 
Posts: n/a
Default 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   Report Post  
Ragdyer
 
Posts: n/a
Default

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   Report Post  
Island Girl
 
Posts: n/a
Default

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
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
Excel 2002 Will Not Print Text Boxes Mark Excel Discussion (Misc queries) 3 April 16th 05 12:03 AM
set the print area print multiple tabs veng Excel Discussion (Misc queries) 5 February 12th 05 07:01 PM
Printing - Have to set print area 1 column further than necessary STUART BISSET Excel Discussion (Misc queries) 0 January 24th 05 07:59 PM
Microsoft Excel could not find anything to print cyndi Excel Discussion (Misc queries) 1 December 22nd 04 01:40 PM
Non-Breaking Space + Print Issue Barb Reinhardt Charts and Charting in Excel 3 December 9th 04 01:03 AM


All times are GMT +1. The time now is 05:23 PM.

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

About Us

"It's about Microsoft Excel"