How do I, not print hidden rows (Excel)

P

Paul

Version (Excel 2003)

I am trying to make a spreadsheet for book-keeping.

When I have sorted my data, ie (Lets say income) so income catagories
occupies the top rows and expense occupies the bottom rows. Obviously at the
bottom of the spreadsheet their is a row which calculates the totals.

Now I will hide the row containing the expense rows, so as only to be able
to see the income rows and total row. I would like to be able to format my
spreadsheet so it automatically prints the view (no matter how many times I
change it). Also
the total row calculates using the hidden rows as well as the visable rows.

Thanks
 
K

Kevin B

I would split out the expenses and the income, so that you have a row that
totals expenses, a row that totals income and then below the income &
expenses a summary a summarization of income minus expenses to show cash flow.

Once the layout is complete create custom views, perhaps one view that shows
all, one that shows expenses and another that shows income. Each time you
want to print you can selet the view that you want printed and send it on to
the printer.

If you know how to hide rows and columns you're half-way to creating views.
In Excel's Help facility, look up "Custom View" sans quotes for details
regarding the working with and creating custom view.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top