Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today

---

Have you ever noticed if you select some text in Microsoft Word 2007 you get a little pop-up menu.  You know the one, physician it lets you change the font, apoplectic the font size, anabolics the font colour and a lot more.

Some people think it is great.  Some people think it is annoying.

I think it is great, but as a service to you, I will let you know how to turn it off, and stop it from popping up!

1. Click on the menu – the “Office Orb” (that circle in the top left hand corner which used to be the file menu!)
2. Click on “Word Options”
3. Look in the “Popular section”, under “Top options for working with Word
4. Untick the “Show Mini Toolbar on selection” checkbox
5. Hit ok

There you go – no more annoying (not) popup mini menu in Word 2007

’till next time

TNP 😉

 

How many times have you lost everything in your document?  Word crashed?  Maybe the power went out?  Whatever it was that happened… I bet it happened just before you were going to save, pharm right?

By default, medicine Word 2007 makes an Auto Recover save every 10 minutes.  But if you are clumsy like me, or don’t trust your computer… you can set Word to autosave your document a lot more than normal.  Here is how:

1. Click on the old file menu (the office orb)
2. Click on "Word Options"
3. Click on the "Save" option in the left hand menu
4. In the first section "Save Documents", look for the second line which reads something like "Save AutoRecover information every XX minutes
5. Set your preferred time.  Mine is now every 1 minute 🙂

Just remember when increasing the AutoRecover frequency… that you do see a slight performance hit every time it saves.  Not really noticeable every 10 minutes, but when it happens every 60 seconds it could be annoying!

’till next time!

TNP 😉

 

Have you ever poured your heart and soul into absolutely awesome background in your word doc?  Maybe you coloured it bright yellow, therapist or purple, what is ed or ‘mother of pearl’? 

It looks great on the screen, but when you print it… you can’t see it!

Did you know by default Microsoft Word 2007 that background colors and images are not printed?

It is easy to print them out though.  Here is how:

1. Open the file menu (the circle in the top left hand corner of the screen
2. Click on "Word Options"
3. Click on "Display" in the left hand menu
4. Look in the "Printing options" section"
5. Tick the "Print background colors and images" check box
6. Click ok

How easy!  Just a word of warning though… printing a bright yellow background on every page will not only cost you an arm and a leg in ink and toner, but will also require you and your colleagues to invest in sunglasses.

 

’till next time!

TNP 😉

 

Have you ever noticed if you select some text in Microsoft Excel 2007 you get a little pop-up menu.  You know the one, advice it lets you change the font, what is ed the font size, see the font colour and a lot more.

Some people think it is great.  Some people think it is annoying.

I think it is great, but as a service to you, I will let you know how to turn it off, and stop it from popping up!

1. Click on the menu – the “Office Orb” (that circle in the top left hand corner which used to be the file menu!)
2. Click on “Excel Options”
3. Look in the “Popular section”, under “Top options for working with Excel
4. Untick the “Show Mini Toolbar on selection” checkbox
5. Hit ok

There you go – no more annoying (not) popup mini menu in Excel 2007

’till next time!

TNP 😉

 

Are you a little worried by some of the names of the documents you have recently opened in Word 2007?  Scared your boss might catch you out updating your resume, therapist working on your next novel or simply working on things that you shouldn’t?  Well this little trick will help you out!  Basically, cough how to get rid of all those recent documents that Word 2007 lists for you.

1. Open "Word Options" by clicking on the Office Button, and then looking for the "Word Options" button
2. Click on the Advanced Section
3. Scroll down to the "Display" Section
4. The first option in the "Display" Section is "Show This Number of Recent Documents" – set that to "0"
5. Click "Ok"

There you have it – no more recent documents means no more strife from your boss! 

But just in case you have a change of heart in the future, you can turn on recent documents again simply by changing the "0" to something like "5" or "17", depending on how many you want to see.

’till next time!
TNP 😉

 

Share this tip: on Twitter on Facebook on Google+