filtering a worksheet to print
 

Hello to all and thanks in advance,

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?

pnut1

filtering a worksheet to print
 

I probably have not been clear enough. I have a worksheet that I add
information to on a daily basis. I would like to print the worksheet from
Jan. 1 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:

Hello to all and thanks in advance,

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?

pnut1

filtering a worksheet to print
 

Answer: Print using Custom View.

Do the following:

1. Select a range of cells.
2. On the View menu, click Custom Views.
3. In the Views box, click the name of the view
(view: A set of display and print settings that you can name and apply
to a
workbook. You can create more than one view of the same workbook without
saving separate copies of the workbook.) you want to print.
4. Click Show.
The range of cells will be shown as selected
5. Click Print.
6. Under Print What, click Selection
7. Click OK.

Note: You craete as many Custom View as possible, and print only those
views. Most important thing is you must select the range and during print you
must select Selection option. You can chage the Page sige before printing.

Challa Prabhu


"p-nut" wrote:

Hello to all and thanks in advance,

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?

pnut1