Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes. but not intentionally. If you hit enter, it goes to the next cell. If
you use the arrow, it assumed editing. Why does this happen inconsistently and how can we stop it? "Marcelo" wrote: it looks like your are editing the cell hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "tkmono" escreveu: I have a template that we use for financial reports. When we input data we sometimes hit enter and sometimes use the arrow keys. Although I am not aware of any template changes, all of a sudden when we hit the down arrow, EXCEL adds that line to the formula. Example. CELL B4 input 143 then hit the down arrow and B4 will read 143+B5 This is not true on every cell. We have other Excel Documents that the down arrow juts moves to the next cell. This is new and we are wondering how to make it consistent. When we hit down, it should just go to the next cell. Please advise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date formatting inconsistent | Excel Worksheet Functions | |||
Inconsistent Sorting | Excel Discussion (Misc queries) | |||
Inconsistent results with =LOOKUP? | Excel Worksheet Functions | |||
3-d referencing inconsistent | Excel Discussion (Misc queries) | |||
Inconsistent 'auto-entry' | Excel Discussion (Misc queries) |