Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Inconsistent Cell Functions

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date formatting inconsistent Chuck Excel Worksheet Functions 2 October 1st 07 09:26 PM
Inconsistent Sorting Saxman Excel Discussion (Misc queries) 17 October 23rd 06 11:17 AM
Inconsistent results with =LOOKUP? watkincm Excel Worksheet Functions 2 May 31st 06 08:21 PM
3-d referencing inconsistent duncan79 Excel Discussion (Misc queries) 5 January 25th 06 05:39 PM
Inconsistent 'auto-entry' Terry Pinnell Excel Discussion (Misc queries) 2 October 31st 05 04:16 PM


All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"