I want to be able to select multiple cells and enter a formula so I dont have to enter it in every single cell. I want all of these cells in my example to be x1.2 but quickly. How is this done?
Example CD.xlsx
I want to be able to select multiple cells and enter a formula so I dont have to enter it in every single cell. I want all of these cells in my example to be x1.2 but quickly. How is this done?
Example CD.xlsx
Last edited by flextera; 03-06-2015 at 02:22 PM.
You can type 1.2 into ANY random cell, copy it, then paste special, and select multiply and it will take the value*1.2=new value for all the cells you pasted to.
Is that what you are asking for?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Select the cells, and then just start typing, beginning with =, followed by the formula, and then Ctrl+Enter.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
I cannot get anything to work. Sorry Guys. It always changes every cell to *1.2 it doesn't multiply the current number thats in there.
mikeTRONs superior awesome method Step by step!
In retrospect, if you also wanted to preserve the borders and stuff you could also choose Values from the top menu in Paste Special as well.
Got it!
Mike Trons method worked!
Thanks daff also!
:D :D ;D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks