Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
Print Hidden rows | Setting up and Configuration of Excel | |||
Print Hidden rows | Setting up and Configuration of Excel |