text auto type from cell above

[tag]

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

 

[Bernie Deitrick]

tag,

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

HTH,
Bernie
MS Excel MVP

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?

 

[David McRitchie]

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.