Today, I'm going to be talking about a few quick things you can do in Microsoft Excel to make life...
For some reason, repetition can really get to me. If I have to do the same thing over and over again, it makes my head spin.
And as many of you know, I love me a spreadsheet to help keep myself organized.
Currently, in my main job I am in charge of keeping track of 11 different buildings - the budgets, the programs, etc. When I was trying to figure out the best way to keep track of things, I originally thought I would have an Excel file for each building. And then I would have a tab for budget, a tab for programs, etc. However, when I started down this road, I realized something.
If I did this, I'd have to create each tab I needed in 11 different Excel files for 11 different buildings. And the thought of this made me a little crazy.
And that's when I realized that what I should be doing is one file for budgets, one for programs, etc. That way, I can use the trick I'm going to teach you and only have to create the sheet ONCE for all 11 buildings.
There is a way to connect however many sheets you want so that whatever you put into one sheet will copy over to every other sheet! And it so easy to do. What you need to do is group the sheets together.
You simply hit CTRL and click on every sheet/tab you want to include in your group. Once you've clicked them all and release the CTRL button, you will notice that the title bar now includes the word Group because you're working in Group Mode.
While you're in Group mode, everything you type into one sheet will automatically appear on every other sheet.
But here's a word to the wise - as soon as you click away from the tab you're working on (which one might do because you feel like you want to make sure that things are showing up on all the tabs) - the sheets will ungroup. So make sure that either a.) you do all that you want to do before you click back through the other sheets or b..) make sure to re-group the sheets before you continue adding things to the sheet.
And there you have it - excellent Excel efficiency!
