Inconsistent Cell Functions

T

tkmono

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.
 
M

Marcelo

it looks like your are editing the cell

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"tkmono" escreveu:
 
T

tkmono

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top