I have a worksheet with a number of headers that cover several columns.
If I use the standard auto fit command then result includes data in all rows.I could go back and restore columns with headers but even then I would be guessing at the correct width .
Is there any way to base the Autofit on a range rather than an entire column
Thanks