![]() |
No 'paste special'
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? |
No 'paste special'
Is the sheet protected?
or even more likely, is there anything in the clipboard that can be pasted with pastespecial? -- Regards, Tom Ogilvy "Milco" wrote: 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? |
No 'paste special'
Page is NOT protected and clipboard is empty.
"Milco" wrote: 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? |
No '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 everything be enabled. Henrich €žMilco" napĂ*sal (napĂ*sala): Page is NOT protected and clipboard is empty. "Milco" wrote: 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? |
No 'paste special'
Sorry but I meant that Clipboard was empty beofre I Cut and then tried to
Paste Special. "Henrich" wrote: 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. "Milco" wrote: 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? |
No 'paste special'
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 "Milco" wrote in message ... 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? |
No 'paste special'
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. "Mike Middleton" wrote: 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 "Milco" wrote in message ... 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? |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com