Results 1 to 4 of 4

Thread: Format Changes

  1. #1

    Lightbulb Format Changes



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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???

  2. #2
    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.

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,021
    Articles
    79
    Blog Entries
    14
    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?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  4. #4
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    323
    Articles
    0
    Quote Originally Posted by david.2004 View Post
    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?
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •