How to find ANY Office 2007 command you want!

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 😉

 

Technorati Tags: ,,

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 😉

 

Technorati Tags: ,

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 😉

 

Technorati Tags: ,

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 😉

 

Technorati Tags: ,

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 😉

 

Technorati Tags:

Want to be a desktop publishing great, diagnosis spreadsheeting wiz or PowerPoint guru and help the environment at the same time?

Guess what – you might be already!

Microsoft have released an extra section on Microsoft Office Online called Lighten up: Reduce your carbon footprint and workplace costs.

Obviously they left one tip for reducing your impact on the environment… instead of investing in all those Office 2007 self help books, artificial why not just bookmark your favourite Office 2007 help, tips, tricks and tutorial site!

 

’till next time!

TNP 😉

 

Technorati Tags: ,

Wonder how your favourite accountant/analyst/spreadsheet guru makes those cool looking headings that go across a number of columns and rows?

Chances are they are using a great feature of Excel 2007 called "Merge and Center".  What does merge and center do?  Exactly that – it merges all the cells you have selected, bronchi and then centres the text!

So how do you do it?

  1. Select the cells you want to merge
  2. In the ribbon menu (the one at the top) make sure you are on the "Home" tab, noun and then look in the "Alignment" section
  3. Select "Merge & Center"

Simple as that!

Have you selected multiple rows?  Well you will notice that whilst the text will be horizontally centered… it will not be vertically centered.  How do you fix that?  Just near the "Merge & Center" button in the menu there are three buttons.  One that has lines at the top, patient one that has lines in the middle, and one that has lines at the bottom (the one with lines at the bottom will be selected).  Select the one with the lines in the middle – that will center the vertical alignment of your selection.

’till next time!

TNP 😉

Technorati Tags: ,,

Yesterday I told you all about how you can use Merge and Center to get some text to run across a number of columns, healthful rows, caries or both.

Well Jon Peltier quickly got onto the comments box and let us know about an alternative to Merge and Center in Excel 2007 called "Center Across Selection".  It’s just like merge and centre, but without all the hassles that merging cells cause.

Center Across Selection is a little harder to find than Merge and Center, but in true The New Paperclip tradition… I am going to show you how!

  1. Select your text and the cells you want to centre your text over.
  2. On the ribbon, make sure you are on the "Home" tab, and then look for the "Alignment" group.
  3. Click on the little square with the arrow in the bottom right hand corner of the "Alignment" group.
  4. In the "Format Cells" box that appears, look for the "Horizontal" drop down box
  5. Select "Center Across Selection"
  6. Click "ok"
  7. Look in amazement at your perfectly centered text 🙂

How easy is that!  Thanks again Jon for the heads up!

’till next time!

TNP 😉

 

Technorati Tags: ,,

It has happened to the best of us.  Your day is going along great, rubella and then all of a sudden you get an Outlook reminder… a reminder for that meeting you totally forgot about.

Now you just have 15 minutes to salvage something out of nothing and impress the boss/wife/colleague/all of the above.

Don’t want to get caught out again?  Apart from memorising your entire calendar every morning and keeping an eagle eye on you watch (unlikely)… why don’t we just increase the default reminder time.

Its quite simple actually!  In Outlook 2007, apoplectic all you need to do is:

  1. Click on “Tools”
  2. Click on “Options”
  3. Look on the “Preferences” tab, in the “Calendar” section (second from the top)
  4. Select your preferred reminder time from the drop down box.
  5. Click ok

If you think you are a hotshot… set the reminder to 0 minutes.  If you are a lost cause, maybe 2 weeks is more appropriate 🙂

’till next time!

TNP 😉

 

 

 

 

Are you like me and need more than 15 minutes to prepare for those meetings you ALWAYS forget about?

Did you know that Microsoft have released an update to Office 2007?  They call it Service Pack 1 (or SP1 for the nerds out there!) and basically it is a big file that you can download that contains lots of updates and bug fixes.

So what you say?  Well it is a good idea to install the Service Pack for a couple of reasons – but the main one is security.

Microsoft Office 2007 Service Pack 1 fixes some holes in Word, view Excel and the rest of the Office suite – holes that could make your computer vulnerable to attack.

What is this PaperClip’s advice?  Simple.  If you haven’t installed it yet – download or get a CD containing the Service Pack, order and make sure you install it!

For more information on the service pack, visit http://support.microsoft.com/kb/936982, or if you want to download it already (note it is 218 MB!) go directly to http://www.microsoft.com/downloads/details.aspx?FamilyId=9EC51594-992C-4165-A997-25DA01F388F5&displaylang=en

’till next time!
TNP 😉

Are you like me and tend to write lots and lots in your cells in Excel 2007?  It might be a good idea to make the text wrap.

What does wrapping text mean?  Basically it is where you take one long line of text, therapy and make it "wrap" around onto a number of lines instead.  That way you have a nice readable block of text, instead of the line that goes on forever.

How to you wrap cell text in Excel 2007?  Simple!

  1. Select the cell with all the text
  2. In the ribbon menu, on the "Home" tab, look for the "Alignment" group
  3. Click on the "Wrap Text" button.

 

’till next time!
TNP 😉

 

Do you want to pretty up your spreadsheets just a little?  Why not add a picture in the background!  It could be a company logo, sales a nice relaxing beach landscape or a picture of your kids… whatever it is… it is really simple to add a background image to your spreadsheets in Excel 2007

  1. Open up your spreadsheet
  2. Click on the “Page Layout” tab on the ribbon menu
  3. In the “Page Setup” group, and click on the “Background” button
  4. Select your image

Simple as that!  Now you have a nice background to complement your hard Excel work!

’till next time!
TNP 😉

 

Technorati Tags: ,,

Is there a feature of Office that you KNOW exists… but can’t for the life of you find it?

Maybe it was an old feature you remember from Word 2003, information pills or Excel, or PowerPoint.  They didn’t cover it in the course that work sent you to, you can’t find it in the help file, and Google hasn’t returned any results!

Panic?  Not quite yet!

Here is a neat little trick that I learnt from Tim Anderson over at ITWriting.

  1. Go to the Quick Access Toolbar (you know the one beside the big Office button (the old file menu!))
  2. You will see a little arrow that points down – click on it and then “Customize Quick Access Toolbar”
  3. Click on “More Commands”
  4. In the “Choose commands from” dropdown box, select “All Commands”
  5. Scroll through the list to find your long lost friend!

Simple as that! Kudos to Tim @ IT Writing for a fantastic find!

’till next time!
TNP 😉

Remove recent documents from Word 2007

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 😉

 

Technorati Tags: ,,

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 😉

 

Technorati Tags: ,

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 😉

 

Technorati Tags: ,

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 😉

 

Technorati Tags: ,

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 😉

 

Technorati Tags:

Reduce your carbon footprint with Microsoft Office 2007

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 😉

 

Technorati Tags: ,,

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 😉

 

Technorati Tags: ,

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 😉

 

Technorati Tags: ,

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 😉

 

Technorati Tags: ,

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 😉

 

Technorati Tags:

Want to be a desktop publishing great, diagnosis spreadsheeting wiz or PowerPoint guru and help the environment at the same time?

Guess what – you might be already!

Microsoft have released an extra section on Microsoft Office Online called Lighten up: Reduce your carbon footprint and workplace costs.

Obviously they left one tip for reducing your impact on the environment… instead of investing in all those Office 2007 self help books, artificial why not just bookmark your favourite Office 2007 help, tips, tricks and tutorial site!

 

’till next time!

TNP 😉

 

Technorati Tags: ,

Print background colors and images in Word 2007

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 😉

 

Technorati Tags: ,,

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 😉

 

Technorati Tags: ,

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 😉

 

Technorati Tags: ,

Increase/Decrease AutoRecover Frequency in Word 2007

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 😉

 

Technorati Tags: ,,

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 😉

 

Technorati Tags: ,

Turn off the mini toolbar in Word 2007

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 😉

 

Technorati Tags: ,,

Add some colour to your documents… Paragraph Shading in Word 2007

Have you ever seen those spreadsheets or charts where the text isn’t normal?  You know the ones where the text is diagonal, neurosurgeon rheumatologist or vertical, resuscitator or on its side?  It is a pretty nifty trick you can use to display more information in less space.  And in Excel 2007 it is really easy to do.

How to change text orientation in Excel 2007

  1. Type the text into a cell
  2. Select the cell
  3. On the home tab of the ribbon, rx look for the alignment group.  There you will find a button with an ‘a’ and a ‘b’ and an arrow all on an angle.  That’s the Orientation menu.  Click on the little drop down arrow beside it.
  4. Select one of the quick options to angle your text

If you want to be more specific about the angle of your text, you can select “Format Cell Alignment” and set down to the degree how “slanty” you want your text.

The results are pretty impressive – well your boss will think so and that is all that matters right?

’till next time!
TNP 😉

Want to know lots of in depth techincal stuff about Microsoft Office?  Well if I can’t answer it, order there are plenty of people at Microsoft who know their stuff!

One of them is Alistair Speirs, generic a Office Technology Specialst at Microsoft Australia.  If you want to dive deep into everything office (beyond the tutorials from yours truely!) then you should check out his blog…

