Paste Special borders format only, not colours or font

RET79 · May 13th, 2002, 01:11 PM

Gosh I could do with this guys, is it possible...

paste special format pastes colours and fonts too, I just want to copy and paste the borders.

RET79

[ This Message was edited by: RET79 on 2002-05-13 12:13 ]

Mark W. · May 13th, 2002, 01:14 PM

Create and apply a style. See the Excel Help topic for "Format cells and lists quickly with styles or built-in table formats".

Chris Davison · May 13th, 2002, 01:37 PM

Mark.... this is fantastic ! maybe 20 seconds saved.... but in a whole day, quite a few minutes, maybe a whole hour or so in a working week

dimrod · May 13th, 2002, 02:57 PM

Quote:

On 2002-05-13 12:37, Chris Davison wrote:
Mark.... this is fantastic ! maybe 20 seconds saved.... but in a whole day, quite a few minutes, maybe a whole hour or so in a working week

Does that mean if you normally do a 35 hour week, and you find 34 more time savers like that, you won't have to go to work at all?

Chris Davison · May 13th, 2002, 03:04 PM

no idea, I'm not very good with numbers.

dimrod · May 13th, 2002, 04:35 PM

Perhaps someone who is better with numbers can provide an answer?

Mark W. · May 13th, 2002, 04:38 PM

Quote:

On 2002-05-13 15:35, dimrod wrote:
Perhaps someone who is better with numbers can provide an answer?

Memo to dimrod... lookup "downsize" at www.m-w.com.

dimrod · May 13th, 2002, 04:50 PM

[/quote]
Memo to dimrod... lookup "downsize" at www.m-w.com.

[/quote]

Well, that wasn't much help.

Perhaps you meant that I should lookdown "upsize" ?

dimrod · May 13th, 2002, 05:01 PM

Quote:

Well, that wasn't much help.

Perhaps you meant that I should lookdown "upsize" ?

Yes!! That was it !!

Thanks for pointing me in the right direction, Mark.

Yogi Anand · May 13th, 2002, 06:40 PM

Hi Mark and dimrod:
Wouldn't the politically correct term be 'right size'?

Regards!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 01:11 PM	#1
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	Gosh I could do with this guys, is it possible... paste special format pastes colours and fonts too, I just want to copy and paste the borders. RET79 [ This Message was edited by: RET79 on 2002-05-13 12:13 ]

May 13th, 2002, 01:14 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Create and apply a style. See the Excel Help topic for "Format cells and lists quickly with styles or built-in table formats".

May 13th, 2002, 01:37 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Mark.... this is fantastic ! maybe 20 seconds saved.... but in a whole day, quite a few minutes, maybe a whole hour or so in a working week

May 13th, 2002, 03:04 PM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	no idea, I'm not very good with numbers.

May 13th, 2002, 04:35 PM	#6
dimrod Join Date: May 2002 Posts: 73	Perhaps someone who is better with numbers can provide an answer?

May 13th, 2002, 04:50 PM	#8
dimrod Join Date: May 2002 Posts: 73	[/quote] Memo to dimrod... lookup "downsize" at www.m-w.com. [/quote] Well, that wasn't much help. Perhaps you meant that I should lookdown "upsize" ?

May 13th, 2002, 06:40 PM	#10
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi Mark and dimrod: Wouldn't the politically correct term be 'right size'? Regards!