Microsoft Excel 38 Hide and Show Cell Data

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 Hide and Show Cell Data 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 and let's say i

00:10want to go ahead and hide particular uh particular rows or columns as i need so to do that i can

00:17simply click and drag this around right here like drag out the column right click and then what you

00:22can do is hide this column right here just like this apart from that uh you can go ahead and

00:28select out let's say multiple columns by clicking and dragging and then you can right click and then

00:34you can go ahead and unhide this out as well so once you go ahead and do that what happens is that

00:39it unhides it out so whenever you go ahead and hide out the columns right here you can actually see

00:44the column letter actually is not serial anymore because it didn't delete out the data but it just

00:50hid it out right there similarly over here you can see that you can go ahead and hide this out right

00:56here you can go ahead and hide this um uh row out as well just like this and you can see that

01:03the numbers are not serial now but the data is still there it's not uh it's not deleted so you

01:09can go around over here select it and then you can go ahead and unhide this out just like this

01:14and same goes for the cell right here as well you can go ahead and unhide it out so that is how you

01:20can go ahead and hide and show out the data inside of microsoft excel so hope you found this video

01:26useful be sure to hit the like button don't forget to share this out with your friends and family

01:32and for more contents like these do follow simple tutorials

Category

Transcript

Be the first to comment

Recommended