| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy formula
ToolsOptionsCalculation.
Turn on "automatic" mode. Gord Dibben MS Excel MVP On Tue, 25 Apr 2006 13:45:02 -0700, fofo wrote: I was trying to copy-paste a simple formula to calculate the rest of the cells in a column, the problem is that when I try to paste the formula it pastes the values from the original cell. even though in that original formula the values are not absolute, there are no $ sign what so ever! I tried typing in the function manually in the remaining cells one by one and in that case it works but it will take a very long time for me to finish my work. So can any one please tell me why copying the formula or auto fill is not working properly and acting as if the values are absolute even though its not. Thank you in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Threaded Mode
