Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
expanding a formula
I have a spread sheet that I enter new data at the bottom of the sheet. I
have a unique formula for each column that ends at the last entry. How do I entend the formulas for each column down to the new information without having to do it one column at a time. JAR |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
expanding a formula
Assuming the columns are next to each other, simply a single row of formulas
across the columns you want to expand. Move cursor to bottom right corner, and when you see the + symbol, double click. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "jrsrdcr" wrote: I have a spread sheet that I enter new data at the bottom of the sheet. I have a unique formula for each column that ends at the last entry. How do I entend the formulas for each column down to the new information without having to do it one column at a time. JAR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expanding on a formula | Excel Worksheet Functions | |||
Expanding Formula Bar | Excel Discussion (Misc queries) | |||
Need an Expanding array formula | Excel Worksheet Functions | |||
Help With Expanding A Formula | Excel Worksheet Functions | |||
intersection formula? need help expanding on it | Excel Worksheet Functions |