MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Shrinking Columns


Posted by Bob Williams on September 14, 2001 11:26 AM

spreadsheet is saved, then when reopened, the columns have shrunk in size...widthwise This can often be fixed by closing the whole program and then reopening the program and then the file. That is not always convenient, however -- and if the files are shared, sometimes other users don't pick up on what happened and save the file with the too small columns, in which case each column has to be fixed manually.

Any Ideas?

Thanks in Advance


Posted by JAF on September 14, 2001 12:54 PM

Bob

What format are you saving the file in?

If it's .csv then this will open with fixed width columns. If it's .xls then I've no idea!!