This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm not much an expert with this yet but based on my experience, I used to adjust the column width in the layout tool under "Layout width" or you may also try adjusting the width under basic table tool.
There's a problem with render - which is every sheet needs to be the same dimensions when it renders to excel. Right now your first sheet is fit to whatever dimensions you have set in your render tool. If you make this larger the sheet in your .png will look nicer but the second sheet (presumably with fewer columns) will look awful. This is a render problem. Render is basically saying "create visual formatted output" and when you use multiple sections in a layout tool (ie to get the excel sheets) and then reset the page size in the render tool - render sees all of the sheets as "the same output style" even though one may be 50 columns and the other maybe be 10.
Hi @sgaryali, as mentioned by @apathetichell, the Render tool by design applies the same column width across different excel tabs depending on the default paper size setting we use. Folks often use the Custom Width paper size option as a workaround, but that too can lead to an undesirable output depending on the number of columns we have in each tab - in short, there is no out of the box solution to give us an excel file with well-spaced out columns.