Copying Border Formatting

  • Thread starter Thread starter StainlessSteelRat
  • Start date Start date
S

StainlessSteelRat

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

--
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.
 
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?

--
Jim
| 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
|
| --
| 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.
|
|
 
Jim said:
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?
Click to expand...

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.

--
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
 
Back
Top