Row runs horizontally, and column runs vertically. We explain how to set or change the Row height and Column width in Microsoft Excel.

Traditional Ways to Adjust Column Widths (Manually) In this example, Excel's default column width isn't wide enough to show all the text in column A.

Clicking "AutoFit Column Width" forces Excel to adjust the width of the columns you selected so that they are wide enough to display their contents. Every Excel spreadsheet has a "Select All" button.

Excel columns are fairly narrow by default, and they won't always accommodate all of your data. With this in mind, Microsoft makes it easy to adjust the width of a column by dragging the line on ...

In Excel 2007, press Alt, which puts Excel into a shortcut key mode (see the January 2009 column, page 74, for more on the use of KeyTips) and press H for the Home tab of the Ribbon. Press O (capital ...

But this can result in too much white space in the rest of the row or column. Rather than fitting the cell to the label size, Excel also lets you resize the contents to fit within the cell.