Column Width

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have worksheet that import external data by running a
query based on another worksheet.

The problem I have is when the external data comes in from
running the query, the column change with. I want column
width to stay the same regardless of the data coming in.

Also, when you first run the query it allows you to give
the range where the data will be placed i.e. $A$1:$J$4

How do change it to for example: $A$1:$J$10

Thanks.
 
After the last step of the Import wizard, the Import Data dialog box is
displayed.
Click the Properties button.
Remove the check mark from 'Adjust column width'
Click OK

Normally, just the starting cell for the data is selected, e.g. =$A$1
 
Back
Top