Don writes: I am using Toad for Oracle version 11.5.0.56 and have the Data Grids Visual option for column sizing set to 'size to data', checked 'allow columns narrower than header width (min column size set to 20) and also checked 'allow column wider than grid width' (max column size set to 5000). Problem is I always have to right click the grid and select size columns to size to data - it never seems to remember the option setting.Can you check in your Toad options if you have Schema Browser-DataTab-Save Layouts checked? I do and I occasionally have the same issue,although for me it's by design.With that option checked, I believe Toad will override the Size to Dataoption. I'm not sure if you will need to remove existing saved layouts ornot to see if this will be the fix for you though. Perhaps John knows.:)Let us know if unchecking that option helps!Rich - TeamTDisclaimer: Sometimes it just doesn't pay to be a referee.

• Column Width Definition

Adjust Row Height and Column Width in Word Tables: OverviewYou can adjust row height and column width in Word tables using the mouse. To do this, place your mouse pointer over the border of the column or row to adjust. When you are in the correct place, the mouse pointer turns into a double-line with an intersecting arrow.

Column Width Definition

At that point, you then click and drag to adjust the column width or row height.In addition to manual adjustments you make with your mouse, you can also use the commands in the “Cell Size” button group in the “Layout” tab of the “Table Tools” contextual tab in the Ribbon to adjust row height and column width in Word tables. To do this, select the cells whose width or height you wish to adjust. Then use the “Height:” and “Width:” spinner boxes to set the height and the width of the selected cells.You can also use the “AutoFit” button to apply automatic adjustments to selected cells. To do this, select the cells that you want to automatically adjust.

Then click the “Layout” tab of the “Table Tools” contextual tab in the Ribbon. Then click the “AutoFit” button in the “Cell Size” button group. From the drop-down menu, select the method of adjustment to apply. You can select “AutoFit Contents” to resize the cells to fit their content. You can select “AutoFit Window” to stretch the table across the page to fit the window.

Finally, you can select “Fixed Column Width” to set the widths of the columns by hand using the techniques you just learned.Adjust Row Height and Column Width in Word Tables- Tutorial: A picture of a table in Word being adjusted using the “AutoFit” button in the “Layout” tab of the “Table Tools” contextual tab in the Ribbon of Word 2016.Another way to adjust row height and column width in Word tables is to equally distribute the spacing allocated to a selection of rows or columns. For example, if you had three adjacent columns of unequal sizes in a table, you could select them and then resize them so that each one was the same width over the selected area. To do this, select the columns or rows to evenly distribute. Then click either the “Distribute Rows” or the “Distribute Columns” button in the “Cell Size” button group on the “Layout” tab of the “Table Tools” contextual tab in the Ribbon. Doing this then distributes the selected columns or rows equally over the selected area.

I'm using SQL.Plus to spool a table to a csv file, but the default setting is to extract using fixed width. Each column fills the length with extra spaces which is not contained in DB tables.