Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit the size of a cell
I work with Excel 2003
How can I limit the width of a cell to - for example - 15 chars ? I mean, anything larger than 15 chars won't be accepted Thanks for help Joël |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit the size of a cell
Under Data, Validation, you can set a maximum allowed text length.
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Joël" wrote: I work with Excel 2003 How can I limit the width of a cell to - for example - 15 chars ? I mean, anything larger than 15 chars won't be accepted Thanks for help Joël |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit the size of a cell
With your cell selected, click on the menu bar Data - Validation
On the settings tab, change the allow drop down to Text Length Change the data drop down to between Enter 0 in minimum and 15 in maximum Set the other tabs input message and error alert as required. "Joël" wrote: I work with Excel 2003 How can I limit the width of a cell to - for example - 15 chars ? I mean, anything larger than 15 chars won't be accepted Thanks for help Joël |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Size Limit In Single Cell | Excel Discussion (Misc queries) | |||
File size limit | Excel Discussion (Misc queries) | |||
Cell size? Or size limit for Text data type? | Excel Discussion (Misc queries) | |||
Formula to limit the size of a number result in a cell? | Excel Discussion (Misc queries) | |||
Is there a limit to the size of a cell containing text in Excel 20 | Setting up and Configuration of Excel |