Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
applying a formula to an entire spreadsheet
I am trying to average several numbers on a sheet. I figured out how to get
r3/x3 but I don't want to type this in for 250 rows. How do I apply it to the whole spreadsheet? I have limited to computer skills, just have enough to be dangerous. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
applying a formula to an entire spreadsheet
I'd assume you have entered in say, Y3: =R3/X3. To copy Y3 down, just point
your cursor to the bottom right corner of Y3 (the cursor will turn into a solid black square -- that's the fill handle), then drag it down as far as required. And if the adjacent col X contains data all the way down, then you just need to double-click on Y3's fill handle, and the formula in Y3 will fill down to the last data row in col X. -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- "michelle" wrote: I am trying to average several numbers on a sheet. I figured out how to get r3/x3 but I don't want to type this in for 250 rows. How do I apply it to the whole spreadsheet? I have limited to computer skills, just have enough to be dangerous. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
applying a formula to an entire spreadsheet
Thank you, I knew there had to be an easy way I just how no idea how to do it.
"Max" wrote: I'd assume you have entered in say, Y3: =R3/X3. To copy Y3 down, just point your cursor to the bottom right corner of Y3 (the cursor will turn into a solid black square -- that's the fill handle), then drag it down as far as required. And if the adjacent col X contains data all the way down, then you just need to double-click on Y3's fill handle, and the formula in Y3 will fill down to the last data row in col X. -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- "michelle" wrote: I am trying to average several numbers on a sheet. I figured out how to get r3/x3 but I don't want to type this in for 250 rows. How do I apply it to the whole spreadsheet? I have limited to computer skills, just have enough to be dangerous. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
applying a formula to an entire spreadsheet
Thank you, I knew there had to be an easy way
I just had no idea how to do it. Welcome. Pl take a moment to rate that response by pressing the Yes button (like the ones below). -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
applying rounding formula to entire worksheet | Excel Worksheet Functions | |||
Applying color to an entire row | Excel Discussion (Misc queries) | |||
Applying pop up calendar to entire worksheet | Excel Worksheet Functions | |||
Applying formula to an entire column | Excel Discussion (Misc queries) | |||
Applying a formula to an entire column | Excel Discussion (Misc queries) |