Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |