How do I, not print hidden rows (Excel)
 

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

How do I, not print hidden rows (Excel)
 

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.

--
Kevin Backmann


"Paul" wrote:

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

How do I, not print hidden rows (Excel)
 

Thanks Kevin B

I am still working on it, but it seems to work.

Regards
Paul

"Kevin B" wrote:

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.

--
Kevin Backmann


"Paul" wrote:

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