PC Review


Reply
Thread Tools Rate Thread

auto fill-in formula

 
 
tony wong
Guest
Posts: n/a
 
      25th Oct 2006
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


 
Reply With Quote
 
 
 
 
Tom Ogilvy
Guest
Posts: n/a
 
      25th Oct 2006
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Auto formula fill Nick Hodge Microsoft Excel Misc 1 19th Dec 2006 06:39 PM
Auto fill of formula =?Utf-8?B?a3Ny?= Microsoft Excel Worksheet Functions 7 6th Jun 2006 05:46 PM
Formula auto-fill help!! daveycmc Microsoft Excel Worksheet Functions 1 11th Apr 2006 05:31 PM
auto formula fill =?Utf-8?B?Q29ubmllIE1hcnRpbg==?= Microsoft Excel Misc 1 22nd Mar 2006 06:11 PM
auto fill formula on new rows RompStar Microsoft Excel Discussion 4 6th May 2005 04:06 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:02 PM.