Fixed cell width

N

Need Help

Is there a way to set maximum 30 characters in a cell?
E.g., when 30 characters were typed, it will not allow
more text be typed in that cell.
 
H

Harald Staff

Hi

No. Absolutely nothing happens in Excel when you write things into cells. All such things
must take place after each entry is totally completed.
 
C

Chip Pearson

You can use Data Validation to do this. Select the cell, and choose
Validation from the Data menu. In the Allow list, choose Text Length, and
enter the minimum and maximum allowable lengths.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer data between two tables 3
Changing language for spell check not working? 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Small Thick "Bar" Below Last Typed Line ? 0
Crating User Form to Add Names 1
How to disable Alt+s in Outlook 365 0
Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Table Preferred width is changed when pasting 1

Top