Need to set character limit in cells of a worksheet.
 

I'm creating a work-performance review form. I would like to set a character
limit on certain cells that are to be filled in by the employees, but I don't
know how to do this. Any help would be very much appreciated.

Thanks in advance!
Justine N.

Need to set character limit in cells of a worksheet.
 

Check out data validation.

Menu DataValidation
Allow: text length

--
Biff
Microsoft Excel MVP


"Justine" wrote in message
...
I'm creating a work-performance review form. I would like to set a
character
limit on certain cells that are to be filled in by the employees, but I
don't
know how to do this. Any help would be very much appreciated.

Thanks in advance!
Justine N.

Need to set character limit in cells of a worksheet.
 

You are a life-saver! That worked perfectly. Thank you so much!!!

"T. Valko" wrote:

Check out data validation.

Menu DataValidation
Allow: text length

--
Biff
Microsoft Excel MVP


"Justine" wrote in message
...
I'm creating a work-performance review form. I would like to set a
character
limit on certain cells that are to be filled in by the employees, but I
don't
know how to do this. Any help would be very much appreciated.

Thanks in advance!
Justine N.

Need to set character limit in cells of a worksheet.
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Justine" wrote in message
...
You are a life-saver! That worked perfectly. Thank you so much!!!

"T. Valko" wrote:

Check out data validation.

Menu DataValidation
Allow: text length

--
Biff
Microsoft Excel MVP


"Justine" wrote in message
...
I'm creating a work-performance review form. I would like to set a
character
limit on certain cells that are to be filled in by the employees, but I
don't
know how to do this. Any help would be very much appreciated.

Thanks in advance!
Justine N.