How to make all rows same height or columns same width in Excel?
When you work on an Excel worksheet, sometimes, you need to make all the rows have the same height or all the columns have the same width, so that you can create some special projection. In Excel, you can quickly deal with this job with the following methods:
Make all rows same height or columns same widths with Format command
Make all rows same height or columns same width with Kutools for Excel
Make all rows same height or columns same widths with Format command
With the Excel’s Row Height and Column Width functions, you can quickly format all the column width or row height have the same size.
1. Click the 
icon at the top left corner of the worksheet to select the whole worksheet.
2. Then click Home > Format > Row Height to set all the rows have the same height, see screenshot:
3. In the Row Height dialog box, enter the number of row height you need, see screenshot:
4. Then click OK button, all the rows have the same height at once.
Tips: To make all columns have the same width, please select the whole worksheet and then click Home > Format > Column Width to set the number of the column width as you need.
Make all rows same height or columns same width with Kutools for Excel
If you have Kutools for Excel, with its Adjust Cells Size utility, you can set all the row height or column width in same size with the unit pound, centimetre, inch or pixel as below demo shown. Click to download Kutools for Excel!
After installing Kutools for Excel, please do as follows:
1. Click the icon at the top left corner of the worksheet to select the whole worksheet.
2. Then click Kutools > Format > Adjust Cell Size, see screenshot:
3. In the Adjust Cell Size dialog box, specify one unit type you need to format your row height or column width, and then check Row height or Column width and enter the number of row height or column width you want, see screenshot:
4. Then click Ok or Apply button, all the column width or row height have been same size.
Tips: If you want to adjust row height and column width at the same time, just need to both check the Row height and Column width options and type the numbers into the Adjust Cell Size dialog.
Free Download Kutools for Excel Now
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in