Entry length

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

champy - 17 Oct 2007 12:48 GMT

I give support to blind people who want to use Excel, and publish documents.

When they enter data wider than the column width, of course the blind people
cannot see that the entry is truncated by the entry in the cell immediately
on the right.

Is there any function or trick to indicate that the entry is wider than the
column, or to indicate the length of the entry in the same unit as the
column width, or other solution?

Thanks
Roland

Reply to this Message

Ron Coderre - 17 Oct 2007 13:18 GMT

If using Windows Accessibility Options plays a "beep" on Data Validation
errors....
Try something like this:

1)Set the cell fonts to a Fixed Font (eg Courier New)
2)Type however many characters you want to fit in a column
3)Use Automatic Column Width
3)Set Data Validation to only allow that number of characters

Example: Using Courier New, 10 pt. in a 10 character column
1)Type 10 characters in a cell....eg: AbCdEfGhIJ
2)From the Excel Main Menu: <format><column><autofit selection>
3)Select the entire column
4)From the Excel Main Menu: <data><validation>
Allow: Text Length: Less_than_or_equal_to: 10
5)Repeat for all other columns to be impacted

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

>I give support to blind people who want to use Excel, and publish
>documents.
[quoted text clipped - 9 lines]
> Thanks
> Roland

Reply to this Message

JW - 17 Oct 2007 13:22 GMT

Can you simply wrap the text?
Right click on the cells and select Format Cells. On the Alignment
tab, check Wrap Text.

> I give support to blind people who want to use Excel, and publish documents.
>
[quoted text clipped - 8 lines]
> Thanks
> Roland

Reply to this Message

Rate this thread: