Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / March 2008

Tip: Looking for answers? Try searching our database.

printing partial worksheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
M.GONZALEZ - 18 Mar 2008 18:31 GMT
I have a very large excel worksheet that i would like to print just portions
of it.
how do i pick the parts i want printed and have them print on one page?
the couple of thing i tried always print each column on seperate pages.
Bernard Liengme - 18 Mar 2008 18:51 GMT
I assume you know about Print Area on the File menu.

If you have a long column of data to go on one page look at  David
McRitchie's web site.:
http://www.geocities.com/davemcritchie/excel/snakecol.htm
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

>I have a very large excel worksheet that i would like to print just
>portions
> of it.
> how do i pick the parts i want printed and have them print on one page?
> the couple of thing i tried always print each column on seperate pages.
M.GONZALEZ - 19 Mar 2008 14:34 GMT
thank you so much for the reply.  i am sorry, i thought i knew about the
Print Area
option.  When i attempted to use it i arrive at the same results.

> I assume you know about Print Area on the File menu.
>
[quoted text clipped - 7 lines]
> > how do i pick the parts i want printed and have them print on one page?
> > the couple of thing i tried always print each column on seperate pages.
Gord Dibben - 18 Mar 2008 20:54 GMT
Hide rows and columns not to be printed.

To print non-contiguous ranges you would have to copy those ranges to another
sheet and print that.

See Ron de Bruin's site for more on this by taking a "pictures" of the various
ranges.

http://www.rondebruin.nl/print.htm#non-contiguous

Gord Dibben  MS Excel MVP

>I have a very large excel worksheet that i would like to print just portions
>of it.
>how do i pick the parts i want printed and have them print on one page?
>the couple of thing i tried always print each column on seperate pages.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.