LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Alt+Enter works in the formula bar, but not in the cell

Hello!

I have read through questions on fitting a lot of text into a cell, and the
answer that would seem to work would be to click on the cell with the text,
put cursor up into the formula bar where the cell's text is displayed, then
press Alt-Enter every 50 characters or so. The text in the cells are all
about 400 characters.

When I use the Alt+Enter, all that happens is that the lines break
appropriately in the formula bar, but the cell still displays only ####.

The Alt key works for all the menus (Edit, Insert, etc.).
The font size is 9pt.
Is there something I'm missing?

Any help would be TREMENDOUSLY appreciated.

Many many, many many, and many more, thanks,

Elessvie
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MATCH FORMULA WORKS, BUT NEED HAVE BLANK CELL WHER I NOW HAVE #N/A Stewcrew Excel Discussion (Misc queries) 2 April 1st 07 02:14 AM
ALT+ENTER no longer works Dale Excel Discussion (Misc queries) 2 March 6th 07 03:39 AM
Formula works but formula shows in cell??? Donald King Excel Worksheet Functions 2 October 30th 06 08:54 PM
formula works when referring to one cell but not to another Nicci New Users to Excel 3 July 7th 06 02:03 PM
How do I enter a SUM(cell:cell) in pocket excel so it works prope. WillyJ1000 Excel Worksheet Functions 2 February 10th 05 12:14 AM


All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"