ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format, Column, Auto-fit (https://www.excelbanter.com/excel-discussion-misc-queries/137636-format-column-auto-fit.html)

wnfisba

Format, Column, Auto-fit
 
I have a spreadsheet that I have previously saved and cannot seem to
auto-format a column and I don't know why.

Can someone help me here???

Thanks in advance for your help.

wnfisba

Mike

Format, Column, Auto-fit
 
Perhaps the worksheet is protected, try unprotecting it.

Mike

"wnfisba" wrote:

I have a spreadsheet that I have previously saved and cannot seem to
auto-format a column and I don't know why.

Can someone help me here???

Thanks in advance for your help.

wnfisba


wnfisba

Format, Column, Auto-fit
 
It is NOT protected.

Any other ideas....

"Mike" wrote:

Perhaps the worksheet is protected, try unprotecting it.

Mike

"wnfisba" wrote:

I have a spreadsheet that I have previously saved and cannot seem to
auto-format a column and I don't know why.

Can someone help me here???

Thanks in advance for your help.

wnfisba


Gord Dibben

Format, Column, Auto-fit
 
Do you have any merged cells across a row?

i.e. A1 and B1 are merged.

That column will not autofit.


Gord Dibben MS Excel MVP

On Tue, 3 Apr 2007 06:18:03 -0700, wnfisba
wrote:

It is NOT protected.

Any other ideas....

"Mike" wrote:

Perhaps the worksheet is protected, try unprotecting it.

Mike

"wnfisba" wrote:

I have a spreadsheet that I have previously saved and cannot seem to
auto-format a column and I don't know why.

Can someone help me here???

Thanks in advance for your help.

wnfisba




All times are GMT +1. The time now is 12:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com