Home |
Search |
Today's Posts |
#1
|
|||
|
|||
unintentionally changing SS
Hello forum. I have a problem. Sometimes when looking at an older SS on the computer, I find the totals changed from when I originally printed them. I'm suspecting it has something to do with the headings/page break numbers that I add to the second/ third page after totaling all columns and rows. Or maybe the notations I write up at bottom of SS. Is there a way to lock ( and Unlock for adding an add't row of data ) a SS so it cannot be changed? Or, preferably, is there a way to -print - the page that will automatically add headings and titles to second and third pages without me actually entering the headings etc between the figures when there is a page break. Each month's SS will always have 2-3 pages and each page has to have the headings etc. It's always the grand totals that are changed. The row upon row of currency data stays the same. -- lil'bit married, muddled, and mistook ------------------------------------------------------------------------ lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306 View this thread: http://www.excelforum.com/showthread...hreadid=484486 |
#2
|
|||
|
|||
unintentionally changing SS
Hi there,
Here's a great article about how to have your heading rows repeat at the top of every page you print: http://www.officearticles.com/excel/...ft_exce l.htm And for locking down your cells: http://www.officearticles.com/excel/...soft_excel.htm Hope this helps, -- Ken Puls www.officearticles.com "lil'bit" wrote in message ... Hello forum. I have a problem. Sometimes when looking at an older SS on the computer, I find the totals changed from when I originally printed them. I'm suspecting it has something to do with the headings/page break numbers that I add to the second/ third page after totaling all columns and rows. Or maybe the notations I write up at bottom of SS. Is there a way to lock ( and Unlock for adding an add't row of data ) a SS so it cannot be changed? Or, preferably, is there a way to -print - the page that will automatically add headings and titles to second and third pages without me actually entering the headings etc between the figures when there is a page break. Each month's SS will always have 2-3 pages and each page has to have the headings etc. It's always the grand totals that are changed. The row upon row of currency data stays the same. -- lil'bit married, muddled, and mistook ------------------------------------------------------------------------ lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306 View this thread: http://www.excelforum.com/showthread...hreadid=484486 |
#3
|
|||
|
|||
unintentionally changing SS
Omgosh, that is so cool. What a program! Thank you thank you. Maybe now there won't be these changes in the totals. One more thing... How do I get it to also print Page 1 of 2, Page 2 of 2, etc.? -- lil'bit married, muddled, and mistook ------------------------------------------------------------------------ lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306 View this thread: http://www.excelforum.com/showthread...hreadid=484486 |
#4
|
|||
|
|||
unintentionally changing SS
Er.. And one more question. Since there are so many pages, it is easy to get mixed up as to which column you are in when you can no longer see the headings. Is there a way to get the headings from the first page to slide down as you go lower from row to row? Thank you. -- lil'bit married, muddled, and mistook ------------------------------------------------------------------------ lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306 View this thread: http://www.excelforum.com/showthread...hreadid=484486 |
#5
|
|||
|
|||
unintentionally changing SS
Go to View--Header and Footer. Use a Custom Header or Footer and type the
following: Page &[Page] of &[Pages] (the buttons help with the &[Page] parts of the "code". ************ Anne Troy VBA Project Manager www.OfficeArticles.com "lil'bit" wrote in message ... Omgosh, that is so cool. What a program! Thank you thank you. Maybe now there won't be these changes in the totals. One more thing... How do I get it to also print Page 1 of 2, Page 2 of 2, etc.? -- lil'bit married, muddled, and mistook ------------------------------------------------------------------------ lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306 View this thread: http://www.excelforum.com/showthread...hreadid=484486 |
#6
|
|||
|
|||
unintentionally changing SS
You just need to freeze panes.
http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy VBA Project Manager www.OfficeArticles.com "lil'bit" wrote in message ... Er.. And one more question. Since there are so many pages, it is easy to get mixed up as to which column you are in when you can no longer see the headings. Is there a way to get the headings from the first page to slide down as you go lower from row to row? Thank you. -- lil'bit married, muddled, and mistook ------------------------------------------------------------------------ lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306 View this thread: http://www.excelforum.com/showthread...hreadid=484486 |
#7
|
|||
|
|||
unintentionally changing SS
Thank you Ken and Anne. This forum is tops. I nearly always get great informative precise instructions. There isn't much of a problem that someone doesn't have an answer. Ya'll have a great weekend. :) -- lil'bit married, muddled, and mistook ------------------------------------------------------------------------ lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306 View this thread: http://www.excelforum.com/showthread...hreadid=484486 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
how do i replace ( with / without changing format to fraction | Excel Worksheet Functions | |||
Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
changing page break in an excel file | New Users to Excel |