ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formulate Entire Sheet (https://www.excelbanter.com/excel-discussion-misc-queries/256002-formulate-entire-sheet.html)

Bigdaddykdk

Formulate Entire Sheet
 
I want to formulate my worksheet without have to go row by row. Example:
=SUM(C4*0.5) =SUM(E4*15) =SUM(G4+F4+D4) =SUM(I4-H4)

I want to do this in every row. How do I do that?


Vics

Formulate Entire Sheet
 
If you highlight all 4 cells then usr your cell/fill handle to copy them.

when you highlight some cells you get a black border around them, the bottom
right hand corner of this black border is a small black square, when you
hover your mouse over it your cursor will turn into a thin black cross. Just
click on this and drag down and it should copy all your formulas

Hope it helps

"Bigdaddykdk" wrote:

I want to formulate my worksheet without have to go row by row. Example:
=SUM(C4*0.5) =SUM(E4*15) =SUM(G4+F4+D4) =SUM(I4-H4)

I want to do this in every row. How do I do that?


David Biddulph[_2_]

Formulate Entire Sheet
 
See your other message. No need to ask again.
--
David Biddulph

Bigdaddykdk wrote:
I want to formulate my worksheet without have to go row by row.
Example: =SUM(C4*0.5) =SUM(E4*15) =SUM(G4+F4+D4) =SUM(I4-H4)

I want to do this in every row. How do I do that?





All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com