Editing in cells: text is obscuring adjacent cells

K

Ken_Hosking

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When I am using the editing in cells function, the text box which appears if the formula being edited is lengthy obscures adjacent cells to the left of the cell being edited. If these cells are included in the formula it is detrimental to have them obscured. Is there a way of moving the text box to allow the contents of adjacent cells to be seen without losing the text box?
 
C

CyberTaz

No, cells in the worksheet can't be moved around willy-nilly - that's
exactly why the Formula Bar exists. If you don't have it active go to the
View menu & turn it on. It's editing field not only isolates the cell
content from that of adjacent cells but also provides complete exposure of
everything contained in the cell & doen't obstruct the view of the sheet.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

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

De-Selecting in Excel 3
enter same text in multiple cells 2
Formatting cells 2
Test if Cell Contents is Formula 3
Automatically inserting text into cells which already contain text 3
Cells Formatted as Text 2
Merge cells option Greyed out 1
Split 2 words in one cell to two cells 5

Top