+ Reply to Thread
Results 1 to 3 of 3

Reducing a file size by changing cell formatting

  1. #1
    Forum Contributor
    Join Date
    05-19-2004
    Location
    United States
    MS-Off Ver
    Office XP and Office 2003
    Posts
    127

    Question Reducing a file size by changing cell formatting

    I am working on a spreadsheet, where the developer had changed the cell format for every cell on most of the spreadsheets. For example, instead of a white background, they changed the entire sheet to have a green background. On one of the sheets, the data on the sheet is only in the range A1:N59. I am trying to set the cell formatting for the columns starting in O and the rows starting in 60 back to the default. I have copied and pasted a cell with the defaut format into those columns and rows. However, when I save the file after doing that, the size of the file actually gets much bigger. It goes from 16 MB to 52 MB. Does anyone know why this is happening?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Reducing a file size by changing cell formatting

    You could clear ALL the formatting, save the file, confirm it is now modest in size, and then reapply formattting as you wish.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Reducing a file size by changing cell formatting

    Or, maybe this:

    After you set the colors back to normal you could also try to select all columns to the right of your data and delete the columns, then select all rows below your data and delete the rows.

    They will immediately be replaced with new rows and columns, but the spreadsheet should shrink considerably

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1