Looking for a way to get collums to auto fit after output as well as putting colors on tab

[maddoxs]

Is there a way to get the collumns to auto fit so we will not have to format when opening a excel spreadsheet? Also is coloring the bottom sheet tabs possible?

[AlteryxUserFL]

You will not be able to do both of those with Alteryx alone. You will need a VBA Script / Macro that Alteryx can trigger after the data is written to the file. There are a number of post dedicated to running VBA with Alteryx so no need to rehash here, but below is the link to one of the most useful IMO. 

Alteryx Run Command: Executing Excel Macros (VBA) - Alteryx Community 

[Luke_C]

Hi @maddoxs 

You could also leverage an excel template using either blob tools or run commands:

https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Clearing-Data-in-Template-before-Overw...