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?
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:
@ntudev One way of doing this with the help of the Table tool and the render tool
ok so how do i make each column in a complete box, like the below?
@ntudev Select the fields in the table tool and select the Border option to both
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?
@ntudev can you change the below setting and try again
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:
