Īlthough I haven’t seen these methods documented, they appear to work well.įor a more extensive discussion about how to set column width and row height in Excel, see this Microsoft Knowledge Base article. ) Or, with the columns selected, right-click a column heading, click Column Width, and type a number. (The number corresponds roughly to the number of characters in the cell, assuming you are using the default font face and size. There’s an alternate method: With the columns selected, click the Format drop-down in the Cells group on the Home tab, then click Column Width and type a number, such as 10 or 12.
Release the mouse button, and all columns will adjust to be the same size. Just select the columns - note that, in fact, this procedure works even if the columns aren’t adjacent - and click and drag the margin of any one column in order to widen it as you wish. So far, I haven’t found any command in Excel 2007 or Excel 2010 that functions exactly the same way as “Distribute Columns.” However, there’s a fairly easy way to get the same result. (To use this feature in Word, select the columns in question, then navigate to the Layout portion of the Table Tools tab and click the “Distribute Columns” button.) A client recently asked if there is a command in the newer versions of Excel - similar to Word’s “Distribute Columns” command - that makes it easy to equalize the width of adjacent columns.
