Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a 255 character limit in pivot table cells? RH-at-PDCO Excel Worksheet Functions 1 June 18th 07 09:35 PM
Character limit when printing Neil Conduit Excel Discussion (Misc queries) 1 June 1st 06 01:54 PM
Character limit in cell Jan Excel Discussion (Misc queries) 3 April 21st 06 02:40 AM
255 Character Limit Colin Excel Discussion (Misc queries) 2 March 2nd 06 07:58 PM
Character limit in an Excel Row Denise Excel Worksheet Functions 1 October 6th 05 02:33 AM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"