Entry length

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

JW
Wed Oct 17 05:22:16 PDT 2007

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

champy wrote:
> 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

Ron
Wed Oct 17 05:18:55 PDT 2007

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)

"champy" <roland.gaillard4@wanadoo.fr> wrote in message
news:AB55B60F-F223-4A40-B84D-F57EDA98FEB6@microsoft.com...
>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