cell is reinserting a formula in even after deleting it. Why
 

When typing into a cell on the left the cell on the right is placing in a
formula, even after deleting this formula it re-appears. This is happening
in a few places on the spreadsheet. It always appears underneath a row of
forumlas, the following row is not effected by this.

Hi Michele

untick
tools / options / edit / extend data range formats and formulas

Cheers
JulieD

"Michele Dickinson" <Michele wrote in
message ...
When typing into a cell on the left the cell on the right is placing in a
formula, even after deleting this formula it re-appears. This is
happening
in a few places on the spreadsheet. It always appears underneath a row of
forumlas, the following row is not effected by this.

Michele,

Use Tools | Options... Edit tab, uncheck "Extend list formats and formulas"

HTH,
Bernie
MS Excel MVP

"Michele Dickinson" <Michele wrote in
message ...
When typing into a cell on the left the cell on the right is placing in a
formula, even after deleting this formula it re-appears. This is
happening
in a few places on the spreadsheet. It always appears underneath a row of
forumlas, the following row is not effected by this.

Thank you for your quick response

"Bernie Deitrick" wrote:

Michele,

Use Tools | Options... Edit tab, uncheck "Extend list formats and formulas"

HTH,
Bernie
MS Excel MVP

"Michele Dickinson" <Michele wrote in
message ...
When typing into a cell on the left the cell on the right is placing in a
formula, even after deleting this formula it re-appears. This is
happening
in a few places on the spreadsheet. It always appears underneath a row of
forumlas, the following row is not effected by this.

Thank you so much, would never have found that in a million years - so easy
when you know how.

Thanks again

"JulieD" wrote:

Hi Michele

untick
tools / options / edit / extend data range formats and formulas

Cheers
JulieD

"Michele Dickinson" <Michele wrote in
message ...
When typing into a cell on the left the cell on the right is placing in a
formula, even after deleting this formula it re-appears. This is
happening
in a few places on the spreadsheet. It always appears underneath a row of
forumlas, the following row is not effected by this.

you're welcome - glad it's solved

"Michele Dickinson" wrote in
message ...
Thank you so much, would never have found that in a million years - so
easy
when you know how.

Thanks again

"JulieD" wrote:

Hi Michele

untick
tools / options / edit / extend data range formats and formulas

Cheers
JulieD

"Michele Dickinson" <Michele wrote
in
message ...
When typing into a cell on the left the cell on the right is placing in
a
formula, even after deleting this formula it re-appears. This is
happening
in a few places on the spreadsheet. It always appears underneath a row
of
forumlas, the following row is not effected by this.