Inside Microsoft Excel

Edit a cell’s text as soon as you switch worksheets

Inside Microsoft Excel

by Kara Hiltz

I can understand this frustration. Excel remembers which cell was active when you were last working in a worksheet, and so when you return, the same cell is active. However, the cell isn’t ready for immediate editing. You need to either type all new data in the cell, or double-click on it to activate the insertion point in the cell’s text. A third alternative is to press the key, which places[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)