Autofit

  • Thread starter Thread starter Bob Henson
  • Start date Start date
B

Bob Henson

I can't see any way to set a whole Excel book, or even a whole sheet, so
that all columns have "autofit" applied - is there a way to do it? I'm using
Excel XP/2002.


--
Regards,

Bob

Remove "x" from address to reply by email
 
Hi Bob

1- Select any sheet tab, right click and select "Select all Sheets"
2- Select all the cells the active sheet
3- From the Excel toolbar "Format>Column>Autofit Selection"
4- Select any sheet tab, right click and select "Ungroup Sheets"

--
XL2002
Regards

William

(e-mail address removed)

| I can't see any way to set a whole Excel book, or even a whole sheet, so
| that all columns have "autofit" applied - is there a way to do it? I'm
using
| Excel XP/2002.
|
|
| --
| Regards,
|
| Bob
|
| Remove "x" from address to reply by email
|
|
 
Thanks very much - I'll away and do that now.


--
Regards,

Bob

Remove "x" from address to reply by email
 
Back
Top