Copying Border Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StainlessSteelRat - 01 Aug 2007 18:24 GMT

Hi folks,

I have a large spreadsheet which is essentially a diary.

I want to format the days and weeks, with thin and thick borders to
distinguish between them. The spreadsheet already has lots of varied fill
formatting for meetings that are held.

I can't see a way of either format painting, or paste special-ing, just
borders.

Is it possible?

Thanks

Signature

StainlessSteelRat
http://www.stainlesssteelrat.net

Stanley: It's not gonna end like this.
Gabriel: Oh, come on, Stan. Not everything ends the way you think it should.
Besides, audiences love happy endings.

Reply to this Message

Jim Rech - 01 Aug 2007 19:46 GMT

True enough that there is no paste function that pastes just borders. How
about recording a macro as you do one manually and play that back as needed?

Signature

Jim

| Hi folks,
|
[quoted text clipped - 10 lines]
|
| Thanks

Reply to this Message

StainlessSteelRat - 01 Aug 2007 19:52 GMT

> True enough that there is no paste function that pastes just borders.
> How about recording a macro as you do one manually and play that back
> as needed?

Thanks for the reply.

I'll give it a go, assuming it'll cope with the whole procedure.

I did think of an alternative, which is to move all the cells to the right,
copy the formatting, then copy the cell contents back *without* borders.

Seems strange that Excel is missing this though, as borders would seem to be
something that might need to be repeated.

Signature

StainlessSteelRat
http://www.stainlesssteelrat.net

"It's just like the story of the grasshopper and the octopus. All year
long, the grasshopper kept burying acorns for the winter, while the
octopus mooched off his girlfriend and watched TV. But then the winter
came, and the grasshopper died, and the octopus ate all his acorns. And
also he got a race car. Is any of this getting through to you?" -- Fry

Reply to this Message