A member of a discussion list asked a question earlier today and I answered it … thought you’d like to see the question and the answer!
In summary, he wants to limit column A to a width of 8 characters and column B to 25 characters in width. How to do that?
Data Validation is probably what you want S. In Excel 2007 you can do the following
- Select the entire column A
- Data … Data Tools … Data Validation: click on the down arrow
- Select Data Validation
- Allow … Text Length
- Data … less than or equal to
- Maximum … 8
- OK
Now try to enter any combination of characters greater than 8 characters in length …
Repeat for column B with the maximum set to 25
Duncan Williamson
Excel with Excel Master 