Make columns the same width in Excel

Lightbulb icon demonstrating good idea, used to highlight solution in website
How to make columns the same width in excel, and rows the same height
This short video shows how to quickly set the same column widths for a range of columns in an Excel worksheet
Method — make equal column widths (see video above)
  • Select the columns by clicking and dragging across the worksheet column headings (i.e. within the top row containing the labels A, B, C etc.)
  • Select (click and hold) any of the column dividers from within the column header, and the cursor changes to a double-headed arrow.
  • Drag to the required width and release the mouse button.
  • All the columns will match the set column width.
  • The columns stay selected until you click outside of them, so you can continue to fine-tune the width.
Method — make equal row heights
  • Use the same principle as for adjusting column widths.
  • Select the range of rows from within the row labels.
  • Select and drag one of the row dividers from within the row number area (rows 1, 2, 3 etc.).
  • All the selected rows will adjust to match the adjusted row height.