If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
why cant I copy and paste a formula?
I have a simple numbered sheet that I data sorted. Now I can't get the
numbers to stop repeating themselves when I copy and paste or even click the right bottom corner and drag. EG. it supposed to go 1,2,3,4,5 and so on down column A, but when I try to copy and paste from A2(=A1+1) down it keeps pasting 2 and after checking the pasted cell it has the correct formulas??? please help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! |
#2
|
|||
|
|||
why cant I copy and paste a formula?
Hi
It sounds like your calculation may be set to manual. Hit F9 and see if it recalculates. To change the setting, go to Tools/Options/Calculation and set it to automatic. Andy. "Bryan J Bloom" wrote in message ... I have a simple numbered sheet that I data sorted. Now I can't get the numbers to stop repeating themselves when I copy and paste or even click the right bottom corner and drag. EG. it supposed to go 1,2,3,4,5 and so on down column A, but when I try to copy and paste from A2(=A1+1) down it keeps pasting 2 and after checking the pasted cell it has the correct formulas??? please help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! |
#3
|
|||
|
|||
why cant I copy and paste a formula?
Try COPY, PASTE SPECIAL, VALUES so that the formula is not being copied, just
the numbers as you see them. "Bryan J Bloom" wrote: I have a simple numbered sheet that I data sorted. Now I can't get the numbers to stop repeating themselves when I copy and paste or even click the right bottom corner and drag. EG. it supposed to go 1,2,3,4,5 and so on down column A, but when I try to copy and paste from A2(=A1+1) down it keeps pasting 2 and after checking the pasted cell it has the correct formulas??? please help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy Paste of Formula Produces Incorrect Result | JLa | General Discussion | 1 | May 17th, 2005 06:56 PM |
copy formula vertical and paste horizontal | mango | Worksheet Functions | 2 | September 21st, 2004 09:38 AM |
Formula copy and paste problem | Gary Jordan | Worksheet Functions | 1 | February 26th, 2004 07:06 PM |
Copy Paste only formula across wksheet | karl odonoghue | Worksheet Functions | 1 | January 8th, 2004 09:46 AM |
Copy and Paste Conditional Sum Formula | David Kinkella | Worksheet Functions | 1 | September 20th, 2003 01:18 AM |