![]() |
auto fill-in formula
row1(Cell C) =row1 (cell A + cell B)
i check that there is no formula at row 2, 3... but when i input data in Cell A and Cell B The Cell C has been filled in a formula i do not know what i have done in the spreadsheet but i am sure there is no formula. grateful if you could clarify for me. Thanks. tony |
auto fill-in formula
in the menu,
in tools=options, edit tab, do you have "Extend List Formats and Formulas" checked? If so, try unchecking it. -- Regards, Tom Ogilvy "tony wong" wrote in message ... row1(Cell C) =row1 (cell A + cell B) i check that there is no formula at row 2, 3... but when i input data in Cell A and Cell B The Cell C has been filled in a formula i do not know what i have done in the spreadsheet but i am sure there is no formula. grateful if you could clarify for me. Thanks. tony |
auto fill-in formula
Thanks a lot.
"Tom Ogilvy" bl... in the menu, in tools=options, edit tab, do you have "Extend List Formats and Formulas" checked? If so, try unchecking it. -- Regards, Tom Ogilvy "tony wong" wrote in message ... row1(Cell C) =row1 (cell A + cell B) i check that there is no formula at row 2, 3... but when i input data in Cell A and Cell B The Cell C has been filled in a formula i do not know what i have done in the spreadsheet but i am sure there is no formula. grateful if you could clarify for me. Thanks. tony |
All times are GMT +1. The time now is 08:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com