Forum Discussion
priscillamaria
Oct 23, 2019Copper Contributor
Help with Excel
Can someone help me with filling up my document. I know the formula I need to use which is =(some # * some #)/1000. I don't know how to fill up the other cells. I've been entering the formula one-by-...
crieb
Oct 23, 2019Copper Contributor
Are you trying to enter the formulas in columns X - AA? In X3, type =(P3*T3)/1000 then hit Enter. You can then copy (Ctrl + C) and paste (Ctrl + V) down to all your rows and across to all your columns. priscillamaria
nabilmourad
Oct 23, 2019MVP
Hi
You can select the whole range upfront (the 63 Cells)
The cell from which you started the selection is different in color (called Active Cell)
Type an equal sign >> Create the Formula in the Active Cell >> Followed by hitting CTRL + Enter (Not Enter) >> The formula is created in the entire range.
Hope that helps
Nabil Mourad