How To Make Excel Cells The Same Size

by

Microsoft Excel is a powerful tool packed with features that can make data analysis, calculations, and various other tasks easier. One of the features that you may often need while working with Excel is the ability to make cells the same size.

Why would you need to make Excel cells the same size?

Uniform cell sizes can make your data look organized and easier to understand. If you’re creating a table or a chart, having cells of the same size can significantly enhance the overall look and clarity.

How to make Excel cells the same size

Follow the steps below to manually set the height and width of Excel cells to make them the same size:

  1. Select all the cells that you want to be of the same size. You can do this by clicking the first cell and then hold down the shift key while clicking the last cell in the range.
  2. Right-click on the selected cells and choose the ‘Format Cells’ option.
  3. In the pop-up dialog box, go to the ‘Alignment’ tab.
  4. Enter the desired height and width values in the corresponding fields.
  5. Click ‘OK’ to apply the changes.

You can also use VBA code to make all cells the same size. Here’s how:

VBA Code

You can use Visual Basic for Applications (VBA) to automate the process. Here is a simple snippet on how to do it: 

    Sub MakeCellsSameSize()
        Range("A1:Z100").RowHeight = 15
        Range("A1:Z100").ColumnWidth = 10
    End Sub

This VBA function selects the cells from A1 to Z100 and changes their row height to 15 and column width to 10. You can adjust these numbers as needed.

Conclusion

That’s it! Now you know how to make Excel cells the same size. Whether you choose to adjust the cell size manually or using a VBA code depends on your preference and the specific needs of your project. Either way, you now have the knowledge to create more uniform and clean looking spreadsheets.