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

Cell with same number of characters 2
date/time 1
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Autocopy the first cell with more than 30 characters to a different sheet? 1
Unicode in Excel 2016 0
Excel Typed text appears in wrong cell 0
Excel 2007 Character Display 2

Top