Skip to playerSkip to main content
  • 1 year ago
Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.

In this video lesson, we will learn about Resizing Rows and Columns in Microsoft Excel

You can access the entire Microsoft Excel Course in the following playlist:
https://www.dailymotion.com/playlist/xa9hyw

Category

📚
Learning
Transcript
00:00So over here you can see that I have this table and if I want to go ahead and change the size of
00:10rows and columns of this, then all I need to do is click and drag around the edges right here just
00:17like this. So go around and click and drag the right edge to change out the size as you can see
00:22just like this. Same goes around for the height as well for the rows right here just like this.
00:29What you can also do is click and drag out the numbers right here to select all the rows and then
00:35click and drag out the height so that same height follows up for everything. Similarly you can go
00:41around over here and do the same for the column as well. Go ahead and resize and then the column
00:46will be resized accordingly. But for these let's say for example I want to resize it myself so I can
00:51go ahead and manually resize them out. I can also select out all of these columns are rows and right
00:57click right here and then go to column width right here and add in the column width in detail right
01:04here just like this and then you can see that as per the point right here the column width changes
01:09out. So let's go around and add in 20 and then you can see that this is the column width right here.
01:14Similarly I'm going to go around over here right click on to let's say for example row height and then
01:20it's in a size 33 so let's just go ahead and keep it 20 right here press ok and then it resizes out
01:27accordingly. So that is what you have and let's say for example for all of these for product id
01:32category quantity and unit price I'm going to go around over here onto column width and I'm going to
01:38go ahead and type intent let's say for instance press ok then this is what you have as you can see.
01:44So that is how you can go ahead and adjust out rows and columns inside of excel. So if you found this
01:51video useful be sure to hit the like button don't forget to share this out with your friends and family
01:57and for more contents like these do follow simple tutorials.

Recommended