Results 1 to 5 of 5

Fix the column width

This is a discussion on Fix the column width within the Excel Questions forums, part of the Question Forums category; Hi all, I am trying to fix the width of a column everytime I open it but I can't. After ...

  1. #1
    nc
    nc is offline
    New Member
    Join Date
    May 2002
    Posts
    23

    Default

    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

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    N.E. Ohio
    Posts
    236

    Default

    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
    Oh, you hate your job? Why didn't you say so? There's a support group
    for that. It's called EVERYBODY, and they meet at the bar. - Drew Carey

  3. #3
    nc
    nc is offline
    New Member
    Join Date
    May 2002
    Posts
    23

    Default

    Ok, I got it. Thanks!

    Regards,
    nc

  4. #4
    New Member
    Join Date
    Feb 2012
    Posts
    12

    Default Re: Fix the column width

    Quote Originally Posted by zzydhf View Post
    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

  5. #5
    New Member
    Join Date
    Jun 2013
    Posts
    1

    Default Re: Fix the column width

    Is there anyway to change the default on this checkbox?

    Lynnette



    Quote Originally Posted by zzydhf View Post
    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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com