PC Review


Reply
Thread Tools Rate Thread

Characters per cell

 
 
HLanders
Guest
Posts: n/a
 
      26th Aug 2007
Does excel limit the amount of characters per cell that it will wrap? I
have been editing a spreadsheet that my boss has been using for doing a
quarterly report. She uses the cells for both spreadsheet and word
processing purposes because she has access to all sheets within the same
workbook. This quarter there are two cell that will only wrap part of the
way down and beyond that the cell content does not print out.

Thanks,
Anita


 
Reply With Quote
 
 
 
 
Ragdyer
Guest
Posts: n/a
 
      26th Aug 2007
If you enter forced line-breaks (<Alt> <Enter>) in appropriate places,
sporadically throughout the data, you will be able to exceed the published
limit of 1024 characters per cell.

I've printed some test data in excess of 5,000 characters.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"HLanders" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Does excel limit the amount of characters per cell that it will wrap? I
> have been editing a spreadsheet that my boss has been using for doing a
> quarterly report. She uses the cells for both spreadsheet and word
> processing purposes because she has access to all sheets within the same
> workbook. This quarter there are two cell that will only wrap part of the
> way down and beyond that the cell content does not print out.
>
> Thanks,
> Anita
>
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert 5 characters in a cell to 6 characters by adding a zero Helenf Microsoft Excel Misc 8 18th May 2009 04:43 PM
convert 5 characters in a cell to 6 characters by adding a zero Helenf Microsoft Excel Misc 0 18th May 2009 03:08 PM
Change color of characters in a cell based of a cell reference kimbobo Microsoft Excel Discussion 2 22nd Mar 2008 01:57 AM
Change color of characters in a cell based of a cell reference kimbobo Microsoft Excel Programming 2 22nd Mar 2008 01:05 AM
Macro for: If cell has 4 characters, make cell red Sandeman Microsoft Excel Programming 2 23rd Mar 2006 08:27 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:55 PM.