Paste Special Enhancement Request

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jcombe@acxiom.co.uk - 29 Nov 2006 16:46 GMT

I have a cell that contains a formula and formatting. I want to copy
the output from the formula and it's formatting. If I do "Paste
Special" I can choose "Value" to paste the value of the copied cell,
but I cannot copy the format, as the choices are radio buttons and so
mutually exclusive.

It would be nice if these options could be tick boxes, so that more
than one can be selected.

Is this possible/planned?

I am using Office 2003, so it is possible this is implemented in 2007.

Reply to this Message

Dave Peterson - 29 Nov 2006 17:50 GMT

But you could do two consecutive paste specials--values followed by format.

> I have a cell that contains a formula and formatting. I want to copy
> the output from the formula and it's formatting. If I do "Paste
[quoted text clipped - 8 lines]
>
> I am using Office 2003, so it is possible this is implemented in 2007.

Signature

Dave Peterson

Reply to this Message

jcombe@acxiom.co.uk - 30 Nov 2006 09:08 GMT

> But you could do two consecutive paste specials--values followed by format.

Yes you could, but it's not as quick, is it?

Reply to this Message

Dave Peterson - 30 Nov 2006 15:50 GMT

Depends when you start timing...

If you're gonna wait until it's incorporated into excel, yours might take longer
<vbg>.

> > But you could do two consecutive paste specials--values followed by format.
>
> Yes you could, but it's not as quick, is it?

Signature

Dave Peterson

Reply to this Message

Rate this thread: