Microsoft Excel Column Sizes Can Be Equalized Easily in this Way

KOMPAS.com – Users Microsoft Excel can match size column which is easy to make. The same column size makes Microsoft Excel look neater and data easier to read.

However, for some users, making Excel column sizes the same is quite difficult to do or they don’t know how.

How to equate Excel column sizes can actually be done quickly. There are several ways you can do to equalize column sizes in Excel.

Also read: Get to know Microsoft Excel and its Benefits and Formulas

The following KompasTekno a number of how to equalize column sizes in excel which you can try.

• Select and block the column section that you want to change (on labels A, B, C and others)
• After selecting the part of the column you want to change, hover over the column line until it changes to a double-headed arrow
• Then drag the double-headed arrow cursor icon on the column. The cursor will display a width that can be adjusted according to your needs
• Done, all columns will adjust to the width you have adjusted

As for adjusting the height size, you can use the same method, namely dragging the cursor up or down until it displays a height size that can be selected according to your needs. For more details, you can see the image above.

Also read: How to Print Columns in Microsoft Excel on One Page

How to equalize column sizes in Excel with the Format feature

Kompas.com/soffyaranti How to equalize Excel columns

• Select and block the section of the column you want to change
• See the menu bar section above
• Select the “Format” feature
• Click “Column Width” to adjust the width or “Row Hight” to adjust the column height
• Then enter the width or height of the desired column size
• Then click “Ok”

How to auto-align Excel columns

• Select and block the section of the column you want to change
• See the menu bar section above
• Select the “Format” feature
• Klik “Autofit Row Height” atau “Autofit Column Width”

Done, that’s how to equalize column sizes in Excel. That way, the data will look tidier and easier to read. I hope this helps.

Get updates featured news and breaking news every day from Kompas.com. Let’s join the Telegram group “Kompas.com News Update”, how to click the link https://t.me/kompascomupdate, then join. You must first install the Telegram application on your cellphone.