Discussion:
How to copy table cell shading to another cell in Word?
(too old to reply)
owyheerover
2008-11-27 19:24:04 UTC
Permalink
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
2008-11-27 20:51:00 UTC
Permalink
Post by owyheerover
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?
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
2008-11-27 21:09:01 UTC
Permalink
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 Loading Image...
--
Bill Clark
www.earthpoint.us
Post by Jean-Guy Marcil
Post by owyheerover
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?
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?
Jean-Guy Marcil
2008-11-28 21:02:01 UTC
Permalink
Post by owyheerover
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
2008-11-29 16:19:54 UTC
Permalink
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
Post by owyheerover
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
Post by Jean-Guy Marcil
Post by owyheerover
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]
Post by Jean-Guy Marcil
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
2010-10-23 13:27:07 UTC
Permalink
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
Post by owyheerover
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
Post by Jean-Guy Marcil
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?
Post by owyheerover
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
Post by Doug Robbins - Word MVP
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
If you have done one cell, you can select another cell and hit F4, to apply
the same shading.
Klaus
Post by hks
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
Post by Jean-Guy Marcil
And if you click on "More Colours..."?
Post by PamC via OfficeKB.com
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
--
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
Klaus Linke
2008-11-28 01:38:55 UTC
Permalink
Post by Jean-Guy Marcil
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
2008-11-28 06:03:54 UTC
Permalink
"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
Doug Robbins - Word MVP
2008-11-27 21:39:45 UTC
Permalink
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
Post by owyheerover
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
Dan
2011-10-13 14:57:34 UTC
Permalink
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.
Post by owyheerover
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
Post by Jean-Guy Marcil
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?
Post by owyheerover
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
Post by Doug Robbins - Word MVP
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
If you have done one cell, you can select another cell and hit F4, to apply
the same shading.
Klaus
Post by hks
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
Post by Jean-Guy Marcil
And if you click on "More Colours..."?
Post by PamC via OfficeKB.com
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
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-tables/200811/1
Post by Jamason
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
f***@gmail.com
2013-10-10 18:31:55 UTC
Permalink
Post by owyheerover
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
f***@gmail.com
2013-10-10 18:52:37 UTC
Permalink
Post by owyheerover
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
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.
b***@gmail.com
2014-01-16 03:23:25 UTC
Permalink
I ran into the same issue, I created a video of my solution if anyone still needs the info.


d***@gmail.com
2015-04-29 19:53:28 UTC
Permalink
Post by b***@gmail.com
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
2015-04-29 22:15:23 UTC
Permalink
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
Post by d***@gmail.com
Post by b***@gmail.com
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
c***@hotmail.com
2017-05-18 15:53:01 UTC
Permalink
Post by owyheerover
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
It's different in Word 16. Under Table Tools, select Design. Select the cell(s) to be shaded, and select the color under Shading.
Loading...