How To Make All Cells The Same Size In Excel

To make all cells the same size in Excel, select all the cells by clicking on the triangle at the top left corner, and then adjust the row height and column width to desired dimensions.

In today’s ever-evolving world of technology and data analysis, Excel continues to hold its ground as one of the most widely used tools for organizing and manipulating data. While its versatility is undeniable, there are often challenges that users encounter when working with Excel spreadsheets. One common hurdle is the variation in cell sizes, which can make your data appear inconsistent and unprofessional. However, fret not! In this blog post, we will explore easy and effective methods to make all cells the same size in Excel, allowing you to present your data uniformly and enhance your overall spreadsheet aesthetics. So, whether you are a novice Excel user or a seasoned pro looking to optimize your spreadsheet presentation, read on to discover the techniques that will help you achieve a seamless and visually appealing result.

How To Make All Cells The Same Size In Excel: Step-by-Step


Step 1: Open the Spreadsheet,

First, locate and launch the Microsoft Excel application on your computer, then open the desired spreadsheet you wish to work with by selecting it from your file navigation system or by double-clicking the file.

Next Step

Step 2: Select All Cells,

Click on the corner box where the first row and column intersect to select all cells in the spreadsheet, allowing you to easily work with the entire data set.

Next Step

Step 3: Choose Column Width or Row Height,

To adjust column width, move your mouse to the right edge of the column header, right-click and select ‘Column Width.’ For rows, hover over the bottom of the row header.

Next Step

Step 4: Set the Size,

Upon clicking, a dialog box will open allowing you to specify the desired size. Simply enter the width or height value, and witness the column or row effortlessly adapt to the new size.

Next Step

Step 5: Apply Same Size,

This uniform sizing is facilitated because when all cells are selected, any adjustments made to the size of a single cell automatically get applied to the rest, ensuring consistency throughout the entire dataset.

Next Step

Step 6: Deselect the Cells,

Click anywhere outside the table or press ESC to deselect the cells. This allows you to easily navigate away from the table and continue working on other tasks without altering the selected cells.

Next Step

Step 7: Save your Excel File,

Saving your excel file is crucial. Click ‘File’ and select ‘Save’ or press ‘Ctrl + S’. This ensures your work is securely stored, preventing any data loss or accidental changes.


In this blog post, we have explored various techniques to make all cells the same size in Excel. We have learned about adjusting column widths and row heights manually, using the AutoFit feature, and employing the Format Painter tool. These methods offer flexibility and convenience in ensuring uniform cell dimensions for a professional and organized Excel spreadsheet. Whether you are working on a small table or a complex data set, these techniques will save you time and effort in achieving consistency in cell size. By employing these strategies, you can enhance the readability and visual appeal of your Excel documents. So go ahead and try out these tips and tricks to make your Excel worksheets appear polished and well-structured.

Table of Contents