When I hit 'enter' on a formula, nothing happens.

  • Thread starter Thread starter Jactuary
  • Start date Start date
J

Jactuary

I used to be able to hit 'enter' on a formula and it would move to the cell
that was referenced in the formula. Now is doesn't do anything. 'm
wondering if I mistakenly changed one of the excel settings. Any help would
be most appreciated.
 
Are you thinking of the Name Box (it is the empty TextBox to the left of the
Formula Bar)? If you type in a cell (or range) address in the Name Box and
then hit the enter key, Excel will select that cell (or range) for you.
 

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

Similar Threads

Formula is changing to text when I hit enter 6
value changes after hitting Tab or Enter button 2
Cell changes to a formula after hitting ENTER 4
Forumlas Aren't Auto Recalculating 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Formula doesn't work unless hit enter again 5
change direction when hitting enter key 1
Automatically move to adjacent cells without hitting Enter 7

Back
Top