[mso] Re: Excel - printing multiple pages of one column on one page

Hello Jenny
The way that I have done this in the past is:

Click "View"    -    "Page Break Preview"

If only 1 column appears, then drag out a few more columns (by using the
blue line on the right)

As there are only a few pages then just cut and paste from page 2 onto, say
column C of your Page 1, and do the same for the other pages.

You will notice that you have got some blank pages at the bottom of your
preview, scroll down to the bottom and drag the blue line back up to the
botom of your page 1 preview. You do not need to save changes, just undo
them if you do not want to keep this format.

I hope this helps for you

Good Luck

John


On 07/01/2008, jj1@xxxxxxxxxxxx <jj1@xxxxxxxxxxxx> wrote:
>
> I need to print one column of a spreadsheet for a handout, and I am able
> to print it but it has one per page and a lot of wasted space.  Does anyone
> know of a way to make it print say 3-4 pages of the one column on one sheet
> of paper?
>
> Thanks,
> Jenny
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the
> dropdown menu at the top.  This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister
> group.  This group will not allow for posting of emails, but will allow you
> to join and share problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your
> email messages, read these instructions that explain why and how to fix it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: