How Do I Make All Cells the Same Size in a Column?
You can simply press Ctrl + A to select all the cells to make same size. Alternatively, you can on the icon between rows and columns.

How do I resize all cells in a column?

On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width. Note: To quickly autofit all columns on the worksheet, click the Select All button, and then double-click any boundary between two column headings.

How do you make all cells the same width?

Make All Columns the Same Width

  1. Select all cells in the worksheet. To do this, click on the arrow in the upper left corner of the gridlines.
  2. In the Ribbon, go to Home > Format > Column Width.
  3. In the pop-up screen, (1) set Column width (for example, we set 15 here), and (2) click OK.
Sophia Al-Mansoor

Sophia Al-Mansoor

Global Business & E-Commerce Reporter

Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.

Share this article
Twitter Facebook Pinterest