ou81aswell
Board Regular
- Joined
- Oct 6, 2009
- Messages
- 50
I'm running Excel 2010 x64 on Win 7 x64
For some reason, when I double click on the vertical grid line that separates the cells in the header row which contains the column letters, the column widths won't auto-size. I have to size them manually. This is happening with an xlsx file so there aren't any macros getting in the way.
This is only happening with a particular workbook, I looked in Excel options to see if there was a setting for this but I couldn't find one.
This is only happening on the first 8 columns (A - H). Double-clicking on columns J and beyond auto-sizes the column widths as I would expect.
Why would it refuse to auto-size these columns' widths? The columns in question contain text info like names, addresses, emails and phone numbers.
Thanks in advance for any tips or hints!
For some reason, when I double click on the vertical grid line that separates the cells in the header row which contains the column letters, the column widths won't auto-size. I have to size them manually. This is happening with an xlsx file so there aren't any macros getting in the way.
This is only happening with a particular workbook, I looked in Excel options to see if there was a setting for this but I couldn't find one.
This is only happening on the first 8 columns (A - H). Double-clicking on columns J and beyond auto-sizes the column widths as I would expect.
Why would it refuse to auto-size these columns' widths? The columns in question contain text info like names, addresses, emails and phone numbers.
Thanks in advance for any tips or hints!
