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

How do I copy cell format (borders etc) to another cell

4,033 views
Skip to first unread message

jamowa

unread,
Jul 23, 2009, 12:16:11 PM7/23/09
to
I have many cells in a Word table that I want to have the same borders/lines
format. Is it possible to copy the formatting of one cell to multiple cells?
Like in Excel?
Thanks

Stefan Blom

unread,
Jul 24, 2009, 10:07:13 AM7/24/09
to

Select the cell that has the desired formatting. Open the Borders and
Shading dialog box and click OK (to confirm the settings). Then you should
be able to select other cells and press F4 to repeat the settings of the
dialog box.

--
Stefan Blom
Microsoft Word MVP

"jamowa" <jam...@discussions.microsoft.com> wrote in message
news:AE354879-D799-485E...@microsoft.com...

Jean-Guy Marcil

unread,
Jul 23, 2009, 10:50:26 PM7/23/09
to
jamowa was telling us:
jamowa nous racontait que :

Not like in Excel.

You can use a macro
(Select a cell, start the macro recorder, format the cell as you wish by
using as few clicks as possible, stop the recorder, use the recorded macro
to format other cells in a similar manner)
or
create a table style.

--
______________________________
Jean-Guy Marcil
Montreal, Canada


jamowa

unread,
Jul 27, 2009, 1:19:01 PM7/27/09
to
Thanks, Stefan, using the F4 key certainly works to paste a cell format to
another cell. Is there a way to paste to multiple cells?

I was able to paste the same border lines to individual cells selected,
however, when I tried to paste this format (left, bottom, right lines) to
multiple cells the line format appeared on the 1st cell left side, last cell
right side, and across the bottom of all cells.

Merci,
jamowa

Stefan Blom

unread,
Jul 27, 2009, 1:42:26 PM7/27/09
to
First format two adjacent cells, one at a time, via F4; then select both of
these cells, open the Borders and Shading dialog box, verify that the
settings are correct, and click OK. You should now be able to apply the
formatting to multiple cells with F4.

--
Stefan Blom
Microsoft Word MVP

"jamowa" <jam...@discussions.microsoft.com> wrote in message

news:5F49DC31-DB60-4F9B...@microsoft.com...

jamowa

unread,
Jul 27, 2009, 2:33:01 PM7/27/09
to
Thanks, Stefan, I'll give that a try.

Stefan Blom

unread,
Jul 28, 2009, 7:01:39 AM7/28/09
to
Post back if you run into trouble.

--
Stefan Blom
Microsoft Word MVP

"jamowa" <jam...@discussions.microsoft.com> wrote in message

news:07954962-9C6C-436C...@microsoft.com...

Suzanne S. Barnhill

unread,
Aug 6, 2009, 12:06:37 PM8/6/09
to
As Stefan has implied, when you format a single cell, you get only the
options for Top, Bottom, Left, and Right. If you select multiple cells, then
you can also format the Vertical/Horizontal Inside borders, which will then
apply when you select multiple cells and press F4.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"jamowa" <jam...@discussions.microsoft.com> wrote in message

news:5F49DC31-DB60-4F9B...@microsoft.com...

0 new messages