Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rampam1
 
Posts: n/a
Default Is there a limit to number of words in a cell in excel?

I can not print a cell if it has too many words? any suggestions?

  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

rampan

Excel Help on "limits" or "specifications" reveals that Excel will allow
32,767 characters to be entered in a cell.

However, it goes on to state that "only 1024 characters will be visible or can
be printed"

To work around this limitation, stick a few ALT + ENTERs in at appropriate
spots.

The ALT + ENTER forces a line-feed and expands the 1024 limit.

How far is not really known. Just experiment.

.........From Dave Peterson..........

I put this formula in A1:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"

And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.

.........End Dave P.................

Failing that, use a Text Box to store the text.

Gord Dibben Excel MVP

On Sun, 23 Jan 2005 09:41:04 -0800, "rampam1"
wrote:

I can not print a cell if it has too many words? any suggestions?


Reply
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I limit the number of times an Excel workbook can be opene. Chris Excel Discussion (Misc queries) 8 January 19th 05 05:02 PM
how do i set up excel to copy from one cell to a given number of . ronmjo Excel Discussion (Misc queries) 3 January 18th 05 09:49 PM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 09:21 AM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 09:58 PM


All times are GMT +1. The time now is 07:32 PM.

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

About Us

"It's about Microsoft Excel"