Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've searched the properties tab in straight, pivot and table box and couldn't find an option to disable column re-sizing. I see only the following options -
- Allow Drag and Drop
- Allow Move/Size
Is it even possible to disable resizing of a column ? I want to keep the width of each column pretty much static.
Thanks.
I got it ! It's in Sheet Properties > Security > Move Size/Sheet Objects. This option must be unselected.
try layout- near move-size there should be "size to data"
and to make colums alway the same size- I sometimes just make the header size a bit bigger by the lengh of it's name.
for example instel of
Customer-Sale-Q
Customer Name -Sales per customer-Quantity per Customer and so on..
"Size to data" is already selected. It still is a problem. Tried unselecting - same thing. Also, I was looking at the Data Visualization example on the "Getting Started" page of the client. In the tables sheet, this is a good example where everything is locked down (column resizing, disallow move, etc) but I don't see where you actually set that option. This is actually what I need.
I got it ! It's in Sheet Properties > Security > Move Size/Sheet Objects. This option must be unselected.
Thanks Anthony, that helped me.
The interesting thing is that setting the "Allow Move/Size", at an individual object-level in the Layout tab of the Chart Properties dialogbox, seems to not have the same effect. We apparently have control over this behavior for objects at only the sheet level.
D.Will, ATP Engineering