No 'paste special'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Milco - 23 Mar 2006 15:05 GMT

I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
1024M. I am trying to transpose some rows and columns and Paste Special is
grayed out and unavailable. Is this a problem with Office, Excel, XP(home),
or ?.? Is there a work around without reinstalling any or all of the above?

Reply to this Message

Tom Ogilvy - 23 Mar 2006 15:09 GMT

Is the sheet protected?

or even more likely, is there anything in the clipboard that can be pasted
with pastespecial?

Signature

Regards,
Tom Ogilvy

> I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
> 1024M. I am trying to transpose some rows and columns and Paste Special is
> grayed out and unavailable. Is this a problem with Office, Excel, XP(home),
> or ?.? Is there a work around without reinstalling any or all of the above?

Reply to this Message

Milco - 23 Mar 2006 16:29 GMT

Page is NOT protected and clipboard is empty.

Reply to this Message

Henrich - 23 Mar 2006 16:49 GMT

Hi, so when your clipboard is empty Paste special will be grayed (disabled)
for ever and also Paste. Put some data in your clipboard and then should
everything be enabled.

Henrich

„Milco" napísal (napísala):

> Page is NOT protected and clipboard is empty.
>
> > I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
> > 1024M. I am trying to transpose some rows and columns and Paste Special is
> > grayed out and unavailable. Is this a problem with Office, Excel, XP(home),
> > or ?.? Is there a work around without reinstalling any or all of the above?

Reply to this Message

Milco - 23 Mar 2006 19:12 GMT

Sorry but I meant that Clipboard was empty beofre I Cut and then tried to
Paste Special.

> Hi, so when your clipboard is empty Paste special will be grayed (disabled)
> for ever and also Paste. Put some data in your clipboard and then should
[quoted text clipped - 10 lines]
> > > grayed out and unavailable. Is this a problem with Office, Excel, XP(home),
> > > or ?.? Is there a work around without reinstalling any or all of the above?

Reply to this Message

Mike Middleton - 23 Mar 2006 20:49 GMT

Milco -

If you first choose Edit | Cut, Paste Special is greyed out.

If you first choose Edit | Copy, Paste Special is available.

- Mike
www.mikemiddleton.com

>I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
> 1024M. I am trying to transpose some rows and columns and Paste Special
[quoted text clipped - 3 lines]
> or ?.? Is there a work around without reinstalling any or all of the
> above?

Reply to this Message

Milco - 23 Mar 2006 22:30 GMT

Thanks, that did the trick. Actually I selected range, then CTRL X as per
the answer to my question under Excel-Worksheet function asking how to
convert rows to columns.

> Milco -
>
[quoted text clipped - 12 lines]
> > or ?.? Is there a work around without reinstalling any or all of the
> > above?

Reply to this Message