Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to copy table cell shading to another cell in Word?

20,390 views
Skip to first unread message

owyheerover

unread,
Nov 27, 2008, 2:24:04 PM11/27/08
to
I have added cell shading to a table cell in word. Now I would like to
repeat this color in another cell. But I cannot figure out what the current
color is.

The "Shading" tool does not display the current shading of the cell.

When the cell was first shaded, the color was then displayed in the
"recently used colors" list. But since closing word and reopening, this list
is blank.

How can I determine what the cell shading is, or copy the shading to another
cell?

Thanks.

--
Bill Clark
www.earthpoint.us

Jean-Guy Marcil

unread,
Nov 27, 2008, 3:51:00 PM11/27/08
to
"owyheerover" wrote:

If you selectt he cell, and then do Format > Borders and Shading... >
Shading tab, Word will tell you the shade being used in the current cell.
Just make sure to select cell(s) that all have the exact same colour.

To copy quickly from one cell to another, I believe you need a macro for
that. Do you want to go that way or just do it manually?

owyheerover

unread,
Nov 27, 2008, 4:09:01 PM11/27/08
to
For me, using Word 2007, the shading tab does not show the current color.
The conditions are
1) it is a custom color
2) close word and reopen the file.

You can see a picture at http://www.earthpoint.us/downloads/shading.jpg

--
Bill Clark
www.earthpoint.us

Doug Robbins - Word MVP

unread,
Nov 27, 2008, 4:39:45 PM11/27/08
to
The following will set the shading of the first table in a document to the
shading that is applied to the cell in the first column of the first row of
the second table in the document.

With ActiveDocument
.Tables(1).Shading.BackgroundPatternColor = .Tables(2).Cell(1,
1).Shading.BackgroundPatternColor
End With


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"owyheerover" <owyhe...@discussions.microsoft.com> wrote in message
news:A80956B4-CE06-4711...@microsoft.com...

Klaus Linke

unread,
Nov 27, 2008, 8:38:55 PM11/27/08
to
"Jean-Guy Marcil" wrote:
> If you selectt he cell, and then do Format > Borders and Shading... >
> Shading tab, Word will tell you the shade being used in the current cell.
> Just make sure to select cell(s) that all have the exact same colour.

If you've done one cell, you can select another cell and hit F4, to apply
the same shading.

Klaus

hks

unread,
Nov 28, 2008, 1:03:54 AM11/28/08
to

Klaus Linke;381011 Wrote:
> "Jean-Guy Marcil" wrote:-

> If you selectt he cell, and then do Format Borders and Shading...
> Shading tab, Word will tell you the shade being used in the current
> cell.
> Just make sure to select cell(s) that all have the exact same
> colour.-

>
> If you've done one cell, you can select another cell and hit F4, to
> apply
> the same shading.
>
> Klaus

you can ctrl + c to cell padding which you want copy, or you block your
cell padding after that copy..
and paste to your word.


--
hks

Jean-Guy Marcil

unread,
Nov 28, 2008, 4:02:01 PM11/28/08
to
"owyheerover" wrote:

> For me, using Word 2007, the shading tab does not show the current color.
> The conditions are
> 1) it is a custom color
> 2) close word and reopen the file.
>
> You can see a picture at http://www.earthpoint.us/downloads/shading.jpg

And if you click on "More Colours..."?

PamC via OfficeKB.com

unread,
Nov 29, 2008, 11:19:54 AM11/29/08
to
It's too bad that W2007 is even more picky about giving up the color numbers
than W2003 is (you can't just have the cursor in the cell; the cell must be
selected, etc.). You've probably already noticed that as long as you are in
the same W2007 session that the color was chosen in, it will be highlighted
in either in the theme, standard colors, or recent colors sections of the
shading dropdown. In later sessions, go to the reveal formatting pane
(styles pane > style inspector (does anyone see a use for this feature?)
button > reveal formatting button—or add the reveal formatting command to
your QAT) to get the color number.

PamC

owyheerover wrote:
>For me, using Word 2007, the shading tab does not show the current color.
>The conditions are
>1) it is a custom color
>2) close word and reopen the file.
>
>You can see a picture at http://www.earthpoint.us/downloads/shading.jpg
>

>> > I have added cell shading to a table cell in word. Now I would like to
>> > repeat this color in another cell. But I cannot figure out what the current

>[quoted text clipped - 15 lines]


>> To copy quickly from one cell to another, I believe you need a macro for
>> that. Do you want to go that way or just do it manually?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-tables/200811/1

Jamason

unread,
Oct 23, 2010, 9:27:07 AM10/23/10
to
Hi

I did a alt print scrn
pasted the screen in to MS paint and used the color picker to select the color. You will see that it has now selected that color in the foreground color block.

Now select Edit colors and there you will find the colours red 102, green, 232, blue 123, use this back in word or excel to use your color.

Regards
DarkSide

> On Thursday, November 27, 2008 2:24 PM owyheerove wrote:

> I have added cell shading to a table cell in word. Now I would like to
> repeat this color in another cell. But I cannot figure out what the current
> color is.
>
> The "Shading" tool does not display the current shading of the cell.
>
> When the cell was first shaded, the color was then displayed in the
> "recently used colors" list. But since closing word and reopening, this list
> is blank.
>
> How can I determine what the cell shading is, or copy the shading to another
> cell?
>

> Thanks.
>
> --
> Bill Clark
> www.earthpoint.us


>> On Thursday, November 27, 2008 3:51 PM JeanGuyMarci wrote:

>> "owyheerover" wrote:
>>
>>
>> If you selectt he cell, and then do Format > Borders and Shading... >
>> Shading tab, Word will tell you the shade being used in the current cell.
>> Just make sure to select cell(s) that all have the exact same colour.
>>
>> To copy quickly from one cell to another, I believe you need a macro for
>> that. Do you want to go that way or just do it manually?


>>> On Thursday, November 27, 2008 4:09 PM owyheerove wrote:

>>> For me, using Word 2007, the shading tab does not show the current color.
>>> The conditions are
>>> 1) it is a custom color
>>> 2) close word and reopen the file.
>>>
>>> You can see a picture at http://www.earthpoint.us/downloads/shading.jpg
>>>
>>> --
>>> Bill Clark
>>> www.earthpoint.us
>>>
>>>
>>> "Jean-Guy Marcil" wrote:


>>>> On Thursday, November 27, 2008 4:39 PM Doug Robbins - Word MVP wrote:

>>>> The following will set the shading of the first table in a document to the
>>>> shading that is applied to the cell in the first column of the first row of
>>>> the second table in the document.
>>>>
>>>> With ActiveDocument
>>>> .Tables(1).Shading.BackgroundPatternColor = .Tables(2).Cell(1,
>>>> 1).Shading.BackgroundPatternColor
>>>> End With
>>>>
>>>>
>>>> --
>>>> Hope this helps.
>>>>
>>>> Please reply to the newsgroup unless you wish to avail yourself of my
>>>> services on a paid consulting basis.
>>>>
>>>> Doug Robbins - Word MVP
>>>>
>>>> "owyheerover" <owyhe...@discussions.microsoft.com> wrote in message
>>>> news:A80956B4-CE06-4711...@microsoft.com...


>>>>> On Thursday, November 27, 2008 8:38 PM Klaus Linke wrote:

>>>>> "Jean-Guy Marcil" wrote:
>>>>>
>>>>> If you have done one cell, you can select another cell and hit F4, to apply
>>>>> the same shading.
>>>>>
>>>>> Klaus


>>>>>> On Friday, November 28, 2008 1:03 AM hks wrote:

>>>>>> Klaus Linke;381011 Wrote:
>>>>>>
>>>>>> you can ctrl + c to cell padding which you want copy, or you block your
>>>>>> cell padding after that copy..
>>>>>> and paste to your word.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> hks


>>>>>>> On Friday, November 28, 2008 4:02 PM JeanGuyMarci wrote:

>>>>>>> "owyheerover" wrote:
>>>>>>>
>>>>>>>
>>>>>>> And if you click on "More Colours..."?


>>>>>>>> On Saturday, November 29, 2008 11:19 AM PamC via OfficeKB.com wrote:

