Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Column Width
I am using an Excel spreadsheet as a data form for clients to fill out. I am
finding that sometimes clients put in more data than the column width would allow and the column width is being automatically increased to accomodate. The form is protected except for data cells. Is there a way to prevent this from happening other than putting a validation requirement on the cell? Thank you. |
#2
|
|||
|
|||
Column Width
You could Format Cells, Alignment, tick Merge Text - but then your rows would
be twice as high instead of your columns! Alex Mackenzie wrote: I am using an Excel spreadsheet as a data form for clients to fill out. I am finding that sometimes clients put in more data than the column width would allow and the column width is being automatically increased to accomodate. The form is protected except for data cells. Is there a way to prevent this from happening other than putting a validation requirement on the cell? Thank you. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200510/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Is it possible to create one column with two different width? | Excel Worksheet Functions | |||
fixed column width with text string | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |