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

Well...here's one way that you can do it that might be easier than numerous
cut/paste moves in Excel. You'll still need to cut/paste, but one shot will
wrap all the content into a Word doc, which would be faster/easier, I
believe...

* open a blank Word doc and click Format > Columns. Set as many columns as
you think you'd need. Note that the diagrams give you up to 3, but you can
use the input box to change that to as many as you can fix on the page.

* Alt/Tab back over to Excel, click on the column you need to print and hit
Ctrl + C to copy it.

* Alt/Tab back over to Word and hit Ctrl + V to paste it into Word. The
content will wrap into the formatted columns, which will put all your
numbers (that fit) on that one page

* Then hit Ctrl + P to print that page. 

Note that if you have to do this often, you can format the Word doc as a
template. Open a blank page, add your header/footer info if you want that.
Add a title, blah, blah. Then click Insert > Break and add a CONTINUOUS
SECTION break. By doing that, your title/top/bottom info will be formatted
to the full margin of the document/report. Then you add a BREAK to tell Word
"and now for something completely different." After you add that break...NOW
do the Format > Column setting and insert the columns you need. Now...save
this as a template.

Then the next time you need to do this...the one quick paste will drop/wrap
the data into the columns, but you'll have all the master report header, etc
already set up for you. And if you need rolling dates for say the title,
i.e., Report for Jan 10, 2008...you can insert a CreateDate field at that
spot. Then when you save the report, the title will get the date the report
was create (assuming you'll create it on the date it is due, but you can
modify the date format for just the month/year if necessary, so you won't
get the exact DAY in the title, should that matter).

Note, if you need any help understanding Sections in Word, check out this
article:

Word - Section by Section
http://www.computorcompanion.com/LPMArticle.asp?ID=280

And if you want to actually SEE how to insert sections to set up
columns...you can view this free video lesson:

Word Columns
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=693

Hope this helps...


Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified Instructor, Editor/TechTrax Ezine
Tech Editor for Word & Office 2007 Bibles
https://mvp.support.microsoft.com/profile/Dian.Chapman

Free PC Tutorials: http://www.mousetrax.com/techtrax
Free Word Tricks eBook: http://www.mousetrax.com/books.html 
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html 


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of jj1@xxxxxxxxxxxx
Sent: Thursday, January 10, 2008 1:13 PM
To: mso@xxxxxxxxxxxxx
Cc: John Clarke
Subject: [mso] Re: Excel - printing multiple pages of one column on one page

Thank you for your suggestion.  We have been doing the cut and paste way,
and I should have said that in my post.  I was hoping that there was some
setting that I didn't know about that would allow us to do it without the
cut and paste.  Maybe Microsoft will add that in the future.  :-)

Again thank you for taking time to respond.

Jenny


---- John Clarke <john.johnwclarke@xxxxxxxxx> wrote: 
> 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
> *************************************************************

*************************************************************
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
*************************************************************



-- 
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.448 / Virus Database: 269.17.13/1209 - Release Date: 1/4/2008
12:05 PM

-- 
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.448 / Virus Database: 269.17.13/1209 - Release Date: 1/4/2008
12:05 PM
 

-- 
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.448 / Virus Database: 269.17.13/1209 - Release Date: 1/4/2008
12:05 PM
 

*************************************************************
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: