Paste the same formula into multiple cells

I would like to paste a formula into multiple cells
Now I have to paste into cell one
then paste the same formula into cell two
then paste the same formula into cell three ... to 300 ... I dont want to do this manually ... can I create a macro of some sort or a function in excel to specify a range of cells (ie A1 - A300) and then automatically have the formula added to each of the cells for me
Thanks for the help
brontes1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bruintjeCommented:
Hello brontes1,

you can select multiple cells and paste the formula

hope this helps a bit
bruintje
bruintjeCommented:
- in your case copy your formula
- select all the cells you need the formula in
- then choose paste
brontes1Author Commented:
Unfortunetly,
this does not work ... I tried it...
1. I copied the formula
2. I highlighted a range of cells A40 thru A45
3. I went under edit and choose paste  This pastes the formula into cell A40 only Not to the other cells
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

Intense_AngelCommented:
Try paste special.....
bruintjeCommented:
what if you paste it in the first cell
then hightlight the cell
in the lowerright corner a small marker appears
you can drag this marker along the column down as much as needed
fostejoCommented:
brontes1,

You can duplicate the formula in the other cells by 'dragging' the formula into the other cells once you've ensured that the formula isn't going to automatically update itself. In order to do this, precede the items in the formula with a dollar sign; ie.

Normally, if you drag a formula (such as '=a5*b19') down a column, Excel will be 'clever' and alter it so that in the next column it's actually '=a6*b20', then '=a7*b21' etc. etc.

To stop this you'd write your original formula as '=a$5*b$19' instead - now when you drag the formula down, it will NOT change the column references.

hope that helps,

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gad_flyCommented:
Hi

1 - make sure your formula using the fixed value or changed value  ( example :   A2*B2   after you drag it down  it become A3*B3     ------ $A$2*B2  after dragging it down become    $A$2*B3 , you can put  $ to fixed the Column or Row )
(to change the A2 to $A$2 or $A2 or A$2 you can just press F4 to change it on the shape you want )

2 - try to type the formula in this way :  first sellect those cells you want to put formula on it and then type formula and press CTRL+Enter , all the cells change same.


Good Luck

Mohammad Pourebtehaj

BishopTwistCommented:
once you've made sure the formula is going to change (or not change) to your liking, you can paste the function into the first cell, highlight the remaining cells (including the first cell) then press either CTRL-D if you want to fill vertically or CTRL-R if you want to fill horizontally
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.