Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy an entire sheet | Excel Discussion (Misc queries) | |||
Copy Entire Sheet | Excel Discussion (Misc queries) | |||
How do you formulate an entire column? | Excel Worksheet Functions | |||
Copy the entire sheet to overlay existing sheet? | New Users to Excel | |||
Referencing an Entire Sheet | Excel Discussion (Misc queries) |