How to Change Row Height and Column Width in Excel

In this excel tutorial for beginners, I’ll demonstrate how you can resize row height and column width in MS Excel. There are several ways to change it and I’ll explain all of them in this tutorial.

1. Drag & Resize: A mouse is all you need. You can always drag and change the height and width of your cell, row or column. Just hover your mouse at the edge of your row and then you’ll see your mouse cursor is changing. Then click it and it will show you present row size. Now drag your mouse until you are satisfied with the result. Same thing you can do for columns.
2. Double Click: If you hover your mouse at the edge of your row or column you’ll see the cursor changing. Double click there and it’ll autofit your row or column depending on where you click.
3. Context Menu: You can change row height by selecting the entire row and then right mouse click. You’ll find row height there. Click on that and a popup will arise. Write the certain values and done. Now select the entire column and follow the same instructions to resize column.
4. Format: You can access to row height, column width, auto fit row and column, and also default column width. Click on the Home menu and at the top right corner you’ll find format. Click on that and you’ll access them.
5. Resize row and column for entire worksheet: You can change the row height and column width for the entire worksheet. You can do it using all the method I’ve just explained. All you need to do is select the entire worksheet before that. You can select the entire worksheet by pressing Ctrl + A or using a mouse.
6. Match width with Another Column: You can copy column width of a certain column. There are several ways to do it. In every part you need to copy a cell from the source column and click on any cell of the column you want to resize. Now under the Home menu. Click on the paste dropdown. You’ll find resize icon. Click on that and the column width is matched with the source column.
You can do the same thing with context menu. Copy any cell of the source column and then select a cell of the destination column. Right-click and click on the arrow beside the paste special menu and select the paste option with resize icon. Done.
You can do it by going to “Paste Special” menu. Copy a cell and select another and go to paste special option. You can go to paste special from under the home tab, context menu or using keyboard shortcut. After you are in paste special pop up click on the “Column Widths” and then click ok. Or You can Simply Press the keyboard shortcut ALT+E+S+W and Enter.
These are the ways you can resize row or column. This will help you to do several important task in excel. You’ll be able to
1. Resize rows and columns.
2. Autofit row height
3. Autofit Column width
4. Change row height
5. Change row height for entire worksheet
6. Change column width
7. Change column width for entire worksheet
8. Set default column width
9. Measure present row height
10. Measure present column width
11. Copy a column width and many more.

#Row #Column #Resize

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[aquastrxlogy]

Thank you so much for this video. I've watched countless videos about excel tables but none of them even mentioned the size of cells. You explained it in the first few seconds of the video very clearily, not wasting time on any unimportant details. Thank you so much.

[mollywolly]

Absolutely the best! You answered my question in 4 seconds...thanks so much!!

[Buhle.Byl.]

Thank you very much, this just helped me with work sheets at work. Keep it up 😉

[srujana]

Thankyou so much 🥺 it saves my time and helped me a lot 🙏

[cabezitadealgodon]

You explained this better than anyone else on the internet...thank you!

[ceylontuber]

Bro Thank you very much for your information and presentation is so useful...

[chalambabu]

well explained, straight to the point thank You

[fredyandfriends]

The Best bro i needed this for a project Thanks man!

[faizanzai]

Well that's straight to the point video man id subscribe and will follow you

[dineomeso_]

Thank you so much! Got answered in less than 2 minutes

[alihemopo]

Thank you very much, just learning excel. I had to try it a few times got it😊

[johnboy]

Hiya, First class, thanks for your time and effort for sharing your knowledge

[TheMdtariq]

Damn that's too much of an information in one place. Subscribed immediately!

[noufalkk]

This video helped me to clear a problem 👍

[Max_mayleey]

THANK YOU THIS HELPS ME IN MY COMPUTER SUBJECT

[r-pieu]

NAMASTE. LOVE FROM INDIA 🇮🇳 ♥️ हर हर महादेव 😊😊🎉🎉.

[ralphalvarez]

Thank you so much you are very helpful

[rstas]

Thank you sir
From Bangladesh ❤️🇧🇩❤️

[ayeminthant]

thats what i need to know for months thx