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

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

Rick Rothstein

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

#VALUE error which disappears when I use F2, ENTER 1
value changes after hitting Tab or Enter button 2
Autofill Date in Word 15.33 for Mac 0
Formula is changing to text when I hit enter 6
Forumlas Aren't Auto Recalculating 1
VBA word change keys 0
Cell changes to a formula after hitting ENTER 3
Conditional formula 1

Top