Stopping: Cell Editing hides cell above

  • Thread starter Thread starter Henry Bruce
  • Start date Start date
H

Henry Bruce

When editing a cell in excel to enter a formula for
example, how do you stop it blanking the cell above? this
is very annoying - for example it is now impossible to
select the cell above to include in the formula with the
mouse because it is hidden...
any ideas?
thanks in advance,
henry.
 
If you turn off In-cell Editing (Tools, Options, Edit directly in cells) you
will not have this problem.

Since I prefer in-cell editing, in those occasional cases where the formula
blocks me from clicking a cell, I click a nearby one that is visible and
then use the arrow keys to select the one I really want.
 
You must log in or register to reply here.

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

Excel How to add numbers in same cell? 2
Copy and Paste in Excel, copies cell and formula, but shows same v 3
Count max consecutive cells 2
Looking uprange for next nonblank cell 4
Copy paste data from a column to a row 0
Fill in Blanks with immediately above cell value 8
Data in cell disappears, reappears by scrolling mouse over cell 3
How to synchronize all cell values? 1

Back
Top