View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Wood Grafing Wood Grafing is offline
external usenet poster
 
Posts: 57
Default printing partial worksheet

Dave didn't mention anything about copy/pasting.

Select the data you want to print, then select print from the file menu.
You can also set the print area from the file menu, but then every time you
go to print, you'll need to set a new print area. Dave's way is much simpler
than any other way I can think of offhand.

"p-nut" wrote:

I am working with Excel 2003 and would like to not have to cut and paste, but
if that is the only way, then so be it. I was just looking for an easier way.

"Dave Peterson" wrote:

Without knowing much about your worksheet, how about just selecting the range
you want to print, then File|print.

You can choose to print just the selection (lower right corner of that dialog).



p-nut wrote:

I have a worksheet where I add information everyday, and I would like to
print off these sheets, but every time I try to print, I end up printing the
whole worksheet instead of just the info that is filled in. Is there a way
to filter this or is there some other way? Will I be able to do this in this
worksheet format, or am I going to have to do something else?

pnut1

I probably have not been clear enough. I would like to print the worksheet
from
Jan. 1 Hello to all and thanks in advance, up to the present day, but when I
try to print, I print the whole worksheet. Is there a way around this? And
if possible, would I be able to print off just the information for the month
from the 1st to the present?

"p-nut" wrote:



--

Dave Peterson