To make all cells the same size in Excel and Google Sheets, select all the columns/row and then click on the Format tool to change the Column width or Row height.

While sorting data in Excel, if you see the “ All the merged cells need to be the same size ” error, this article will help you. While managing data in Excel, you may need to sort it many times.

Tips By default, Microsoft Excel automatically resizes row heights to the size of the largest type contained in any cell within the row.

Open the Excel worksheet for which you want to alter the column width. Click on the Home tab in the Excel ribbon. Go to the Cells group and click on the "Format" icon to reveal the Cell Size menu.