How to Change the Width of a Column in Excel

How to Change the Width of a Column in Excel

In this tutorial, we’ll cover how to change the width of a column in Excel in a super easy way.

Keep watching! We’re about to start.

See the video tutorial and transcription below:

See this video on YouTube:
https://www.youtube.com/watch?v=uTjwtwDIACo

As you might’ve already noticed, Excel usually offers more than one solution to any task. The same applies when it comes to changing the width of a column in a spreadsheet. In a couple of seconds, we’ll guide you through the two quickest and easiest ways to do this.

First Quick Way How to Change the Width of a Column in Excel

Sometimes, you need to adjust the column width but don’t know the exact dimensions or value, in points, to specify the width. In that case, follow these steps:

Position the cursor over the right-hand border of the column whose width you need to change. Once the cursor turns into this double-headed arrow,

How to Change the Width of a Column in Excel - adjust the width of the column in Excel

left-click and drag the arrow to adjust the width of the column as needed. While dragging, this box will show you the current column width in figures, so you’ll be able to follow number values, too.

How to Change the Width of a Column in Excel - number value of column width in Excel

And now the other way.

Second Quick Way How to Change the Width of a Column in Excel

Imagine that you know the exact number of points to enter to adjust the column width. Here’s what you do.

Click on the column to select the area  – let’s say we need to change the width of the column D here. Right-click on the column and choose the option ‘Column Width’.

How to Change the Width of a Column in Excel - set the width of the column in Excel

Now simply enter the value for the width, for example 50. Click on OK and it’s done!

How to Change the Width of a Column in Excel - bigger or smaller column width

How to Change Width of Multiple Rows in Excel

You can easily use the same way to change the width of multiple columns at once.

If you’d like to see more on how to work with columns in Excel, check out the links the description below!

If you found this tutorial helpful, give us a like and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.