edit final output to excel

[ntudev]

I'm trying to make my final output to come out like the attached excel sheet. I can seem to make it change header color to yellow. Can someone show me?

[DataNath]

Hey @ntudev, in the table settings, you just need to go to:

Default Table Settings > Header > Background Color

That'll give you the following:

When dealing with reporting snippets, you then need to Render the output, rather than using the standard Output Data tool:

[binuacs]

@ntudev One way of doing this with the help of the Table tool and the render tool

[ntudev]

ok so how do i make each column in a complete box, like the below?

[binuacs]

@ntudev Select the fields in the table tool and select the Border option to both

[ntudev]

thank you for these they all work great, only problem i have about 20 headers and Alteryx is not picking up everything. Sometimes a header like 'School' would show up as 'SC, how do i make it stop doing that?

[binuacs]

@ntudev can you change the below setting and try again

[DataNath]

Hey @ntudev, I'd imagine with so many headers, the issue is probably that some headers are being truncated because of a restricted paper size when outputting to Excel. What do you have your paper size setting as here in the Render tool? You may need to make it larger - I tend to use custom and just set height/widths that will comfortably fit everything: