You can simply press Ctrl + A to select all the cells to make same size. The next thing to do is to select the whole worksheet. Ensure that the sheet you are opening is the one for which you want to make all rows and columns same height. Step 1: Open the sheet with cells to resizeĭouble-click on the sheet to open it. In this we shall look at the steps to follow in order to make all cells same size in Excel.
A sheet that has been repeatedly worked on will be unorganized, given that the rows and columns sizes will not be of the same size. The easiest way to know whether or not a given worksheet has been worked on multiple times is to see if it is unorganized or not. When we repeatedly work on a given file, we make many changes with as far as the row and column sizes are concerned.
How to make all rows and columns same size in Excel – Excelchat
