Entry length

  • Thread starter Thread starter champy
  • Start date Start date
C

champy

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
 
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)
 
Can you simply wrap the text?
Right click on the cells and select Format Cells. On the Alignment
tab, check Wrap Text.
 
Back
Top