Locking Column Widths When Iporting

Microsoft Excel 2002 (full product)
February 9, 2010 at 17:05:43
Specs: Windows XP
To lock column width when importing data:
1. Click on the PROPERTIES button on the last IMPORT DATA dialog box.
2. Uncheck the Adjust Column Width box.
3. Finish importing data.

See More: Locking Column Widths When Iporting

Report •

March 5, 2010 at 16:52:59
How is this done in Excel 2007? I am using an invoice template I designed that pulls records from an Access
2007 query. The number of records imported changes each time the template is used. I've managed at last to get the results I want from the import, but the column widths for the data changes each time it imports new data. It is totally screwing up the formatting I want for the worksheet. How can I lock the widths of these columns at what I want, regardless of what data is imported?

Report •
Related Solutions

Ask Question