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:
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.
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,
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.
And now the other way.
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’.
Now simply enter the value for the width, for example 50. Click on OK and it’s done!
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!