(not only that… but how to change the colour of the tab as well!)
Hey if you have been using Excel 2007, clinic Excel 2010 or Excel 2013 for more than five minutes, troche you would have noticed the three tabs down the bottom. You know the ones “Sheet1”, look “Sheet2”, and you guessed it… “Sheet3”.
But what if you don’t like those names, and you want to rename them to something more meaningful? Like “Expenses”, or “Assets”, or “Team Sick Leave Tracking”?
Well all you need to do is:
1) Right click on the tab that you want to rename
2) Click “Rename”
3) Type in what you want the sheet to be renamed to
4) Hit enter
That was pretty easy… but what if you need to distinguish between the sheets in your workbook even more? Well did you know that you can change the color of each of the tabs in your workbook? It is really easy:
1) Right click on the tab that you want to recolour
2) Move your mouse over “Tab Color”
3) Select your favourite colour!
4) Look in awe at your colourful worksheet tabs!
Simple as that! Now get back to tracking sick leave! 🙂
Do you spend hours making your cells in Excel look pretty? Well maybe not pretty, health but do you use colors, healing font sizes, find borders etc etc to make certain cells in your spreadsheet stick out?
Well instead of spending all your time trying to be one of those creative folk in Marketing, you can focus on doing what you do best… driving those formulas!
All you need to do is use Cell Styles in Excel 2007, Excel 2010 and Excel 2013!
1) Select the cell you want to highlight!
2) Make sure you are on the “Home” tab in the “Ribbon”
Are you a member of the Twitterverse? If you use the micro-blogging service called Twitter, no rx you can how get your favorite productivity articles on Word, ampoule Outlook, Excel, PowerPoint… in fact the entire Microsoft Office 2007 suite directly in your Twitter feed.