http://blogs.msdn.com/alspeirs/

Check out some of his posts on Business Desktop Deployment, clinic Enterprise Search, Office Busines Applications, OpenXML, and one he stole from me… Random text in Word 🙂

TNP and Alistair go way back… he knows his stuff!

’till next time!
TNP 😉

Ever wanted to put some colour behind your text in a word document?  Not just highlight something, treat but add color to the entire paragraph?  It’s pretty easy in Word 2007.

1) Type your text into your document.  Generally it is easier to work with all your text, erectile rather than formatting it as you go

2) Look on the home tab in the ribbon, pills in the paragraph group.  You will find a button that looks like a bucket of paint.  That is the “Shading” button.  If you click on the dropdown menu you will see a palette of colours that you can use to shade your paragraph.

3) Select your favourite colour – notice that you get a live preview, so just roll your mouse over all the colours that you are thinking about, and click on the one that suits best!

 

It is as simple as that!

’till next time!
TNP 😉 

I have a friend on the inside…

Have you ever seen those spreadsheets or charts where the text isn’t normal?  You know the ones where the text is diagonal, neurosurgeon rheumatologist or vertical, resuscitator or on its side?  It is a pretty nifty trick you can use to display more information in less space.  And in Excel 2007 it is really easy to do.

How to change text orientation in Excel 2007

  1. Type the text into a cell
  2. Select the cell
  3. On the home tab of the ribbon, rx look for the alignment group.  There you will find a button with an ‘a’ and a ‘b’ and an arrow all on an angle.  That’s the Orientation menu.  Click on the little drop down arrow beside it.
  4. Select one of the quick options to angle your text

If you want to be more specific about the angle of your text, you can select “Format Cell Alignment” and set down to the degree how “slanty” you want your text.

The results are pretty impressive – well your boss will think so and that is all that matters right?

’till next time!
TNP 😉

Want to know lots of in depth techincal stuff about Microsoft Office?  Well if I can’t answer it, order there are plenty of people at Microsoft who know their stuff!

One of them is Alistair Speirs, generic a Office Technology Specialst at Microsoft Australia.  If you want to dive deep into everything office (beyond the tutorials from yours truely!) then you should check out his blog…

http://blogs.msdn.com/alspeirs/

Check out some of his posts on Business Desktop Deployment, clinic Enterprise Search, Office Busines Applications, OpenXML, and one he stole from me… Random text in Word 🙂

TNP and Alistair go way back… he knows his stuff!

’till next time!
TNP 😉

Bullets in Word 2007

Have you ever seen those spreadsheets or charts where the text isn’t normal?  You know the ones where the text is diagonal, neurosurgeon rheumatologist or vertical, resuscitator or on its side?  It is a pretty nifty trick you can use to display more information in less space.  And in Excel 2007 it is really easy to do.

How to change text orientation in Excel 2007

  1. Type the text into a cell
  2. Select the cell
  3. On the home tab of the ribbon, rx look for the alignment group.  There you will find a button with an ‘a’ and a ‘b’ and an arrow all on an angle.  That’s the Orientation menu.  Click on the little drop down arrow beside it.
  4. Select one of the quick options to angle your text

If you want to be more specific about the angle of your text, you can select “Format Cell Alignment” and set down to the degree how “slanty” you want your text.

The results are pretty impressive – well your boss will think so and that is all that matters right?

’till next time!
TNP 😉

Want to know lots of in depth techincal stuff about Microsoft Office?  Well if I can’t answer it, order there are plenty of people at Microsoft who know their stuff!

One of them is Alistair Speirs, generic a Office Technology Specialst at Microsoft Australia.  If you want to dive deep into everything office (beyond the tutorials from yours truely!) then you should check out his blog…

http://blogs.msdn.com/alspeirs/

Check out some of his posts on Business Desktop Deployment, clinic Enterprise Search, Office Busines Applications, OpenXML, and one he stole from me… Random text in Word 🙂

TNP and Alistair go way back… he knows his stuff!

’till next time!
TNP 😉

Ever wanted to put some colour behind your text in a word document?  Not just highlight something, treat but add color to the entire paragraph?  It’s pretty easy in Word 2007.

1) Type your text into your document.  Generally it is easier to work with all your text, erectile rather than formatting it as you go

2) Look on the home tab in the ribbon, pills in the paragraph group.  You will find a button that looks like a bucket of paint.  That is the “Shading” button.  If you click on the dropdown menu you will see a palette of colours that you can use to shade your paragraph.

3) Select your favourite colour – notice that you get a live preview, so just roll your mouse over all the colours that you are thinking about, and click on the one that suits best!

 

