Microsoft Excel 37 Modifying Rows and Columns

SimpleTutorials

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 Modifying Rows and Columns in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hyw

Transcript

00:00So over here you can see that I have this particular table right here in certain size

00:10and if I want to go ahead and let's say for example change around the size of the rows

00:15and columns, the straightforward ways to do it is simply go around onto the letter section

00:20and click and drag this out to change the size of the column right here associated with the

00:27letter. Same goes with the row as well. We can go to the row number, click and drag this out to change

00:32around the size of it. Apart from that, if you want to precisely change the size of the row and column,

00:38you can right click on the letter name right here and then go around over here onto column width right

00:43here just like this. Then what you can do is you can go ahead and type in the column width right here,

00:48press ok and it resizes out. Similarly, I can do the same with the row as well. So I can go ahead

00:54and right click and then go around over here onto row height and type in the row height as I want

01:00as well. If I want all of the rows and columns to be the same size, I can actually go ahead and click

01:06on the corner cell right here, the column corner cell area, click and drag the column and then what

01:12happens is that all the column right here just like this will be same size. Similar goes for the rows as

01:18well. Whatever rows I select, I can go ahead and select out multiple rows right here and then click

01:24and drag it out to go ahead and change the row size. So I can go ahead right here, click and drag this out

01:29right here. So this is what you have as you can see and that is how you can modify out the rows and columns

01:36as you like inside of Excel. You can also go around over here, insert out rows right here and insert out

01:43column right here and even go ahead and delete this out right here just like this. So I hope you found

01:48this video useful. So be sure to hit the like button. Don't forget to share this out with your

01:54friends and family and for more contents like these, do follow simple tutorials.

Category

Transcript

Be the first to comment

Recommended