LinkBack URL
About LinkBacks
I have a worksheet (sample attached) and I have over 400 rows of data. I have formulas set up to total at the end of the worksheet but would like to get totals when printing by page break. How can I get the formulas to repeat at each page break?
I have a worksheet (sample attached) and I have over 400 rows of data. I have formulas set up to total at the end of the worksheet but would like to get totals when printing by page break. How can I get the formulas to repeat at each page break?
I have not worked with a MAC so I am not sure where this command is located. In Excel 2002, in the Data, subtotals section, there is a check box that lets you do subtotals at the page break. Look around your software for something similar.
Alan
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Will try it but I need to subtotal by code, 5,3 and 1. Will let you know if I find it. I'm still learning the Mac version.....should've stuck with MicroSoft.
another possible option is to put your totals at the top (under the heading/title?) and then, under "page setup - sheet", make those rows part of the "print titles" option.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I 'll try and see if it works. I was thinking it would be great if there was an option to repeat rows at bottom of page. Will report back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks