Format Changes

david.2004

New member
Joined
May 5, 2011
Messages
1
Reaction score
0
Points
0
Why does deleting rows in excel97 reformat other rows in the sheet. I've just sorted out a new sheet and deleting rows of unwanted info reformats random rows in the sheet. any ideas???
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Excel 97? Nobody uses that anymore, well maybe apart from yourself. Can't say I ever noticed it, and I don't have a copy to check either.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,519
Reaction score
4
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
It's been years since I used 97, but I dont' recall it doing that at the time. Are you sure there isn't any macro code running in the worksheet module? Maybe a worksheet change event or something?
 

Simon Lloyd

Administrator
Joined
Apr 2, 2011
Messages
401
Reaction score
0
Points
0
Location
Manchester, England
Excel Version(s)
Excel 2016
Why does deleting rows in excel97 reformat other rows in the sheet. I've just sorted out a new sheet and deleting rows of unwanted info reformats random rows in the sheet. any ideas???
Do you have conditional formatting on the sheet? is the elastic band wound tight enough? :)
 
Top