Fix the column width

nc

New Member
Joined
May 13, 2002
Messages
23
Hi all,
I am trying to fix the width of a column everytime I open it but I can't. After I have fixed the column width and saved it before I close the file, when i reopen it, the column width will expand. The data source of that column is a real time query. I tried to lock the cell but when i locked it, I can't refresh the data from the query as it is locked. So, is there any way for me to achieve that?
Any help?

regards,
nc
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
if you show the "external data" toolbar there is a button for "data range properties" one of the check boxes is for "adjust cloumn width".

turn it off.

ps your active cell must be in the query range for this to work
 
Upvote 0
if you show the "external data" toolbar there is a button for "data range properties" one of the check boxes is for "adjust cloumn width".

turn it off.

ps your active cell must be in the query range for this to work


hi,

was trying to do this, but i believe the method within 2003?
where can i find it on 2007?

thanks
 
Upvote 0
Is there anyway to change the default on this checkbox?

Lynnette



if you show the "external data" toolbar there is a button for "data range properties" one of the check boxes is for "adjust cloumn width".

turn it off.

ps your active cell must be in the query range for this to work
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,122
Members
448,550
Latest member
CAT RG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top