Solved How do you repeat the same formula in different cells?

May 21, 2013 at 15:42:10
Specs: Windows XP, 32 BIT
Time sheet
OK SO NOW THAT I'M ABLE TO GET MY FORMULAS TO WORK HOW CAN I GET IT TO REPEAT. FOR EXAMPLE IF I WANT THE SAME ANSWER IN FORMULA IN K-2 TO WORK FOR K'S ALL THE WAY THROUGH DO I HAVE TO CONTINUE TO ENTER THE FORMULA IN EACH BLOCK BECAUSE PASTING GIVES THE WRONG RESULT.

See More: How do you repeat the same formula in different cells?

Report •


#1
May 21, 2013 at 17:12:42
✔ Best Answer
As I said in the other post:

just drag down

Select the cell K2,
notice the small black square in the lower right corner
Move your cursor over the small square
and it will turn into a thin black + sign
With the + sign displayed, drag down.

Copy/Paste will work, but it has to be
Copy / Paste / Special / Formulas

EDIT ADDED:
I should have been a bit more specific:

With the + sign displayed, Left Click & Hold, then drag down.

MIKE

http://www.skeptic.com/


Report •

#2
May 21, 2013 at 17:58:28
Please don't post in all-caps. All-caps is the internet equivalent of yelling and no one likes to be yelled at. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
May 21, 2013 at 18:22:14
ive included a snap shot of my progress in the box below

Report •
Related Solutions


Ask Question