Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
looking for a formula | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |