LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default stop the column widths from changing

I am importing csv files into sheet4.
All these csv files contain the same number of lines and same fields in
each line.
The only difference is the data in each csv file.
Everytime the csv import script does the import in sheet4 - some of the
column widths change.
Looks like this is happening because the csv data in some fields is
wider.

Is it possible to "lock" the column widths in this sheet so that the
csv file import does not arbitrarily change them?

It is difficult to keep changing the view-zoom to keep up with the ever
changing column widths.


---
Message posted from http://www.ExcelForum.com/

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop Excel 2007 from Changing Column Widths Jeff Excel Discussion (Misc queries) 4 June 19th 07 03:16 PM
Column Widths Changing - For No Reason??? Paige Excel Discussion (Misc queries) 1 April 26th 07 12:34 AM
How do stop Excel changing column widths when doing pivots? CB Excel Discussion (Misc queries) 1 June 27th 06 08:15 PM
Changing column widths in excel Becky Robinson Paine Excel Discussion (Misc queries) 2 June 18th 06 12:55 PM
Changing column widths in certain cells arreferee Excel Discussion (Misc queries) 5 February 1st 05 05:12 PM


All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"