ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   auto fill-in formula (https://www.excelbanter.com/excel-programming/375898-auto-fill-formula.html)

tony wong

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



Tom Ogilvy

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




tony wong

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