>>>>>>>> It's too bad that W2007 is even more picky about giving up the color numbers
>>>>>>>> than W2003 is (you can't just have the cursor in the cell; the cell must be
>>>>>>>> selected, etc.). You've probably already noticed that as long as you are in
>>>>>>>> the same W2007 session that the color was chosen in, it will be highlighted
>>>>>>>> in either in the theme, standard colors, or recent colors sections of the
>>>>>>>> shading dropdown. In later sessions, go to the reveal formatting pane
>>>>>>>> (styles pane > style inspector (does anyone see a use for this feature?)

>>>>>>>> button > reveal formatting button???or add the reveal formatting command to


>>>>>>>> your QAT) to get the color number.
>>>>>>>>
>>>>>>>> PamC
>>>>>>>>
>>>>>>>> owyheerover wrote:
>>>>>>>>
>>>>>>>> --
>>>>>>>> Message posted via OfficeKB.com
>>>>>>>> http://www.officekb.com/Uwe/Forums.aspx/word-tables/200811/1


>>>>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>>>>>>> ASP.NET MaskedTextBox Custom Control
>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/39a071cd-9f96-4e81-9346-4e445181d645/aspnet-maskedtextbox-custom-control.aspx

Dan

unread,
Oct 13, 2011, 10:57:34 AM10/13/11
to
I ran into this same issue in Word 2010 and finally figured it out:

1. Click in the cell you want to inspect
2. On the Table Layout ribbon, all the way on the left click the "Select" drop-down and choose "Select Cell"
3. Right-click on the selected cell
4. Choose "Borders and Shading..."

Now the Borders and Shading dialog shows the current properties of the selected cell, including Fill color on the Shading tab.

> On Thursday, November 27, 2008 2:24 PM owyheerove wrote:

>>>>>>>> button > reveal formatting button—or add the reveal formatting command to


>>>>>>>> your QAT) to get the color number.
>>>>>>>>
>>>>>>>> PamC
>>>>>>>>
>>>>>>>> owyheerover wrote:
>>>>>>>>
>>>>>>>> --
>>>>>>>> Message posted via OfficeKB.com
>>>>>>>> http://www.officekb.com/Uwe/Forums.aspx/word-tables/200811/1

fauxt...@gmail.com

unread,
Oct 10, 2013, 2:31:55 PM10/10/13
to

fauxt...@gmail.com

unread,
Oct 10, 2013, 2:52:37 PM10/10/13
to
On Thursday, November 27, 2008 12:24:04 PM UTC-7, owyheerover wrote:
Click on the cell that has the color you wish to copy. Right click to get to Borders & Shading. The RGB color code appears (i.e., 238,236,225). Make note of the code. Click on "More Colors" and then the "Color Sliders" symbol. While the subject cell(s) are still highlighted, input the RGB color codes. For example 238 for Red, 236 for Green, and 225 for Blue. Click ok and the color is then applied to the highlighted cell(s) in your document. BTW, this is working with Word for Mac 2011.

ben...@gmail.com

unread,
Jan 15, 2014, 10:23:25 PM1/15/14
to
I ran into the same issue, I created a video of my solution if anyone still needs the info.

http://youtu.be/JthQX5AKbvA

danielle...@gmail.com

unread,
Apr 29, 2015, 3:53:29 PM4/29/15
to
On Wednesday, January 15, 2014 at 9:23:25 PM UTC-6, ben...@gmail.com wrote:
> I ran into the same issue, I created a video of my solution if anyone still needs the info.
>
> http://youtu.be/JthQX5AKbvA

Hi there, I am having these issues and some of the advice is not working for me. I have a mac pro and am running on word 2011. Will your video help me? If so can you make it available to me? It doesnt let me see it because it says its private and I have to sign in.

Thanks, D

Stefan Blom

unread,
Apr 29, 2015, 6:15:24 PM4/29/15
to
I recommend that you ask your question in the MacWord forum in the Microsoft
Community. Go to
http://answers.microsoft.com/en-us/mac/forum/macword?sort=lastreplydate&dir=desc&tab=Threads.
You'll need to sign in using a Microsoft account (for example with a Hotmail
account).

--
Stefan Blom
Microsoft Word MVP




<danielle...@gmail.com> wrote in message
news:68537279-ca03-4993...@googlegroups.com...

cathyb...@hotmail.com

unread,
May 18, 2017, 11:53:02 AM5/18/17
to
It's different in Word 16. Under Table Tools, select Design. Select the cell(s) to be shaded, and select the color under Shading.

0 new messages