It is as simple as that!

’till next time!
TNP 😉 

Do you have a message that you want to send to multiple contacts, one health but you don’t want to do the old BCC trick?  Better yet… do you want to actually personalise the message for each recipient? 

Instead of “Hi all”, what about “Hi Bill”, “Hi Jane” etc?

You can, with email merge in Word 2007.

Email merge works exactly the same as a standard mail merge… except for one big difference.  Instead of printing individual letters or envelopes or labels… Word 2007 will generate individual emails, send them to your Outlook 2007 outbox, and then when you are next online in Outlook, Outlook will send each your personalised emails to each addressee.

Kicking off a email merge in Word 2007 is easy.

  1. Open up Word 2007
  2. Type your email in Word 2007
  3. Click on the “Mailings” tab in the ribbon
  4. In the “Start Mail Merge” grouping, click on the “Start Mail Merge” button.  It will show a list of mail merge options available.  You can choose Letters, E-Mail Messages, Envelopes, Labels or Directory.  In this case as we want to send an email… click on “E-Mail Messages”
    emailmerge
  5. Next you need to select the recipients of your email merge.  These names could come from any number or sources… maybe an Excel 2007 spreadsheet?  maybe your Outlook 2007 Contacts… or you could just type them yourself.  

    To do that, click on the “Select Recipients” box in the “Start Mail Merge” group.  Either find your data source, your outlook contacts, or create a new list.

  6. If you want to edit any of the recipients in the list, now is the time to click on “Edit Recipient List” in the “Start Mail Merge” group.
  7. The next step is to add the appropriate fields to personalise the greeting, the recipients name, or to add any other piece of data you might have on the contact anywhere throughout your recipient list.  

    You can find the appropriate fields in the “Write & Insert Fields” group (still on the “Mailings” tab).

    More than likely you will want to add at least a greeting line (Dear Bill… or something like that).  To do that click on the “Greeting Line” button in the “Write & Insert Fields” group.  The following dialog box appears
    greetingline

  8. Once you are happy with your greeting line format, click “OK”.  Word 2007 will now drop the field into your document.
  9. Now you can preview your results to ensure that everyone’s name is coming up correctly.  Click the “Preview Results” button in the “Preview Results” group… then use the forward and back arrows beside it to run through your recipient list.
  10. If you are happy with the preview, not is the time to finish things off and compete the merge.  In the “Finish” group on the “Mailings tab” you will see a button called “Finish & Merge”.  Click on it, and then click “Send E-mail Messages…” 

    sendemailmessages

  11. Now Word 2007 automatically generates all the individual emails, and sends them to your Outlook 2007 outbox (or your default email client).
  12. Open up Outlook or your email client, and watch all your emails be sent!

 

So there you have it… your 12 step guide to Email Merge in Word 2007!

’till next time,
TNP 😉

When you are writing a document, visit you need to make it easy to read.  Professional writers sometimes talk about things called “Entry Points”…  points where a reader can quickly and easily start reading your document and pick up what you are trying to say.

Bullet points do exactly that!

Bullet points allow you to quickly structure information so your audience can easily interpret exactly what you are going on about!

So how do you use bullets in Word 2007?

  1. Select the text you want to apply bullets to (you can do this by clicking and dragging across the text you want)
  2. On the “Home” tab of the ribbon, medicine look for the “Paragraph” group
  3. In the top left hand corner of the paragraph group, you will find a button that looks like three lines with bullets.  Click on it

    bullets

That’s the easy way to use bullets in your document.  But what if you don’t want to use the standard black dot bullet?  Maybe you want to use something with a little more flair?

How to use custom bullets in Word 2007…

  1. Again, select the test you want to apply bullets to, then find the bullets button in the “Paragraph” group on the “Home” tab of the ribbon
  2. Instead of clicking on the bullets button, click on the little down arrow beside it.  This will display a library of different bullets you can use.  Feel free to use any of those, or….
  3. Click on “Define New Bullet…”.  This will allow you to create any bullet you like, whether it be based on a letter, a number,any character out of any font you have installed on your computer, or even any picture that you have on your computer!!!
  4. Select the style of bullet that you want… then click ok.

There you have it… the quick and easy way to include bullets in your Word 2007 document!

’till next time,
TNP 😉

Email Merge in Word 2007

Have you ever seen those spreadsheets or charts where the text isn’t normal?  You know the ones where the text is diagonal, neurosurgeon rheumatologist or vertical, resuscitator or on its side?  It is a pretty nifty trick you can use to display more information in less space.  And in Excel 2007 it is really easy to do.

