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. |
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 |
All times are GMT +1. The time now is 09:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com