Debra

I never knew that..phew, that'll save me a few clicks... (learn something
every day),thanks
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Debra Dalgleish" wrote in message
...
Right-click on a cell in the table
Choose Data Range Properties
Remove the check mark from 'Adjust column width'
Click OK

rml wrote:
I have a sheet that connect to an access database. It updates data on my
sheet from a query in access. It works great. My problem is this:
every time I refresh or update the data, the column resizes to a default
or smaller width. How can I freeze a columns width?

Thanks.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html