Most valuable professional
  • Excel Book Excerpt

Excel Why does Excel Insert Cell Addresses When I Edit In a RefEdit Box?

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Why does Excel Insert Cell Addresses When I Edit In a RefEdit Box?

Problem: There are a few maddening dialog boxes in Excel. Say that you define a name and later need to edit that name. Click somewhere in the RefEdit box. When you press the left or right arrow key to move to another part of the cell, Excel starts inserting cell references.

Here is an example:

LE10000126.jpg 

Figure 153 You meant to click inside the parenthesis, but you missed.

When you press the right arrow key to move the flashing insertion point after the address, Excel starts inserting cell references. The only action between the figure above and the one below is pressing the right arrow.

LE10000127.jpg 

Figure 154 Excel inserts cell references as you arrow through.

This is maddening! The solution is very simple, though. Before you touch the arrow keys in a RefEdit box, press F2. You will see the status indicator in the lower left corner of Excel change from Enter or Point to Edit. Once you are in Edit mode, you can use arrow keys.

LE10000128.jpg 

Figure 155 Press F2 to change Point to Edit. Problem solved.

 

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: