ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto Adjust the Width of a Column (https://www.excelbanter.com/excel-programming/332417-auto-adjust-width-column.html)

reddog9069[_4_]

Auto Adjust the Width of a Column
 

How can I update the width of a column after the data has been entered
to make it fit to the largest piece of data, so I do not get a bunch of
####'s?

I have to mention that I need this so each time I add a new column it
also can be auto fit.

I am using a template and when in the template I have the first column
set to autofit in the template, when I add a worksheet from this
template the column auto fit does not seem to work.

Thanks


--
reddog9069
------------------------------------------------------------------------
reddog9069's Profile: http://www.excelforum.com/member.php...o&userid=24458
View this thread: http://www.excelforum.com/showthread...hreadid=380886


reddog9069[_5_]

Auto Adjust the Width of a Column
 

Wow a lot of people posted at 12:0

--
reddog906
-----------------------------------------------------------------------
reddog9069's Profile: http://www.excelforum.com/member.php...fo&userid=2445
View this thread: http://www.excelforum.com/showthread.php?threadid=38088



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

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