The shortcut to select Default Width is: Alt + H + O + D. By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. Insert and format a table in OneNote to visually organize information. It again overwrites the rules previously defined. And then distribute the columns evenly with a fixed manual width. Get answers to your question from experts in the community, Share a use case, discuss your favorite features, or get input from the community, Resize table columns easily with the new Distribute Columns option. A typical example would be a table with 4 columns: Year/Quarter, Count, Amount, Percentage Cha Distribute all the columns of the table evenly. To select all the columns, press any blank cell. Use the Table tab Select Table to: Insert or delete a row or column. To start off, press Alt+ F11 to trigger VBA editor. Tip: Most of the available table commands are also available by right-clicking any table cell and then clicking the Table command. I know I can switch of auto-resize for my column widths in my matrix. I have a need to assign a list of agents I get from a SQL query evenly to each row of an unrelated data source in a text table. You can also convert a table to an Excel spreadsheet. I am just here to help you out with your excel problems and also learn from you. On the Layout tab, in the Alignment group, click Cell Margins, and then in the Table Options dialog box. We can distribute columns evenly in excel in 2 ways. Click the Layout tab to reveal the ribbon groups, and then in the Select ribbon group, click or tap what you want to select in the table to modify. However tables are still nearly useless when editing via Safari on an iPad. But this is going to take a lot of time if there are hundreds of columns to fix. On the displayed menu, select 'Distribute columns evenly'. Does Cast a Spell make you a spellcaster? How can I set the default value for an HTML