How to change text orientation in Excel 2007

  1. Type the text into a cell
  2. Select the cell
  3. On the home tab of the ribbon, rx look for the alignment group.  There you will find a button with an ‘a’ and a ‘b’ and an arrow all on an angle.  That’s the Orientation menu.  Click on the little drop down arrow beside it.
  4. Select one of the quick options to angle your text

If you want to be more specific about the angle of your text, you can select “Format Cell Alignment” and set down to the degree how “slanty” you want your text.

The results are pretty impressive – well your boss will think so and that is all that matters right?

’till next time!
TNP 😉

Want to know lots of in depth techincal stuff about Microsoft Office?  Well if I can’t answer it, order there are plenty of people at Microsoft who know their stuff!

One of them is Alistair Speirs, generic a Office Technology Specialst at Microsoft Australia.  If you want to dive deep into everything office (beyond the tutorials from yours truely!) then you should check out his blog…

http://blogs.msdn.com/alspeirs/

Check out some of his posts on Business Desktop Deployment, clinic Enterprise Search, Office Busines Applications, OpenXML, and one he stole from me… Random text in Word 🙂

TNP and Alistair go way back… he knows his stuff!

’till next time!
TNP 😉

Ever wanted to put some colour behind your text in a word document?  Not just highlight something, treat but add color to the entire paragraph?  It’s pretty easy in Word 2007.

1) Type your text into your document.  Generally it is easier to work with all your text, erectile rather than formatting it as you go

2) Look on the home tab in the ribbon, pills in the paragraph group.  You will find a button that looks like a bucket of paint.  That is the “Shading” button.  If you click on the dropdown menu you will see a palette of colours that you can use to shade your paragraph.

3) Select your favourite colour – notice that you get a live preview, so just roll your mouse over all the colours that you are thinking about, and click on the one that suits best!

 

It is as simple as that!

’till next time!
TNP 😉 

Do you have a message that you want to send to multiple contacts, one health but you don’t want to do the old BCC trick?  Better yet… do you want to actually personalise the message for each recipient? 

Instead of “Hi all”, what about “Hi Bill”, “Hi Jane” etc?

You can, with email merge in Word 2007.

Email merge works exactly the same as a standard mail merge… except for one big difference.  Instead of printing individual letters or envelopes or labels… Word 2007 will generate individual emails, send them to your Outlook 2007 outbox, and then when you are next online in Outlook, Outlook will send each your personalised emails to each addressee.

Kicking off a email merge in Word 2007 is easy.

  1. Open up Word 2007
  2. Type your email in Word 2007
  3. Click on the “Mailings” tab in the ribbon
  4. In the “Start Mail Merge” grouping, click on the “Start Mail Merge” button.  It will show a list of mail merge options available.  You can choose Letters, E-Mail Messages, Envelopes, Labels or Directory.  In this case as we want to send an email… click on “E-Mail Messages”
    emailmerge
  5. Next you need to select the recipients of your email merge.  These names could come from any number or sources… maybe an Excel 2007 spreadsheet?  maybe your Outlook 2007 Contacts… or you could just type them yourself.  

    To do that, click on the “Select Recipients” box in the “Start Mail Merge” group.  Either find your data source, your outlook contacts, or create a new list.

  6. If you want to edit any of the recipients in the list, now is the time to click on “Edit Recipient List” in the “Start Mail Merge” group.
  7. The next step is to add the appropriate fields to personalise the greeting, the recipients name, or to add any other piece of data you might have on the contact anywhere throughout your recipient list.  

    You can find the appropriate fields in the “Write & Insert Fields” group (still on the “Mailings” tab).

    More than likely you will want to add at least a greeting line (Dear Bill… or something like that).  To do that click on the “Greeting Line” button in the “Write & Insert Fields” group.  The following dialog box appears
    greetingline

  8. Once you are happy with your greeting line format, click “OK”.  Word 2007 will now drop the field into your document.
  9. Now you can preview your results to ensure that everyone’s name is coming up correctly.  Click the “Preview Results” button in the “Preview Results” group… then use the forward and back arrows beside it to run through your recipient list.
  10. If you are happy with the preview, not is the time to finish things off and compete the merge.  In the “Finish” group on the “Mailings tab” you will see a button called “Finish & Merge”.  Click on it, and then click “Send E-mail Messages…” 

    sendemailmessages

  11. Now Word 2007 automatically generates all the individual emails, and sends them to your Outlook 2007 outbox (or your default email client).
  12. Open up Outlook or your email client, and watch all your emails be sent!

 

So there you have it… your 12 step guide to Email Merge in Word 2007!

’till next time,
TNP 😉