text auto type from cell above

How do you stop excel from trying to automatically enter text from the cell above it? I know you can simply "break the chain" by insering a row, but I don't want to do that. Is the trick in the formatting of the current cell?

tag,

The trick is using Tools | Options... Edit Tab, unchecking "Enable
Autocomplete for Cell values"

HTH,
Bernie
MS Excel MVP

"tag" wrote in message
...
How do you stop excel from trying to automatically enter text from the
cell above it? I know you can simply "break the chain" by insering a row,
but I don't want to do that. Is the trick in the formatting of the current
cell?

There seem to be a lot of complaints in this area lately has
Excel 2003 changed the way that Extend Formats and
Formulas works. I have it "on" in my Excel 2000 and I don't
have a problem with it interfering -- a lot of the time it does
nothing. Maybe they improved the nothing or made it default.
Actually for formatting I rely on formatting columns ahead of
time and for formulas for many sheets I provide macros to
handle that.

FWIW, Many of the complaints seem to involve formatting.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bernie Deitrick" deitbe @ consumer dot org wrote in message ...
tag,

The trick is using Tools | Options... Edit Tab, unchecking "Enable
Autocomplete for Cell values"

HTH,
Bernie
MS Excel MVP

"tag" wrote in message
...
How do you stop excel from trying to automatically enter text from the
cell above it? I know you can simply "break the chain" by insering a row,
but I don't want to do that. Is the trick in the formatting of the current
cell?