Column widths

G

gary

To adjust the width of the columns, I first select the
columns then use FORMAT/COLUMN/AUTOFIT SELECTION. I then
do FILE/SAVE and FILE/CLOSE.

Then, when I do FILE/OPEN, the column-widths are the same
as they were before I used AUTOFIT.

Why aren't the column-widths being saved?
 
A

Anya

If you're opening the "csv" file from Excel the width will
not get saved, since it's not an Excel file...
 
D

Dave Peterson

Are you using xl97?

There have been lots of posts complaining that sometimes xl97 won't keep the
columnwidths between closing and reopening.

One suggestion is to make sure that you're running xl97SR2.

But that doesn't always work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

column widths 3
Macro's 1
macro / autofit 5
format macro 5
column widths keep changing in shared file 1
Locking column widths 2
varying column widths 4
Pivot Table Formats not maintained? 2

Top