Results 1 to 3 of 3

Thread: Losing formatting on Excel

  1. #1
    Seeker paultilling's Avatar
    Join Date
    Aug 2013
    Location
    London UK
    Posts
    9
    Articles
    0

    Losing formatting on Excel



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

    I run Excel'97 2004 workbooks on Excel'11(version 14) with my Apple Macbook Air OsX.8.2 laptop. (I have never used Windows)

    I have recently found that whenever I save one of my workbooks I lose some of the formatting, like shading, lines or borders etc..

    Can anyone please tell me what I should do to correct this please? Could it be I need to update the Excel workbook to a newer version? If so how should I go about doing this?

    I've never seen any instructions on how to do this.

    Any advice would be most gratefully received.

    Paul










  2. #2
    Seeker ExcelTactics's Avatar
    Join Date
    Sep 2013
    Location
    Seattle, WA, USA
    Posts
    9
    Articles
    0
    Formatting is generally lost when you save in older versions of the program you are using. When you open up an old workbook and make changes, you'll need to Save As and change the Format to the new version (probably File.xlsx instead of File.xls).
    ---
    Like what you just read? Learn how to master Excel with new tips and tutorials each week at ExcelTactics.com.

  3. #3
    Seeker paultilling's Avatar
    Join Date
    Aug 2013
    Location
    London UK
    Posts
    9
    Articles
    0
    Losing formatting on Excel

    THanks very much, you solved all my problems! Paul

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
  •