| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy formula
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula
Look under toolsoptionscalculation, make sure it is set to automatic
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "fofo" wrote in message ... 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 |
|
#3
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula
Thank you so much. the problem is solved now :-)
"Peo Sjoblom" wrote: Look under toolsoptionscalculation, make sure it is set to automatic -- Regards, Peo Sjoblom http://nwexcelsolutions.com "fofo" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula
Thks for your help
-- Thank You From.02Nanny "Gord Dibben" wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy formula
Thanks for the post. This also solved the problem for me.
"Peo Sjoblom" wrote: Look under toolsoptionscalculation, make sure it is set to automatic -- Regards, Peo Sjoblom http://nwexcelsolutions.com "fofo" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
