You are here:

Excel/excel cell color copy paste


Rubin wrote at 2010-03-26 03:18:18
I realize Anwar was thrilled, but

just step 9/10 and click the interior color button on the home tab should accomplish the same thing.  Granted the user would have to be able to select the same color if he or she wanted to repeat the procedure.  


Rubin wrote at 2010-03-26 15:03:51
Oh, I see.  Anwar thinks 12 steps is better than 2 steps.  I guess he asked for it.  This defies common sense.  Amazing (on Anwar's part, not Michelle's)  

GadeyneDries wrote at 2010-10-21 04:12:04
Hi Michelle,

How would you do this in Excel 2003??

I want to copy the exact same color from a cell in a workbook to another workbook, but each time the color doesn't come with it and if I look at the cell parametres then I see that "No Color" is selected for cell background.

I believe the person who initially made this, made it in excel 2007.


Ken wrote at 2012-10-16 19:59:18
I have a similar question. I have an existing worksheet with different colors in different cells, created by someone. I want to copy one of those colors and apply to another new empty cell. If I follow Michelle's steps I can't find the exact color to create the Style. I tried "Format Painter" but it doesn't work. It seems that the colors are not from the standard list and must be Customized. I tried "Format Painter" but it doesn't work. Any suggestions?

pyttemjuk wrote at 2012-12-19 10:42:34
Hi all,

does the 1-12 procedure really accomplish what is asked for -- a pure copying of fills? It seems to be more of a manual fill instruction, cell by cell. Regarding the question -- consider having a 100x100 cell area with a specific cell fill pattern (some yellow, some green, some no fill etc). Now we want to copy this *whole* kaleidoscope of fills to another area in one copy/paste-maneuver; just the fills, not borders or text or any other attributes. How?

I just discovered [copy]/[paste special] with alternative "All except borders" could help partly on this. But what if I want purely fill color copying, without e g text being copied?

Bob M. wrote at 2013-02-20 12:57:18
Please try this link, you question is answered properly here.

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


Michelle Howell


I specialize in formatting, charts/graphs and non-technical areas of Excel. Primarily subject areas listed below in Microsoft Excel 2003, 2007 or 2010. You will find many people with a greater level of proficiency in the areas of Formulas and Development than myself on this site.

BASIC Creating a Basic Worksheet | Performing Calculations | Modifying a Worksheet | Formatting a Worksheet | Printing Workbook Contents | Managing Large Workbooks
INTERMEDIATE Organizing Worksheet and Table Data | Presenting Data Using Charts | Inserting Graphic Objects | Customizing and Enhancing Workbooks | Themes | Templates | Collaborating | Restricting Access | Protecting Files | Working with Multiple Workbooks | Linking Cells | Editing Links | Importing and Exporting Data | Working with Templates and Charts | Managing Data in Workbooks
ADVANCED - Do not have adequate proficiency to answer the topics below.
Calculating Data with Advanced Formulas | Auditing Worksheets | Analyzing Data | Using Excel with the Web | Structuring Workbooks with XML | Manipulating Data Using Statistical and Lookup Functions | Analyzing Data Using Data Analysis Tools | Working with Data Using Financial Functions | Examining Data Using Math Functions | VBA of any kind
CANNOT ANSWER MAC questions do not own one | 97 or 2000 no longer have software for reference | OpenOffice related questions do not have experience with this interface


Proposal, presentation and coordination professional possessing over fifteen years experience with diverse industries including investment banking, marketing, consulting, defense, aerospace and other contracting agencies. In depth software knowledge and certifications including Microsoft Office Specialist (MOS) 2000 and 2003 certifications as well as extensive training and experience in Microsoft Office 2007 and Adobe products. Projects have included production coordination, financial reporting, database maintenance, template design of various manuals, design of numerous high-end electronic presentations and form design. Years of experience as an operator and supervisor in multiple Microsoft Office based proposal centers in NYC, Connecticut and Colorado.

Microsoft 2003 | 2007 | 2010 Excel | Outlook | PowerPoint | Visio | Word | RFP | Request for Proposal | Adobe PDF 9 Pro| Templates | Boilerplates | Coordination

Michelle Howell's Website | Request for Proposal (RFP) Support Services

Proposal and RFP Microsoft Q&A Blog | Michelle Howell's Profile on LinkedIn

Microsoft Office User Specialist (MOUS) 2003Excel | Outlook | PowerPoint | Expert Word
Microsoft Office Specialist (MOS) 2000 | Excel | Outlook | PowerPoint | Expert Word

Past/Present Clients
AOR | AT&T | Ball Aerospace | Boeing | Brains at Work | C&H Consulting | Citicorp | Colomer Group | Duke Energy | | EDS | EquaTerra | General Dynamics | Goyak Consulting | HB Management | M.D. Anderson Cancer Center | Marsh Fischmann & Breyfogle | McClain Finlon | Plasmon | Raytheon | Space Imaging | Tactical Training Specialists (TTS) | The Brendle Group | TM Design | Trineum Partners | UBS | Vexcel | WillowTree Advisors | Zeto Creative

©2017 All rights reserved.