Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy an entire sheet Gynandra Excel Discussion (Misc queries) 1 June 28th 06 04:31 AM
Copy Entire Sheet Linda Excel Discussion (Misc queries) 1 June 11th 06 11:04 PM
How do you formulate an entire column? SWcoord Excel Worksheet Functions 1 February 15th 06 06:39 PM
Copy the entire sheet to overlay existing sheet? LurfysMa New Users to Excel 2 August 29th 05 07:05 PM
Referencing an Entire Sheet Chaplain Doug Excel Discussion (Misc queries) 2 December 22nd 04 04:59 PM


All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"