Join Dennis Taylor for an in-depth discussion in this video Changing tab colors and renaming sheets, part of Excel 2016: Managing Multiple Worksheets and Workbooks.
- [Narrator] In this workbook called Sales Data,…there are multiple sheets here.…They happen to have the same same layout,…that's not important for what we're about to do.…But that's not uncommon if you're gathering data…from multiple states or regions.…Now, these sheet tabs are all the same color.…Nothing really wrong with that, but we can add color.…I want to change the color here.…Now it just so happens that what we see in row one…is different for each of the states.…We can make the tabs match, we don't have to do that.…But how do we add color to a sheet tab?…Right click the tab.…
So I'm going to change the Colorado sheet tab,…by right clicking on the sheet tab,…and going to Tab Color.…Lots of choices here, if we don't like any of these…let's go to More Colors.…And in this grid where you see 127 different choices…we could make a choice here.…That one looks pretty much like what we're seeing in row 1,…doesn't have to be that but we'll just click OK.…And there it is.…But the color that we apply to a sheet tab isn't so obvious…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Working with different worksheets together
- Copying and moving worksheets within a workbook
- Linking formulas across multiple workbooks
- Changing tab colors and renaming sheets
- Copying, moving, and inserting data on different sheets
- Working with multiple workbooks
- Navigating workbooks
- Getting data from other sheets with 3D formulas