| View previous topic :: View next topic |
| Author |
Message |
memyselfi
General User
Joined: 27 Jul 2004
Posts: 34
|
 Posted: Sat Mar 25, 2006 9:46 am Post subject: Copying and Pasting |
 |
|
I want to copy a cell with a formula and paste the value onto another sheet. There's no "paste value" in the Paste Special command. If I just do a paste, I get the error #Ref.
Is there a way to paste values across sheets, or even on the same sheet? |
|
| Back to top |
|
 |
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Sat Mar 25, 2006 10:12 am Post subject: |
|
|
| Instead of Paste Special, Value in Excel, Paste Special, then deselect Paste All, deselect Formulas, and select Numbers. |
|
| Back to top |
|
|
buzmeg
Newbie
Joined: 28 Mar 2006
Posts: 3
|
| Posted: Tue Mar 28, 2006 5:15 pm Post subject: Paste formula result rather than formula |
|
|
Could this become a FAQ somewhere, I had this exact question and had a heck of a time finding the answer.
Step 1: Copy the value
Step 2: Select Paste Special
Step 3: In the dialog box which pops up:
Uncheck "Paste All"
Uncheck "Formulas"
Check "Numbers"
Click OK
Don't forget to change back to "Paste All" after doing this or much confusion will result. |
|
| Back to top |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Tue Mar 28, 2006 6:39 pm Post subject: |
|
|
| If you do that often, it would be helpful to record a macro pasting the usual details and attach it to a button in your toolbar. The macro is best placed in the "Standard" library. |
|
| Back to top |
|
|
BookLady
Super User
Joined: 03 Nov 2004
Posts: 727
|
| Posted: Wed Mar 29, 2006 10:12 am Post subject: |
|
|
Secondary tip: use the Insert key to access the Paste Special function. And it will remember the changes made for the duration of the session. Next time OOo is opened it will default to All again.
_________________
One of these days I'm gonna stop procrastinating. |
|
| Back to top |
|
|
|
