Hi, this is Wayne again with a topic “Work on Multiple Excel Sheets at Once by Grouping Sheets”.
In this article, i’m going to show you a couple of tricks for working with multiple spreadsheets in an excel workbook and specifically we’re going to look at how to edit multiple excel sheets all at the same time. So here i have a completely blank excel workbook and there’s just one sheet here in the lower left: i’m going to go down and click the plus sign to add sheet 2 sheet 3: how about 5 sheets – and let’s say each of these sheets – is going to Start with basically the same information here in column, a i want to put the months and then in row one. I want to put a series of tasks that need to be done during each month, so i could set up each spreadsheet one at a time. That would be pretty time consuming or i could do the following. I could click on sheet, one hold shift and then click on sheet. Five, as you can see, all five sheets now have a white background on the tabs for the sheets, so all five are selected and now i can go here to the upper left in a1. I click i’ll type month, i’ll tap enter and then i’ll just go ahead and type in january. As you probably know, we have. The autofill handle this little green square in the lower right corner of the cell, that i can click and drag and pull down to put in the rest of the months now in b1. I can type in the first task that i want done each month, i’ll double click between b and c, just to create some room for that text to fit in and then i’ll move on to c1 and d1 and give me a minute to add a few More items and then i’ll resume the video okay. So this is the information that i want to be on all five spreadsheets and i also want to apply some formatting so i’ll click on row, one and i’ll make it bold and column a i’ll make that bold.
I had to click twice in that case and i could even click and drag to select a through f and i could just go here to the home tab in the font group. I could apply a background color if i want to okay, so i’ve set this up the way i want it to be. Let’S take a look at sheet two sheet three sheet: four they’re, not all zoomed to the same level as sheet one but other than that. All of the changes that i made on sheet 1 have been applied to the rest of the sheets. This is a great time saver. Now what? If you want to make changes to a couple of the spreadsheets, but not all of them? Let’S say i want to change sheet 1 and sheet 3.. Instead of holding shift, i would hold ctrl and then click on sheet 3.. So now, sheet 1 and sheet 3 are selected, i’m going to type in done in b2, tap enter, and now, if i click on sheet 2 you’ll see that it does not have the word done, but sheet 3 does so by using the shift button to select All of the sheets or you could use the control button to select or deselect certain sheets, you’re able to actually work on more than one spreadsheet. At a time now, in some of my spreadsheets, i end up with so many tabs and sheets that it gets to be kind of hard to move from one sheet to the next. For example, some of my budgeting spreadsheets they go back months and months and months and even years, and so how do i jump to a specific month, let’s say december from five years ago? Well, it can be kind of hard you’d have to click here in the lower left and click on this arrow to move through the spreadsheets.
Until you find the sheet that you want and then you can click on it. Well, there’s actually a faster way to do that, instead of left-clicking on the arrow you can right-click on the arrow. It brings up the entire list of sheets that you have in your current workbook and then you can pick the specific sheet that you want to go to sheet9 in this case, as you probably already know, you can easily rename these sheets just by double clicking on The sheet tab and then typing and tapping enter when you’re done. You can also right click on it and choose rename if you prefer that – and you also probably know that you can click and drag to reorder these sheets anytime. You need to if you want to move them around, so i hope that you found this video on how to work on multiple excel spreadsheets at the same time, and also how to manage multiple sheets in a workbook. I hope you found it to be helpful if you did please like follow and subscribe and when you do subscribe, click the bell so you’ll be notified. When i post another video, if you’d like to support my channel, you can do that through my patreon account, or by buying channel merch and you’ll, see links to those opportunities in the description below the video.
Speaking of patreon, i’d like to give a quick shout out to my five dollar patreon supporters. Thank you. So much for all that you do to support the channel.
You can also support at the one dollar level and there are other options as well, and i appreciate all of my patreon supporters. Thank you. So much .