printing partial worksheet

[M.GONZALEZ]

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]

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

 

[Gord Dibben]

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

 

[M.GONZALEZ]

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.