Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to use same formula throughout the spreadsheet??
I would like to use the same formula throughout the spreadsheet, although the
cell numbers and values will be different. For example =b1-SUM(c1:f1). How do I format it so this calculation takes place for each row of cells but with their respective cell numbers and values? |
#2
|
|||
|
|||
Hi
i'm assuming that you've got the formula say in A1 and you want it in A2, A3 ..... to do this, click on the cell with the formula move your mouse over the bottom right hand corner of the cell and you'll see a little + double click on the + this should copy the formula down as far as there is data in cell B1 - if the double click doesn't work or you want to go down more lines, drag the little + downwards Hope this helps Cheers JulieD "whiteteeth" wrote in message ... I would like to use the same formula throughout the spreadsheet, although the cell numbers and values will be different. For example =b1-SUM(c1:f1). How do I format it so this calculation takes place for each row of cells but with their respective cell numbers and values? |
#3
|
|||
|
|||
Just copy it and paste it or use the mouse to frag it using the fillhandle
Regards, Peo Sjoblom "whiteteeth" wrote in message ... I would like to use the same formula throughout the spreadsheet, although the cell numbers and values will be different. For example =b1-SUM(c1:f1). How do I format it so this calculation takes place for each row of cells but with their respective cell numbers and values? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
I want to update the formula in a spreadsheet from 04 to 05. Is . | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |