Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
help w/ generic copy & paste/paste special routine | Excel Programming | |||
How do I capture user paste action and convert to Paste Special | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |