LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
lil'bit
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing format of number without changing the value sweetsue516 Excel Discussion (Misc queries) 2 August 22nd 05 04:07 PM
how do i replace ( with / without changing format to fraction Splt Window Diner Excel Worksheet Functions 2 August 19th 05 10:00 PM
Problem with formulas changing cell reference janicesweet Excel Discussion (Misc queries) 1 August 2nd 05 06:23 PM
How do I stop excel automatically changing my date to 2005? zoemcb Excel Discussion (Misc queries) 6 April 30th 05 02:39 AM
changing page break in an excel file ibs81 New Users to Excel 1 April 14th 05 07:03 PM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"