How to Rename a Sheet in Excel

(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! 🙂

‘till next time!
TNP 😉

Track Changes in Excel

We all know how handy track changes is in Word 2007… but did you know you can track changes in Excel 2007 as well?

I bet you didn’t!

It is just as easy to use as in Word… here is how!

1) Make sure you are on the “Review” tab on the Ribbon in Excel 2007, viagra Excel 2010 or Excel 2013

2) Look for the “Changes” group (should be the one on the far right hand side)

3) Click on “Track Changes”

4) Click on “Highlight Changes”

5) Check “Track changes while editing.  This also shares your workbook.”

6) Select what you want highlighted

7) Click OK

 

Once you have plenty of changes highlighted, buy just go back to the “Track Changes” button and click “Accept/Reject Changes”

Now you can really keep track of things in Excel 2007!

‘till next time!
TNP 😉

How to turn gridlines on and off in Excel

Are you building a gem of a spreadsheet, sovaldi sale but feel that it would look much better if it didn’t have those lines in between all the cells?

Well those lines are called “Gridlines” and they are really easy to turn on and off

To hide gridlines in Excel 2007, generic Excel 2010 or Excel 2013:

  • Make sure you are on the “View” tab in the Ribbon
  • Look for the “Show/Hide” group
  • Click on “Gridlines” checkbox, which will make the tick (and the gridlines) disappear

To show gridlines in Excel 2007, Excel 2010 or Excel 2013:

  • Do the same as above, but just make sure that you check the checkbox!

Simple as that!

‘till next time!
TNP 😉

Check your Spelling in Excel

Are you a hardcore spreadsheet king?  The number cruncher?  On the Accounting A-team?

Then chances are… your spelling is… well… not very good at all!

Luckily Excel 2007, ed Excel 2010 and Excel 2013 all have a spell checking feature that will stop people from noticing your spelling mistakes!

1) Click on the “Review” tab in the Ribbon

2) Click on “Spelling”

or alternatively just use the “F7” keyboard shortcut!

‘till next time!
TNP 😉

Cell Styles in Excel

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”

3) Look for the “Styles” Group

4) Click on “Cell Styles”

5) Select your favorite cell style!

It is as simple as that!

‘till next time!
TNP 😉

Get Office 2007 Help, Tips, Tricks, and Tutorials on Twitter!

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.

All you have to do is follow @TheNewPaperclip.

I will be on there regularly so if you have any questions or suggestions for articles you can post them to Twitter as well!

‘till next time!
TNP 😉