+ Reply to Thread
Results 1 to 3 of 3

Excel retaining old cell fill colors?

  1. #1
    Registered User
    Join Date
    08-21-2015
    Location
    Brussels, Belgium
    MS-Off Ver
    2013
    Posts
    33

    Excel retaining old cell fill colors?

    Hi there.

    I am currently designing a fact sheet for my company with 8-10 graphs on one chart sheet. I've been playing with the colors a little bit to try to make it more modern-looking, but it looks like that might have created a problem.

    On my screen and on the print preview, I see the new color scheme. But when I print it, there are certain cells where the old colors have printed out. I've tried returning the cells back to the default color and starting again, as well as trying to copy table to a different chart sheet, but nothing's working.

    Any advice on how I can get it to print accurately?

    Thanks!

  2. #2
    Registered User
    Join Date
    08-21-2015
    Location
    Brussels, Belgium
    MS-Off Ver
    2013
    Posts
    33

    Re: Excel retaining old cell fill colors?

    FYI... I just converted the chart sheet to a PDF and it printed out fine. But I we make a lot of these graph sheets, so I would like to find a way to print them directly out of Excel so that I don't have to convert to PDF each time. Any ideas as to what's wrong?

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel retaining old cell fill colors?

    If you are using a laser printer, it may not have sufficient memory to handle all the graphics. Having looked at some new colour laser printers, some of the specifications mention memory specs and others don't. I have had some pretty strange results (though years ago) because of this.

    If this is being printed on an inkjet printer I suspect that there is some kind of corruption in the graphics area. Can you copy the graphics (one at a time and not the whole worksheet) to a new workbook then copy and paste values and formulae where applicable then apply cell formatting as required?

    If you are using tables and are manually formatting them, it can be difficult to get rid of old formatting when reformatting the table. (I have just gone through this) The solution to getting rid of the old formatting was to select the entire columns affected and then click on Clear Formats and start over.

    Good luck.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cell fill colors in Excel 2010
    By ladyglas in forum Excel General
    Replies: 3
    Last Post: 01-31-2015, 12:21 PM
  2. Replies: 16
    Last Post: 12-12-2014, 06:19 AM
  3. [SOLVED] Retaining Excel colors when pasting into Word or PowerPoint
    By sfflesley in forum Excel General
    Replies: 0
    Last Post: 04-25-2006, 11:15 AM
  4. cell fill colors in excel 2002 sp3
    By T in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  5. cell fill colors in excel 2002 sp3
    By T in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  6. cell fill colors in excel 2002 sp3
    By T in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. Can't format font colors or cell fill-in colors
    By canoeron in forum Excel General
    Replies: 3
    Last Post: 08-22-2005, 07:05 PM

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