Microsoft Excel 54 Managing Worksheets

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

Transcript

00:00so now let's see how we can go ahead and manage out the worksheets that we have so over here you

00:10can see that i got this worksheets inventory list so now what i can actually go ahead and do

00:17is let's say for example i want to change the name of it then i can simply click right here

00:22just like this double click right here just like this and i can simply go ahead and type in list

00:27right here and press enter and that will be renamed out apart from that what you can also do is let's

00:33say for example i have another worksheet right here so i'm just going to say new sheet just like this

00:39and i can even go ahead and color code these out let's say for example list i want to assign a color

00:44to it and in that case i can go ahead and right click and then go to tab color and choose a color

00:50as i want right here or you can even go to more color and choose a custom color as you wish as well

00:56and assign the color to it right here just like this so you can see that when it is active it's

01:01a light color just like this and if i were to go around over here you can see that the selected color

01:06has been applied right here just like this you can even go ahead press plus button to insert new seat

01:12or you can even go ahead right here right click and then let's say for example um move or copy up

01:19the seat so i'm just going to go around over here create a copy of the list seat press ok

01:24then you can see that it simply created a copy of the same seat right here just like this so if i

01:31were to click and drag this i can move it wherever i want so you can see that this is what you have you

01:35can even go ahead and hide the seat right here and unhide the seat right here and select the sheet

01:41that you want right here and unhide it out as well if you want to go ahead and delete a particular

01:47sheet simply select a sheet right here right click and delete it out right here just like this

01:52and those are basically the ways by which you can rename insert color and delete seats and manage

01:59outwork seats as you like in microsoft excel so hope you found this video useful be sure to hit the like

02:06button don't forget to share this out with your friends and family and for more contents like these

02:12do follow simple tutorials

02:14do you

Category

Transcript

Be the first to comment

Recommended