Text Doesn't Overflow into Adjacent Blank Cell in Excel

Last reviewed: November 2, 1994
Article ID: Q72841

SUMMARY

If you enter text into a cell and the text does not properly overflow into the adjacent cell (which is blank), check to see whether or not the worksheet is in formula view.

Microsoft Excel allows you to view either values or formulas in a worksheet. You can toggle this view by choosing Display from the Options menu and selecting the Formulas option. Or, you can use the keyboard shortcut by pressing CTRL+` (left single quotation mark). While in formula view, any text entered into a cell will not extend into an adjacent cell, regardless of the length of the text.

REFERENCES

"Microsoft Excel Function Reference." Version 3.0, pages 125, 214-215.

KBCategory: kbother
KBSubcategory:
Additional reference words: noupd

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.