Top 10 Questions about Word 2007

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

In this weeks edition of TheNewPaperclip.com’s Office 2007 newsletter, drug
we focused on a few articles that could help you get a big productivity boost in 2009.

Here are a few to get you thinking about how you can be that 10% better in the new year!

 

Create your 2009 Calendar with Word 2007

So, malady
the new year is just a few hours away… time to crack open the calendars your relatives gave you for Christmas right!

But what if you didn’t get any?

>> read more

 

Organise your Inbox with Outlook 2007

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, what is ed
you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

>> read more

 

Follow up Flags and the Default Reminder in Outlook 2007

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am)

>> read more

 

How to find any Office 2007 Command you Want!

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, 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!

>> read more

Do you have an Office 2007 Productivity Tip?  Email office2007tips@thenewpaperclip.com and let me know – and you could share the limelight as I will share the best in the next edition of the newsletter!

’till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

In this weeks edition of TheNewPaperclip.com’s Office 2007 newsletter, drug
we focused on a few articles that could help you get a big productivity boost in 2009.

Here are a few to get you thinking about how you can be that 10% better in the new year!

 

Create your 2009 Calendar with Word 2007

So, malady
the new year is just a few hours away… time to crack open the calendars your relatives gave you for Christmas right!

But what if you didn’t get any?

>> read more

 

Organise your Inbox with Outlook 2007

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, what is ed
you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

>> read more

 

Follow up Flags and the Default Reminder in Outlook 2007

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am)

>> read more

 

How to find any Office 2007 Command you Want!

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, 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!

>> read more

Do you have an Office 2007 Productivity Tip?  Email office2007tips@thenewpaperclip.com and let me know – and you could share the limelight as I will share the best in the next edition of the newsletter!

’till next time!
TNP 😉

They have been closed for a while now, hospital
but today I am re-launching The New Paperclip’s Office 2007 Forums!

What does that mean?  If you have any question at all about Office 2007, whether it is Word, Excel, PowerPoint, Outlook, Access or even SharePoint Designer… you now have a place where you can look for answers.

I will be there frequently, and we will be able to draw on the collective knowledge of the community to get your question answered!

Here are the links to each of the forums:

 

 

So there you have it – the quick and easy way to get your Office 2007 question answered!  See you on the forums!

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

In this weeks edition of TheNewPaperclip.com’s Office 2007 newsletter, drug
we focused on a few articles that could help you get a big productivity boost in 2009.

Here are a few to get you thinking about how you can be that 10% better in the new year!

 

Create your 2009 Calendar with Word 2007

So, malady
the new year is just a few hours away… time to crack open the calendars your relatives gave you for Christmas right!

But what if you didn’t get any?

>> read more

 

Organise your Inbox with Outlook 2007

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, what is ed
you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

>> read more

 

Follow up Flags and the Default Reminder in Outlook 2007

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am)

>> read more

 

How to find any Office 2007 Command you Want!

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, 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!

>> read more

Do you have an Office 2007 Productivity Tip?  Email office2007tips@thenewpaperclip.com and let me know – and you could share the limelight as I will share the best in the next edition of the newsletter!

’till next time!
TNP 😉

They have been closed for a while now, hospital
but today I am re-launching The New Paperclip’s Office 2007 Forums!

What does that mean?  If you have any question at all about Office 2007, whether it is Word, Excel, PowerPoint, Outlook, Access or even SharePoint Designer… you now have a place where you can look for answers.

I will be there frequently, and we will be able to draw on the collective knowledge of the community to get your question answered!

Here are the links to each of the forums:

 

 

So there you have it – the quick and easy way to get your Office 2007 question answered!  See you on the forums!

‘till next time!
TNP 😉

So are you comfortable with the basics of Office 2007, sanitary
and want to go a little deeper?  Maybe you want to build your knowledge around one particular product?  Maybe you just want something interesting to read!

If you are into Office 2007, viagra
you might not know it, pulmonologist
but The New Paperclip is not your only option (if you thought it was, I am very flattered though!).  There are plenty of quality resources out there that you can leverage to make you far more productive using Word, PowerPoint, Excel, Outlook or the rest of the suite.

Here are a few places you should look…

Number 1: Alltop’s Top Microsoft Office News – [http://microsoft-office.alltop.com/]

This is a great resource if you want to keep your finger on the pulse of everything happening with Microsoft Office.  This one page displays all the news from 30 or so of the web’s leading Microsoft Office sites, which means you can quickly get up to speed on exactly what the ‘blogosphere’ is thinking about when it comes to Office.

You can also read the latest AllTop Microsoft Office news simply by watching out for the AllTop section to the right of this article – it gets updated every hour!

Number 2: Inside Office Online – [http://blogs.msdn.com/inside_office_online/]

This blog is run by the folks who run Microsoft’s own Office help site – Office Online.  Great to get their perspective on what new and exciting things are happening in the world of Microsoft Office.

Number 3: The blogs of all the Office teams at Microsoft

There is nothing better than getting it from the horse’s mouth right!  These blogs are run by the folk who actually build the products in Office, so they are filled with interesting stories, tips, and tricks that will help you become more productive with Office 2007

 

There are literally hundreds of other resources out there that you could find, and the ones I have listed in this article would be a great place to start… well, of course after you have read all the articles on The New Paperclip!

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

In this weeks edition of TheNewPaperclip.com’s Office 2007 newsletter, drug
we focused on a few articles that could help you get a big productivity boost in 2009.

Here are a few to get you thinking about how you can be that 10% better in the new year!

 

Create your 2009 Calendar with Word 2007

So, malady
the new year is just a few hours away… time to crack open the calendars your relatives gave you for Christmas right!

But what if you didn’t get any?

>> read more

 

Organise your Inbox with Outlook 2007

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, what is ed
you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

>> read more

 

Follow up Flags and the Default Reminder in Outlook 2007

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am)

>> read more

 

How to find any Office 2007 Command you Want!

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, 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!

>> read more

Do you have an Office 2007 Productivity Tip?  Email office2007tips@thenewpaperclip.com and let me know – and you could share the limelight as I will share the best in the next edition of the newsletter!

’till next time!
TNP 😉

They have been closed for a while now, hospital
but today I am re-launching The New Paperclip’s Office 2007 Forums!

What does that mean?  If you have any question at all about Office 2007, whether it is Word, Excel, PowerPoint, Outlook, Access or even SharePoint Designer… you now have a place where you can look for answers.

I will be there frequently, and we will be able to draw on the collective knowledge of the community to get your question answered!

Here are the links to each of the forums:

 

 

So there you have it – the quick and easy way to get your Office 2007 question answered!  See you on the forums!

‘till next time!
TNP 😉

So are you comfortable with the basics of Office 2007, sanitary
and want to go a little deeper?  Maybe you want to build your knowledge around one particular product?  Maybe you just want something interesting to read!

If you are into Office 2007, viagra
you might not know it, pulmonologist
but The New Paperclip is not your only option (if you thought it was, I am very flattered though!).  There are plenty of quality resources out there that you can leverage to make you far more productive using Word, PowerPoint, Excel, Outlook or the rest of the suite.

Here are a few places you should look…

Number 1: Alltop’s Top Microsoft Office News – [http://microsoft-office.alltop.com/]

This is a great resource if you want to keep your finger on the pulse of everything happening with Microsoft Office.  This one page displays all the news from 30 or so of the web’s leading Microsoft Office sites, which means you can quickly get up to speed on exactly what the ‘blogosphere’ is thinking about when it comes to Office.

You can also read the latest AllTop Microsoft Office news simply by watching out for the AllTop section to the right of this article – it gets updated every hour!

Number 2: Inside Office Online – [http://blogs.msdn.com/inside_office_online/]

This blog is run by the folks who run Microsoft’s own Office help site – Office Online.  Great to get their perspective on what new and exciting things are happening in the world of Microsoft Office.

Number 3: The blogs of all the Office teams at Microsoft

There is nothing better than getting it from the horse’s mouth right!  These blogs are run by the folk who actually build the products in Office, so they are filled with interesting stories, tips, and tricks that will help you become more productive with Office 2007

 

There are literally hundreds of other resources out there that you could find, and the ones I have listed in this article would be a great place to start… well, of course after you have read all the articles on The New Paperclip!

‘till next time!
TNP 😉

Has this ever happened to you?

You morning starts off great.  You beat all the traffic, here
get into the office precisely at the time you are supposed to start, ailment and enjoy the best cup of coffee you have had in months.

You open up Outlook, and put that appointment in your calendar that you had thought of on the way into office.

But then something horrific happens.  When you go to check your email, there is a new meeting request in there – for the exact same time you just set the appointment in your calendar.  What are you to do????

Ok… I might be getting a little dramatic here, but this has happened to me a couple of times over the last few months – and today thanks to my friend Alistair Speirs (Australia’s premier Microsoft Office Client Technology Specialist – try Googling/Live Searching that now Al!), I have found a way to avoid this exact situation in the future.

There is a command line switch for Outlook 2007 which will start Outlook, force detection of all the new meeting requests that people sneakily invited you too overnight, and push them straight into your calendar before you get a chance to look at it.

The outcome being that you have a clear and accurate picture of how your time will be used today – before you start digging into your email.

And the best part is, the switch has a cool name… /sniff

For those that don’t know how to use switches, my advice would be to visit the Microsoft Office Online page that talks about Command-line switches for Microsoft Office Outlook 2007.

And if you want to take a look at some other switches that will make you more productive – check out the original post on Alistair’s blog.

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

In this weeks edition of TheNewPaperclip.com’s Office 2007 newsletter, drug
we focused on a few articles that could help you get a big productivity boost in 2009.

Here are a few to get you thinking about how you can be that 10% better in the new year!

 

Create your 2009 Calendar with Word 2007

So, malady
the new year is just a few hours away… time to crack open the calendars your relatives gave you for Christmas right!

But what if you didn’t get any?

>> read more

 

Organise your Inbox with Outlook 2007

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, what is ed
you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

>> read more

 

Follow up Flags and the Default Reminder in Outlook 2007

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am)

>> read more

 

How to find any Office 2007 Command you Want!

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, 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!

>> read more

Do you have an Office 2007 Productivity Tip?  Email office2007tips@thenewpaperclip.com and let me know – and you could share the limelight as I will share the best in the next edition of the newsletter!

’till next time!
TNP 😉

They have been closed for a while now, hospital
but today I am re-launching The New Paperclip’s Office 2007 Forums!

What does that mean?  If you have any question at all about Office 2007, whether it is Word, Excel, PowerPoint, Outlook, Access or even SharePoint Designer… you now have a place where you can look for answers.

I will be there frequently, and we will be able to draw on the collective knowledge of the community to get your question answered!

Here are the links to each of the forums:

 

 

So there you have it – the quick and easy way to get your Office 2007 question answered!  See you on the forums!

‘till next time!
TNP 😉

So are you comfortable with the basics of Office 2007, sanitary
and want to go a little deeper?  Maybe you want to build your knowledge around one particular product?  Maybe you just want something interesting to read!

If you are into Office 2007, viagra
you might not know it, pulmonologist
but The New Paperclip is not your only option (if you thought it was, I am very flattered though!).  There are plenty of quality resources out there that you can leverage to make you far more productive using Word, PowerPoint, Excel, Outlook or the rest of the suite.

Here are a few places you should look…

Number 1: Alltop’s Top Microsoft Office News – [http://microsoft-office.alltop.com/]

This is a great resource if you want to keep your finger on the pulse of everything happening with Microsoft Office.  This one page displays all the news from 30 or so of the web’s leading Microsoft Office sites, which means you can quickly get up to speed on exactly what the ‘blogosphere’ is thinking about when it comes to Office.

You can also read the latest AllTop Microsoft Office news simply by watching out for the AllTop section to the right of this article – it gets updated every hour!

Number 2: Inside Office Online – [http://blogs.msdn.com/inside_office_online/]

This blog is run by the folks who run Microsoft’s own Office help site – Office Online.  Great to get their perspective on what new and exciting things are happening in the world of Microsoft Office.

Number 3: The blogs of all the Office teams at Microsoft

There is nothing better than getting it from the horse’s mouth right!  These blogs are run by the folk who actually build the products in Office, so they are filled with interesting stories, tips, and tricks that will help you become more productive with Office 2007

 

There are literally hundreds of other resources out there that you could find, and the ones I have listed in this article would be a great place to start… well, of course after you have read all the articles on The New Paperclip!

‘till next time!
TNP 😉

Has this ever happened to you?

You morning starts off great.  You beat all the traffic, here
get into the office precisely at the time you are supposed to start, ailment and enjoy the best cup of coffee you have had in months.

You open up Outlook, and put that appointment in your calendar that you had thought of on the way into office.

But then something horrific happens.  When you go to check your email, there is a new meeting request in there – for the exact same time you just set the appointment in your calendar.  What are you to do????

Ok… I might be getting a little dramatic here, but this has happened to me a couple of times over the last few months – and today thanks to my friend Alistair Speirs (Australia’s premier Microsoft Office Client Technology Specialist – try Googling/Live Searching that now Al!), I have found a way to avoid this exact situation in the future.

There is a command line switch for Outlook 2007 which will start Outlook, force detection of all the new meeting requests that people sneakily invited you too overnight, and push them straight into your calendar before you get a chance to look at it.

The outcome being that you have a clear and accurate picture of how your time will be used today – before you start digging into your email.

And the best part is, the switch has a cool name… /sniff

For those that don’t know how to use switches, my advice would be to visit the Microsoft Office Online page that talks about Command-line switches for Microsoft Office Outlook 2007.

And if you want to take a look at some other switches that will make you more productive – check out the original post on Alistair’s blog.

‘till next time!
TNP 😉

Are you a sweetheart who wants to create their own valentines day card for someone special but don’t know where to start?

Well over at Office Online, refractionist
you can get Valentine’s Day card templates for Word 2007 which will give you the inspiration you need to show your other half that you really care!

And if you really want to show that you love her/him, internist
why not put together a Valentines Day PowerPoint Deck!  There are a number of Valentine’s Day PowerPoint designs you can use to knock her/him off their feet!

‘till next time lovers!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

In this weeks edition of TheNewPaperclip.com’s Office 2007 newsletter, drug
we focused on a few articles that could help you get a big productivity boost in 2009.

Here are a few to get you thinking about how you can be that 10% better in the new year!

 

Create your 2009 Calendar with Word 2007

So, malady
the new year is just a few hours away… time to crack open the calendars your relatives gave you for Christmas right!

But what if you didn’t get any?

>> read more

 

Organise your Inbox with Outlook 2007

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, what is ed
you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

>> read more

 

Follow up Flags and the Default Reminder in Outlook 2007

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am)

>> read more

 

How to find any Office 2007 Command you Want!

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, 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!

>> read more

Do you have an Office 2007 Productivity Tip?  Email office2007tips@thenewpaperclip.com and let me know – and you could share the limelight as I will share the best in the next edition of the newsletter!

’till next time!
TNP 😉

They have been closed for a while now, hospital
but today I am re-launching The New Paperclip’s Office 2007 Forums!

What does that mean?  If you have any question at all about Office 2007, whether it is Word, Excel, PowerPoint, Outlook, Access or even SharePoint Designer… you now have a place where you can look for answers.

I will be there frequently, and we will be able to draw on the collective knowledge of the community to get your question answered!

Here are the links to each of the forums:

 

 

So there you have it – the quick and easy way to get your Office 2007 question answered!  See you on the forums!

‘till next time!
TNP 😉

So are you comfortable with the basics of Office 2007, sanitary
and want to go a little deeper?  Maybe you want to build your knowledge around one particular product?  Maybe you just want something interesting to read!

If you are into Office 2007, viagra
you might not know it, pulmonologist
but The New Paperclip is not your only option (if you thought it was, I am very flattered though!).  There are plenty of quality resources out there that you can leverage to make you far more productive using Word, PowerPoint, Excel, Outlook or the rest of the suite.

Here are a few places you should look…

Number 1: Alltop’s Top Microsoft Office News – [http://microsoft-office.alltop.com/]

This is a great resource if you want to keep your finger on the pulse of everything happening with Microsoft Office.  This one page displays all the news from 30 or so of the web’s leading Microsoft Office sites, which means you can quickly get up to speed on exactly what the ‘blogosphere’ is thinking about when it comes to Office.

You can also read the latest AllTop Microsoft Office news simply by watching out for the AllTop section to the right of this article – it gets updated every hour!

Number 2: Inside Office Online – [http://blogs.msdn.com/inside_office_online/]

This blog is run by the folks who run Microsoft’s own Office help site – Office Online.  Great to get their perspective on what new and exciting things are happening in the world of Microsoft Office.

Number 3: The blogs of all the Office teams at Microsoft

There is nothing better than getting it from the horse’s mouth right!  These blogs are run by the folk who actually build the products in Office, so they are filled with interesting stories, tips, and tricks that will help you become more productive with Office 2007

 

There are literally hundreds of other resources out there that you could find, and the ones I have listed in this article would be a great place to start… well, of course after you have read all the articles on The New Paperclip!

‘till next time!
TNP 😉

Has this ever happened to you?

You morning starts off great.  You beat all the traffic, here
get into the office precisely at the time you are supposed to start, ailment and enjoy the best cup of coffee you have had in months.

You open up Outlook, and put that appointment in your calendar that you had thought of on the way into office.

But then something horrific happens.  When you go to check your email, there is a new meeting request in there – for the exact same time you just set the appointment in your calendar.  What are you to do????

Ok… I might be getting a little dramatic here, but this has happened to me a couple of times over the last few months – and today thanks to my friend Alistair Speirs (Australia’s premier Microsoft Office Client Technology Specialist – try Googling/Live Searching that now Al!), I have found a way to avoid this exact situation in the future.

There is a command line switch for Outlook 2007 which will start Outlook, force detection of all the new meeting requests that people sneakily invited you too overnight, and push them straight into your calendar before you get a chance to look at it.

The outcome being that you have a clear and accurate picture of how your time will be used today – before you start digging into your email.

And the best part is, the switch has a cool name… /sniff

For those that don’t know how to use switches, my advice would be to visit the Microsoft Office Online page that talks about Command-line switches for Microsoft Office Outlook 2007.

And if you want to take a look at some other switches that will make you more productive – check out the original post on Alistair’s blog.

‘till next time!
TNP 😉

Are you a sweetheart who wants to create their own valentines day card for someone special but don’t know where to start?

Well over at Office Online, refractionist
you can get Valentine’s Day card templates for Word 2007 which will give you the inspiration you need to show your other half that you really care!

And if you really want to show that you love her/him, internist
why not put together a Valentines Day PowerPoint Deck!  There are a number of Valentine’s Day PowerPoint designs you can use to knock her/him off their feet!

‘till next time lovers!
TNP 😉

So… you have spent hours collating your data in Excel 2007.  You have finally got the information where you want it – with sub-totals and all.  You collapse the outline to only show the sub-totals, pharmacist
because that is all you are interested in.  But when you try to copy those subtotals into another spreadsheet, it copies EVERY row, not just the sub-totals.

So how on Earth are you supposed to copy all those sub-totals in Excel 2007 without copying all the ‘hidden’ rows as well?

The problem is that when you select rows using the sub-total outline view, it is selecting every row, not just those sub-totals.  The way to solve this is to only select the visible cells – which means we have to use a feature of Excel called “Go To Special”.  Here is how to do it:

1) Select all your sub-totals that you want to copy

2) On the “Home” tab of the Ribbon, look for the “Editing” group – usually it is the last one, all the way over at the right hand side of the Ribbon.

3) Click on “Find & Select”

4) On the little menu that appears, click “Go To Special”

5) In the box that appears, make sure you select “Visible Cells Only” in the right hand column

6) Click OK

7) Copy using the menu (or ctrl+c) and then paste your sub-totals in your new spreadsheet

You can stop pulling your hair out now!

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

In this weeks edition of TheNewPaperclip.com’s Office 2007 newsletter, drug
we focused on a few articles that could help you get a big productivity boost in 2009.

Here are a few to get you thinking about how you can be that 10% better in the new year!

 

Create your 2009 Calendar with Word 2007

So, malady
the new year is just a few hours away… time to crack open the calendars your relatives gave you for Christmas right!

But what if you didn’t get any?

>> read more

 

Organise your Inbox with Outlook 2007

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, what is ed
you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

>> read more

 

Follow up Flags and the Default Reminder in Outlook 2007

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am)

>> read more

 

How to find any Office 2007 Command you Want!

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, 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!

>> read more

Do you have an Office 2007 Productivity Tip?  Email office2007tips@thenewpaperclip.com and let me know – and you could share the limelight as I will share the best in the next edition of the newsletter!

’till next time!
TNP 😉

They have been closed for a while now, hospital
but today I am re-launching The New Paperclip’s Office 2007 Forums!

What does that mean?  If you have any question at all about Office 2007, whether it is Word, Excel, PowerPoint, Outlook, Access or even SharePoint Designer… you now have a place where you can look for answers.

I will be there frequently, and we will be able to draw on the collective knowledge of the community to get your question answered!

Here are the links to each of the forums:

 

 

So there you have it – the quick and easy way to get your Office 2007 question answered!  See you on the forums!

‘till next time!
TNP 😉

So are you comfortable with the basics of Office 2007, sanitary
and want to go a little deeper?  Maybe you want to build your knowledge around one particular product?  Maybe you just want something interesting to read!

If you are into Office 2007, viagra
you might not know it, pulmonologist
but The New Paperclip is not your only option (if you thought it was, I am very flattered though!).  There are plenty of quality resources out there that you can leverage to make you far more productive using Word, PowerPoint, Excel, Outlook or the rest of the suite.

Here are a few places you should look…

Number 1: Alltop’s Top Microsoft Office News – [http://microsoft-office.alltop.com/]

This is a great resource if you want to keep your finger on the pulse of everything happening with Microsoft Office.  This one page displays all the news from 30 or so of the web’s leading Microsoft Office sites, which means you can quickly get up to speed on exactly what the ‘blogosphere’ is thinking about when it comes to Office.

You can also read the latest AllTop Microsoft Office news simply by watching out for the AllTop section to the right of this article – it gets updated every hour!

Number 2: Inside Office Online – [http://blogs.msdn.com/inside_office_online/]

This blog is run by the folks who run Microsoft’s own Office help site – Office Online.  Great to get their perspective on what new and exciting things are happening in the world of Microsoft Office.

Number 3: The blogs of all the Office teams at Microsoft

There is nothing better than getting it from the horse’s mouth right!  These blogs are run by the folk who actually build the products in Office, so they are filled with interesting stories, tips, and tricks that will help you become more productive with Office 2007

 

There are literally hundreds of other resources out there that you could find, and the ones I have listed in this article would be a great place to start… well, of course after you have read all the articles on The New Paperclip!

‘till next time!
TNP 😉

Has this ever happened to you?

You morning starts off great.  You beat all the traffic, here
get into the office precisely at the time you are supposed to start, ailment and enjoy the best cup of coffee you have had in months.

You open up Outlook, and put that appointment in your calendar that you had thought of on the way into office.

But then something horrific happens.  When you go to check your email, there is a new meeting request in there – for the exact same time you just set the appointment in your calendar.  What are you to do????

Ok… I might be getting a little dramatic here, but this has happened to me a couple of times over the last few months – and today thanks to my friend Alistair Speirs (Australia’s premier Microsoft Office Client Technology Specialist – try Googling/Live Searching that now Al!), I have found a way to avoid this exact situation in the future.

There is a command line switch for Outlook 2007 which will start Outlook, force detection of all the new meeting requests that people sneakily invited you too overnight, and push them straight into your calendar before you get a chance to look at it.

The outcome being that you have a clear and accurate picture of how your time will be used today – before you start digging into your email.

And the best part is, the switch has a cool name… /sniff

For those that don’t know how to use switches, my advice would be to visit the Microsoft Office Online page that talks about Command-line switches for Microsoft Office Outlook 2007.

And if you want to take a look at some other switches that will make you more productive – check out the original post on Alistair’s blog.

‘till next time!
TNP 😉

Are you a sweetheart who wants to create their own valentines day card for someone special but don’t know where to start?

Well over at Office Online, refractionist
you can get Valentine’s Day card templates for Word 2007 which will give you the inspiration you need to show your other half that you really care!

And if you really want to show that you love her/him, internist
why not put together a Valentines Day PowerPoint Deck!  There are a number of Valentine’s Day PowerPoint designs you can use to knock her/him off their feet!

‘till next time lovers!
TNP 😉

So… you have spent hours collating your data in Excel 2007.  You have finally got the information where you want it – with sub-totals and all.  You collapse the outline to only show the sub-totals, pharmacist
because that is all you are interested in.  But when you try to copy those subtotals into another spreadsheet, it copies EVERY row, not just the sub-totals.

So how on Earth are you supposed to copy all those sub-totals in Excel 2007 without copying all the ‘hidden’ rows as well?

The problem is that when you select rows using the sub-total outline view, it is selecting every row, not just those sub-totals.  The way to solve this is to only select the visible cells – which means we have to use a feature of Excel called “Go To Special”.  Here is how to do it:

1) Select all your sub-totals that you want to copy

2) On the “Home” tab of the Ribbon, look for the “Editing” group – usually it is the last one, all the way over at the right hand side of the Ribbon.

3) Click on “Find & Select”

4) On the little menu that appears, click “Go To Special”

5) In the box that appears, make sure you select “Visible Cells Only” in the right hand column

6) Click OK

7) Copy using the menu (or ctrl+c) and then paste your sub-totals in your new spreadsheet

You can stop pulling your hair out now!

‘till next time!
TNP 😉

Are you new, public health
or have just upgraded to Word 2007?  Since starting The New Paperclip over two years ago, tadalafil
there have been a few questions that come up again and again that people ask – some of which I have listed below.

  1. How do I change my page orientation in Word 2007 from Portrait to Landscape or vice versa?
  2. How do I change my line spacing in Word 2007?
  3. How do I undo in Word 2007?
  4. How do I do an email merge in Word 2007?
  5. How do I add page numbers in Word 2007?
  6. How do I print in Word 2007?
  7. Where did the file menu go in Word 2007?
  8. How can I change my page layout in Word 2007?
  9. How do I superscript text in Word 2007?
  10. How do I email a document using Word 2007?

Remember that you can have more Word 2007 help, this site
tips, tricks and tutorials delivered to your inbox simply by subscribing to the Office 2007 newsletter.

Finally… if you have any more Word 2007 questions, check out The Ultimate Guide to Word 2007

‘till next time!
TNP 😉

Office 2007 Forum – get your Office 2007 question answered!

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

In this weeks edition of TheNewPaperclip.com’s Office 2007 newsletter, drug
we focused on a few articles that could help you get a big productivity boost in 2009.

Here are a few to get you thinking about how you can be that 10% better in the new year!

 

Create your 2009 Calendar with Word 2007

So, malady
the new year is just a few hours away… time to crack open the calendars your relatives gave you for Christmas right!

But what if you didn’t get any?

>> read more

 

Organise your Inbox with Outlook 2007

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, what is ed
you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

>> read more

 

Follow up Flags and the Default Reminder in Outlook 2007

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am)

>> read more

 

How to find any Office 2007 Command you Want!

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, 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!

>> read more

Do you have an Office 2007 Productivity Tip?  Email office2007tips@thenewpaperclip.com and let me know – and you could share the limelight as I will share the best in the next edition of the newsletter!

’till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

In this weeks edition of TheNewPaperclip.com’s Office 2007 newsletter, drug
we focused on a few articles that could help you get a big productivity boost in 2009.

Here are a few to get you thinking about how you can be that 10% better in the new year!

 

Create your 2009 Calendar with Word 2007

So, malady
the new year is just a few hours away… time to crack open the calendars your relatives gave you for Christmas right!

But what if you didn’t get any?

>> read more

 

Organise your Inbox with Outlook 2007

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, what is ed
you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

>> read more

 

Follow up Flags and the Default Reminder in Outlook 2007

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am)

>> read more

 

How to find any Office 2007 Command you Want!

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, 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!

>> read more

Do you have an Office 2007 Productivity Tip?  Email office2007tips@thenewpaperclip.com and let me know – and you could share the limelight as I will share the best in the next edition of the newsletter!

’till next time!
TNP 😉

They have been closed for a while now, hospital
but today I am re-launching The New Paperclip’s Office 2007 Forums!

What does that mean?  If you have any question at all about Office 2007, whether it is Word, Excel, PowerPoint, Outlook, Access or even SharePoint Designer… you now have a place where you can look for answers.

I will be there frequently, and we will be able to draw on the collective knowledge of the community to get your question answered!

Here are the links to each of the forums:

 

 

So there you have it – the quick and easy way to get your Office 2007 question answered!  See you on the forums!

‘till next time!
TNP 😉

Create a recurring task in Project 2007

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:

1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options

To learn more about how to increase your performance with Word 2007 – check out his post here.

‘till next time!
TNP 😉

So you have a really big spreadsheet… but you only want to print a little bit of it to show a colleague?  You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!

How to set the Print Area in Excel 2007

This is really easy.  To start, simply select the data you want to print.  Then:

1) In the Ribbon, go to the “Page Layout” tab

2) Look for the “Page Setup” group

3) Click on “Print Area”

4) Click on “Set Print Area”

Now when you go and print your worksheet, Excel 2007 will only print the section you just selected.  Very cool!  If you ever want to print the whole worksheet again, you need to clear the Print Area.  Follow the process above, but at the last step, instead of clicking “Set Print Area”, click “Clear Print Area”

‘till next time!
TNP 😉

Are you looking to get the most out of PowerPoint?  Do you know where to start?

Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?

Our friends over at Microsoft have commissioned the development of 157 slides that do just that… show you all the different things you can do in PowerPoint 2007.

These presentations are a great resource if you want to get your hands dirty with PowerPoint.

You can find them by reading this article on the Inside Office Online blog – No more Death by PowerPoint:  Free downloads by a savvy pro sharpen your presentations.

Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen?  Maybe you want to keep a record of an image and text you found in a document or a web page?  Or maybe you just want to keep something funny you saw on the internet?  Well did you know you can quickly and easily take a screen grab with OneNote 2007.

It is really easy!

1) Open up OneNote 2007

2) Look at the toolbar along the top of the window and you will find a “Clip” button.   Click on that.

3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.

4) Your screen clipping will now appear in OneNote!

How easy is that!

‘till next time!
TNP 😉

So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is.  Well are you ready to get even more out of OneNote 2007?

Did you know that OneNote 2007 is jam packed with templates that can make your life much easier.  Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have… “Red Chalk” anyone?), but there are plenty that have real business (and students, academic) value and should be checked out.  For example:

Academic Templates for OneNote 2007

  • Simple Lecture Notes
  • Detailed Lecture Notes
  • Lecture Notes and Study Questions
  • Math/Science Class Notes
  • History Class Notes

Business Templates for OneNote 2007

  • Project Overview
  • Simple Meeting Notes 1 (and 2)
  • Informal Meeting Notes
  • Personal Meeting Notes
  • Detailed Meeting Notes
  • Formal Meeting Notes

Planning Templates for OneNote 2007

  • Simple To Do List
  • Prioritised To Do List
  • Project To Do List

So how do you get your hands on these templates?  Lucky for you they are already loaded in OneNote 2007 for you.  To access them, simply:

1) Click “File”

2) Move your mouse over “New”

3) Click on “Page from Template…”

4) Look to the right and select the page template you want.

 

Looking for more OneNote 2007 Templates?

The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online.  So if you are after a calendar, more planning, reporting or meeting templates – even address books!, you can find them all there – simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.

‘till next time!
TNP 😉

Is there a task you want to schedule in Project 2007 that will occur regularly?  Well did you know you can create that task so it recurs throughout your project plan?

Here is how to do it!

1) Click “Insert” in the Project 2007 menu

2) Click “Recurring Task”

3) In the “Recurring Task Information” window that appears, troche add all the details about your task – including the Task Name and the Recurrence Pattern you want

4) Click “Ok”

Easy!

‘till next time!
TNP 😉

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

Did you know that you can get a regular email jam packed with Office 2007 tips direct from TheNewPaperclip.com!

All you need to do is register using this form

Be more productive with Office 2007!  Subscribe to the regular Office 2007 Tips and Tricks newsletter.  Brought to you by TheNewPaperclip.com

Name:
Email:

Register today and you will receive a free copy of my e-book “Your 10 minute guide to getting up to speed with Microsoft Office 2007”

’till next time!
TNP 😉

Keeping up to date with the latest Office 2007 Help, medicine Tips, Tricks and Tutorials from TheNewPaperclip.com is easy.  There are three options you can choose from to receive regular help and productivity tips!

1) Subscribe to the email newsletter!

To get a regular newsletter packed full of help, tips, tricks and tutorials for Word 2007, Outlook 2007, PowerPoint 2007, Excel 2007 and the rest of the Microsoft Office 2007 suite, simply fill in this registration form below!  PLUS you get a free copy of my ebook when you confirm your registration!

2) Subscribe to the RSS feed!

Simply open up your favourite feed reader, and subscribe to the feed – http://feeds.feedburner.com/TheNewPaperclip

3) Follow The New Paperclip on Twitter!

That’s right, you can how get Office 2007 productivity tips as soon as they are published simply by following @thenewpaperclip on Twitter!
Keeping up to date with the latest Office 2007 Help, obesity Tips, visit web Tricks and Tutorials from TheNewPaperclip.com is easy.  There are three options you can choose from to receive regular help and productivity tips!

1) Subscribe to the email newsletter!

To get a regular newsletter packed full of help, information pills tips, tricks and tutorials for Word 2007, Outlook 2007, PowerPoint 2007, Excel 2007 and the rest of the Microsoft Office 2007 suite, simply fill in this registration form below!  PLUS you get a free copy of my ebook when you confirm your registration!

2) Subscribe to the RSS feed!

Simply open up your favourite feed reader, and subscribe to the feed – http://feeds.feedburner.com/TheNewPaperclip

3) Follow The New Paperclip on Twitter!

That’s right, you can how get Office 2007 productivity tips as soon as they are published simply by following @thenewpaperclip on Twitter!
Keeping up to date with the latest Office 2007 Help, obesity Tips, visit web Tricks and Tutorials from TheNewPaperclip.com is easy.  There are three options you can choose from to receive regular help and productivity tips!

1) Subscribe to the email newsletter!

To get a regular newsletter packed full of help, information pills tips, tricks and tutorials for Word 2007, Outlook 2007, PowerPoint 2007, Excel 2007 and the rest of the Microsoft Office 2007 suite, simply fill in this registration form below!  PLUS you get a free copy of my ebook when you confirm your registration!

2) Subscribe to the RSS feed!

Simply open up your favourite feed reader, and subscribe to the feed – http://feeds.feedburner.com/TheNewPaperclip

3) Follow The New Paperclip on Twitter!

That’s right, you can how get Office 2007 productivity tips as soon as they are published simply by following @thenewpaperclip on Twitter!
Are you a member of the Twitterverse?  If you use the micro-blogging service called Twitter, ask
you can how get your favorite productivity articles on Word, gerontologist
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 😉

Subscribe to the Office 2007 Help, Tips, Tricks and Tutorials Newsletter

Did you know that you can get a regular email jam packed with Office 2007 tips direct from TheNewPaperclip.com!

All you need to do is register using this form

Register today and you will receive a free copy of my e-book “Your 10 minute guide to getting up to speed with Microsoft Office 2007”

’till next time!
TNP 😉

Create your 2009 calendar with Word 2007

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, ed purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, implant yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, visit web thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

Say you have a nice long list of names.  But they are just all over the place.  Wouldn’t it be good to be able to sort them into alphabetical order?

Well in Word 2007 it is a piece of cake!  Assuming you have each item in your list on a separate line…

  1. Select the text you want to sort alphabetically
  2. Make sure you are on the “Home” tab in the Ribbon
  3. Look for the “Paragraph” group
  4. Click on the sort button (that is the one with an "A on top of a Z”
  5. A box will appear – if you want straight alphabetical order on your paragraphs just hit ok.
  6. If you want reverse alphabetical order, surgery
    make sure you select “Descending”

Using the sort button you can also sort numerically, order
or by date!  Simply change the “Type” of sort you want to do in the “Sort Text” box.

‘till next time!
TNP 😉

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

Say you have a nice long list of names.  But they are just all over the place.  Wouldn’t it be good to be able to sort them into alphabetical order?

Well in Word 2007 it is a piece of cake!  Assuming you have each item in your list on a separate line…

  1. Select the text you want to sort alphabetically
  2. Make sure you are on the “Home” tab in the Ribbon
  3. Look for the “Paragraph” group
  4. Click on the sort button (that is the one with an "A on top of a Z”
  5. A box will appear – if you want straight alphabetical order on your paragraphs just hit ok.
  6. If you want reverse alphabetical order, surgery
    make sure you select “Descending”

Using the sort button you can also sort numerically, order
or by date!  Simply change the “Type” of sort you want to do in the “Sort Text” box.

‘till next time!
TNP 😉

Do you like to have a copy of your schedule with you all the time?  Would managing your time be simpler if you could have a printed copy of your Outlook calendar with you as you travel from meeting to meeting?

Printing out your calendar is a piece of cake in Outlook 2007!

  1. Click on “Calendar” so you are looking at your calendar, no rx
    and not your email!
  2. Select the view you want to print out – it could be a day, a week, a month, or a custom date range
  3. Click on the File menu, and select “Print”

Simple as that!  And remember if you are not sure of which calendar print out you want, that you can Print Preview to see exactly what you are going to get before doing the final print!

By the way, printing a blank calendar in Outlook 2007 on month view is a really nice, and inexpensive way to put a calendar up in your office cubicle, or on your fridge at home to keep track of family events!

‘till next time!
TNP 😉

I noticed one of my colleagues the other day struggling with her Excel Spreadsheet (yep that’s right, purchase even TNP needs a day job to pay the mortgage!). 

She had a sheet with a few hundred rows in it – all containing information about people who had registered to attend an event.  I noticed that she was trying to count how many people from each state had registered.

I popped over and suggested that she use a Pivot Table.

What is a Pivot Table?

A Pivot Table in Excel 2007 is a pretty powerful, yet simple way to slice and dice the data in your spreadsheet.  It can help you summarise hundreds, thousands, even millions of rows (in Excel 2007 at least) into information that you can take action on!  And because you can quickly change how you view your data, it can be a really useful tool to use in the business world.

So how do you create a simple Pivot Table in Excel 2007? 

Well first, you need some data in your spreadsheet that you want to slice and dice.  Once you have the data – maybe it is a list of customers, a list of products, or a list of transactions including customers AND products… you can then start Pivoting!

  1. Make sure there are no blank rows or blank columns where all you data is in your spreadsheet (extra rows and columns after all your data is ok though)
  2. Click on the “Insert” tab in the ribbon
  3. Look for the “Tables” group. 
  4. The very first button in that group should be “Pivot Table”.  Click on that
  5. Select “Pivot Table”
  6. A little box will appear, and Excel 2007 will take an educated guess at what data you want to include in your pivot table.  Excel is generally pretty good and picking the data, so don’t worry about that part – but make sure you look at the bottom half of that box.  Excel is asking you where you want your pivot table to appear.  I suggest you choose a “New Worksheet” and then click “OK”
  7. You will now notice what looks like a “Task Pane” appear in the right hand side of your Excel window.
  8. In the top half of that task pane, select the fields that you want to include in your pivot table – basically you need to pick the information you want to slice and dice!
  9. In the bottom half of that task pane, play around with where those fields sit in the Pivot Table.  You can filter based on certain fields, you can add fields as row or column labels, or you can get summary values for the contents of cells – you take your pick.  It is best to play around and experiment at this stage to get the exact outcome you want, simply because there are so many ways you might want to slice and dice that data.
  10. When you are done, just close that task pan by clicking the “x” at the top of it (make sure you click the one at the top of the Task Pane, and not the one on the top of the window! that will close Excel!)
  11. Now play around with your pivot table, and impress your boss!

Whilst it might look a little complicated to begin with, the best advice I can give is to give Pivot Tables a go and simply experiment with some data.  Then you will see the true potential of how much time this great feature of Excel could save you!

’till next time!
TNP 😉

Say you have a nice long list of names.  But they are just all over the place.  Wouldn’t it be good to be able to sort them into alphabetical order?

Well in Word 2007 it is a piece of cake!  Assuming you have each item in your list on a separate line…

  1. Select the text you want to sort alphabetically
  2. Make sure you are on the “Home” tab in the Ribbon
  3. Look for the “Paragraph” group
  4. Click on the sort button (that is the one with an "A on top of a Z”
  5. A box will appear – if you want straight alphabetical order on your paragraphs just hit ok.
  6. If you want reverse alphabetical order, surgery
    make sure you select “Descending”

Using the sort button you can also sort numerically, order
or by date!  Simply change the “Type” of sort you want to do in the “Sort Text” box.

‘till next time!
TNP 😉

Do you like to have a copy of your schedule with you all the time?  Would managing your time be simpler if you could have a printed copy of your Outlook calendar with you as you travel from meeting to meeting?

Printing out your calendar is a piece of cake in Outlook 2007!

  1. Click on “Calendar” so you are looking at your calendar, no rx
    and not your email!
  2. Select the view you want to print out – it could be a day, a week, a month, or a custom date range
  3. Click on the File menu, and select “Print”

Simple as that!  And remember if you are not sure of which calendar print out you want, that you can Print Preview to see exactly what you are going to get before doing the final print!

By the way, printing a blank calendar in Outlook 2007 on month view is a really nice, and inexpensive way to put a calendar up in your office cubicle, or on your fridge at home to keep track of family events!

‘till next time!
TNP 😉

Is your inbox overflowing like mine?  Want to know how you can you quickly focus on what you need to action?  Well here is a nifty way to do it.

In Outlook 2007, medical you can organise your emails using views.  What is a view you say?  Basically think of it of a different way to look at all the emails you have.

In Outlook 2007 there are a number of views you can “view” your emails with:

  • Messages
  • Messages with Auto Preview
  • Messages from the Last Seven Days
  • Unread Messages in a particular folder
  • Messages sent to me
  • Messages in a timeline (very cool!)
  • and some more complicated views like Outlook Data Files, medicine
    and Documents

So how do you change the view of your inbox?

Simple. 

  1. Click on the folder you want to organise (ie your Inbox).
  2. Click on the tools menu
  3. Select “Organize”
  4. In the window that appears, Hemorrhoids
    click “Using Views”
  5. Select your favourite view

If you want to get really tricky you can create your own custom view by clicking the “Customize Current View” button in the top right hand corner of that box.  You can customise your view with different fields, group by’s, sorts. filters and other settings.

How cool is that!

‘till next time!
TNP 😉

So you are about to do a presentation – maybe it is at an event or a tradeshow – and instead of using a projector, population health your are presenting your slides using a plasma or LCD tv.

When you practice your presentation on your computer or on a projector, pilule your slides look fine.  But as soon as you try your deck on the plasma or LCD, your slides stretch and look horrible!

How do you get your slides to look perfect on the plasma?

Did you know that you can change the size, shape, and orientation of your slides in PowerPoint 2007!

You can set up your presentation for different “On Screen” sizes, such as 4:3 (which is the default), or 16:9 and 16:10 aspect ratios, which are perfect for widescreen plasma panels!

(just as an aside, you can also select different paper sizes as well if you want to build your slides specifically for printing as opposed to being used on screen – but we can talk about that another day!)

To change your slides from standard to widescreen

  1. In PowerPoint 2007, click on the “Design” tab on the Ribbon
  2. Look for the “Page Setup” group
  3. Click on “Page Setup”
  4. Look for the “Slides sized for:” drop down box, and select either “On-screen Show (16:9)” or “On-screen Show (16:10)
  5. Click “OK”

Now you will have noticed the shape of your slides has changed from being close to a square, to more like a rectangle – and you will find that your graphics and text will no longer distort when you show your presentations on those fancy plasma screens!

Now get out there and impress those customers!

’till next time!
TNP 😉

Well… hasn’t 2008 gone quickly!

Now that Christmas is just past us, search now is the time to start thinking about your new years resolutions.

Most people usually say the same thing every year… I am going to exercise more… I am going to work less etc etc.  But most of the time by mid-February you are already way off track.

The key to a good new years resolution is to be specific, dosage and to write it down somewhere so you are reminded of it.  What better place to do that than in OneNote 2007!

Here is how to make a record of your resolutions… AND be reminded to actually work on them.

1) Write your resolutions in OneNote

2) Tag your resolutions with a specific tag from (you guessed it!) the “Tag” button.  If your resolution is to do a generic task, buy information pills tag it with a “To Do” tag.  If it is a little more specific – say, watch a movie… then tag it with the “Movie to See” tag.  There are dozens of tags you can choose from to give you a visual cue regarding your resolution.

Easy so far right?  Well, now with a little help from Outlook 2007, we can now be reminded throughout the year to work on our resolutions!

3) In OneNote 2007, you will see a “Task” button just to the left of the “Tag” button in the menu.  By selecting one of the “Task” options for your resolution, it can now appear as a task whenever you open Outlook.  So now whenever you are checking your email, your calendar, or your task list… you will have a gentle reminder to work on your new years resolutions, throughout the year.

 

So there you have it, you really have no excuses not to achieve your resolutions this year!

’till next time!
TNP 😉

Keeping up to date with the latest Office 2007 Help, no rx Tips, page Tricks and Tutorials from TheNewPaperclip.com is easy.  There are three options you can choose from to receive regular help and productivity tips!

1) Subscribe to the email newsletter!

To get a regular newsletter packed full of help, tips, tricks and tutorials for Word 2007, Outlook 2007, PowerPoint 2007, Excel 2007 and the rest of the Microsoft Office 2007 suite, simply fill in this registration form below!  PLUS you get a free copy of my ebook when you confirm your registration!

2) Subscribe to the RSS feed!

Simply open up your favourite feed reader, and subscribe to the feed – http://feeds.feedburner.com/TheNewPaperclip

3) Follow The New Paperclip on Twitter!

That’s right, you can how get Office 2007 productivity tips as soon as they are published simply by following @thenewpaperclip on Twitter!
Keeping up to date with the latest Office 2007 Help, pulmonologist Tips, Tricks and Tutorials from TheNewPaperclip.com is easy.  There are three options you can choose from to receive regular help and productivity tips!

1) Subscribe to the email newsletter!

To get a regular newsletter packed full of help, tips, tricks and tutorials for Word 2007, Outlook 2007, PowerPoint 2007, Excel 2007 and the rest of the Microsoft Office 2007 suite, simply fill in this registration form below!  PLUS you get a free copy of my ebook when you confirm your registration!

2) Subscribe to the RSS feed!

Simply open up your favourite feed reader, and subscribe to the feed – http://feeds.feedburner.com/TheNewPaperclip

3) Follow The New Paperclip on Twitter!

That’s right, you can how get Office 2007 productivity tips as soon as they are published simply by following @thenewpaperclip on Twitter!

Wow… I was busy working away today (on New Years Eve!) and discovered a really easy way to get nice looking borders on the cells you want in Excel 2007.

Instead of selecting the cells, therapy going up to the Font Group and playing with the Borders buttons, did you know you can simply DRAW your borders onto your spreadsheet!

All you have to do to draw your borders in Excel 2007 is:

1) Make sure you are on the “Home” tab in the Ribbon

2) Look for the “Font” group

3) Select the drop down arrow beside the “Borders” button

4) Select one of the “Draw Borders” options from the bottom of the menu.

My three favourite Draw Border tools in Excel 2007 are Draw Border, which allows you to quickly get a border around a group of cells, Draw Border Grid, which draws you (as the name suggests) a grid, and finally Erase Border, which you guessed it, helps you erase your border!

So next time you want to make your spreadsheet more professional with borders the EASY way, make sure you check out the Draw Border features.

’till next time!
TNP 😉

So, implant the new year is just a few hours away… time to crack open the calendars your relatives gave you for Christmas right!

But what if you didn’t get any?

Well did you know you can create your own calendars nice and quickly with Word 2007!

All you need to do is to open a new document by clicking on the “Office Orb” (the old file menu in the top left hand corner of Word), what is ed and then clicking “New”

On the New Document dialog box that appears, prescription you will see down the left hand side a wide range of templates that are available to you.  Down in the “Microsoft Office Online” section, you will find a “Calendars” option – click on that!

Word will connect to Microsoft Office Online, and give you a wide variety of calendar options.  For your 2009 calendar, click on “2009 calendars”.  For other options such as multiple year calendars, simply click on those.

Once you click on “2009 calendars” you will see a few dozen different options to choose from – different calendar structures and different calendar designs.

My favourite, especially if you want to add your own pictures to the calendar is the “2009 Picture Calendar Featured at Office Online”.  Great for family pictures!

’till next time!
TNP 😉

A fresh new look at The New Paperclip

Are you a small business person who wants to create a great looking business card?  It is really easy with Microsoft Office Publisher 2007.

Here is how you do it!

1) Open Publisher 2007

2) On the “Getting Started with Microsoft Office Publisher 2007” page, this more about look on the left hand side.  You will see a column with the heading “Publication Types” at the top.  Look down the list and about 6 down you will see “Business Cards”.  Click on it

3) In the main part of the window you will now see a variety of designs for your business card.  There are newer, cialis 40mg more contemporary designs at the top, more info and more classical designs down the bottom.  Take a good look at each, and pick your favourite.

4) In the right hand column, there are a number of options for your business card.  You can customise it with a different colour scheme, and a different font scheme.

5) Still in the right hand column, look for the “Business information” drop down box.  If this is the first time you have created a business card, your only option will be “Create new…”.  Select “Create new…” and a box will appear for you to enter your business card information.  Once you are happy with all your details, click save.

6) If you are happy with all your decisions, click the “Create” button in the bottom right hand corner of the screen.

7) Once your card is created… check all the details, and then hit print!

Now you have a business card you can be proud of!

’till next time!
TNP 😉

You may have read about it a few weeks ago, recipe but last weekend yours truly had the opportunity to present at an event called OfficeDevCon08, viagra in Sydney Australia.

I delivered two presentations – and because I am such a nice guy I have decided to share them with you all 🙂

The first presentation I delivered was about comparing all the different business productivity suites that are out there in the market.  I called it the “Office Suite Smackdown!”

The second presentation I delivered was all about the frustrations that we all face when we first move to Office 2007, and how to avoid them.  I called it (funnily enough) “The 10 Most Common Office 2007 User Frustrations, and how to avoid them”.

Make sure you check the presentations out (thanks to SlideShare.net!) – however due to my presentation style they might seem a little confusing without your old friend The New Paperclip jumping around in front of a projector!

So… you like what you see and want to see one of the presentations delivered at your next conference / training day / birthday party?  Make sure you get in touch with TNP’s alter ego (Paul Woods) via email – paul@paul-woods.com

’till next time!
TNP 😉

PS. A big hello to Microsoft MVPs Lucy Thomson and Glen Millar, as well as Microsoftie Alistair Speirs for their sparkling repartee over beers on Saturday night 🙂

Ever wanted the users of your spreadsheets to fill in cells using only a certain number of options.  Say you had a list of States… maybe numbers from your General Ledger… or Product Categories.  Wouldn’t it be fantastic, website instead of making people remember the correct names (and spelling) of each… that we could just give them a nice little list of options to pick from to populate the cell?

Well in Excel 2007, this site that is really easy!  Here is how to go about it.

Using Data Validation to create look up lists in Excel 2007

There are two ways to go about this… the simple way, erectile if you only have a few options… or the less simple way 🙂

 

The Simple Way 

1) Click on the cell you want the look up / drop down list to appear in

2) Go to the “Data” tab in the Excel 2007 ribbon

3) Look for the “Data Tools” group

4) Click on “Data Validation”

5) In the box that appears, on the “Settings” tab, set the Validation criteria to allow “List”

6) In the “Source” text box, type in the options you want to make available (and remember to separate them with a comma!)

7) Click ok

8) Check out how unreal your drop down box in Excel 2007 looks!  And go tell your friends how easy it was!!!!

 

The Less Simple Way

I call this less simple simply because it is still pretty simple.  This method is best if you will have a long list of options that might already exist in your spreadsheet, or a list that you would want to regularly update.

Basically all you need to do is follow “The Simple Way”, and when you get to step 6, instead of typing in the options you want to make available, simply select the cells in your spreadsheet that contain the values.

So there you have it – drop down boxes… look up lists… whatever you call them… made easy in Excel 2007.

’till next time!
TNP 😉

Do you have Office Communicator at work?  Ever wonder how some of your colleagues get that little “note” icon beside their name that has some witty comment like “Working Hard”, ask “Leave me alone I have a tender to finish”, prostate or “Working from home today”?

Setting a note in Office Communicator is very easy.  In fact, there are only 3 steps

1) Think of the note you want to use!

2) Look just underneath your name in the Office Communicator 2007 window – specifically for a little bit of italic text with the words “Type a note”

3) Click there, type your note, and hit enter

There you go, now you can let your colleagues know what is going on.  Think of it as your FaceBook status if FaceBook has been banned in your organisation!

’till next time!
TNP 😉

Do you have Office Communicator at work?  Ever wonder how some of your colleagues get that little “note” icon beside their name that has some witty comment like “Working Hard”, ask “Leave me alone I have a tender to finish”, prostate or “Working from home today”?

Setting a note in Office Communicator is very easy.  In fact, there are only 3 steps

1) Think of the note you want to use!

2) Look just underneath your name in the Office Communicator 2007 window – specifically for a little bit of italic text with the words “Type a note”

3) Click there, type your note, and hit enter

There you go, now you can let your colleagues know what is going on.  Think of it as your FaceBook status if FaceBook has been banned in your organisation!

’till next time!
TNP 😉

So you want to insert an image in your PowerPoint presentation… but there is one BIG problem.  The image you want to insert has an ugly blue background, pharmacy
but you really want it to be white just like the slide!  How can you turn this graphic design disaster around?

Well it is very simple – as long as that background is a solid colour.  Here is how…

1) Insert your image onto your PowerPoint 2007 slide

2) Click on your image

3) Notice the “Picture Tools – Format” tab has now appeared in the Ribbon.  If it is not already selected, drugstore
make sure you click on it now.

4) Look for the “Adjust” group

5) Click on “Recolor”

6) Click on “Set Transparent Color”

7) Click on the Colour in your image that you want to be transparent

That is it!  Now your pictures and other graphics can look really nice on your PowerPoint slides… and not amateurish like they might have before!  And you can impress your boss 🙂

Talk about a quick win!

‘till next time!
TNP 😉

Do you have Office Communicator at work?  Ever wonder how some of your colleagues get that little “note” icon beside their name that has some witty comment like “Working Hard”, ask “Leave me alone I have a tender to finish”, prostate or “Working from home today”?

Setting a note in Office Communicator is very easy.  In fact, there are only 3 steps

1) Think of the note you want to use!

2) Look just underneath your name in the Office Communicator 2007 window – specifically for a little bit of italic text with the words “Type a note”

3) Click there, type your note, and hit enter

There you go, now you can let your colleagues know what is going on.  Think of it as your FaceBook status if FaceBook has been banned in your organisation!

’till next time!
TNP 😉

So you want to insert an image in your PowerPoint presentation… but there is one BIG problem.  The image you want to insert has an ugly blue background, pharmacy
but you really want it to be white just like the slide!  How can you turn this graphic design disaster around?

Well it is very simple – as long as that background is a solid colour.  Here is how…

1) Insert your image onto your PowerPoint 2007 slide

2) Click on your image

3) Notice the “Picture Tools – Format” tab has now appeared in the Ribbon.  If it is not already selected, drugstore
make sure you click on it now.

4) Look for the “Adjust” group

5) Click on “Recolor”

6) Click on “Set Transparent Color”

7) Click on the Colour in your image that you want to be transparent

That is it!  Now your pictures and other graphics can look really nice on your PowerPoint slides… and not amateurish like they might have before!  And you can impress your boss 🙂

Talk about a quick win!

‘till next time!
TNP 😉

The other day a friend of mine called up and asked… “I know the new file format for Word 2007 is .docx, discount RX
but today I came across a file with the .docm extension.  Do you know what it is?”

Here is the answer I gave him…

In Word 2007, you can save your work as a .docx, which is just a standard Word 2007 document.  However, if you have built macros into your document, you are best to save it is a Word Macro Enabled Document, or a .docm. 

So to answer your question… a .docm file is a special Word 2007 document that contains a macro

(for those who are unfamiliar with macros – they are a set of recorded actions that you might regularly use in Word 2007, that you can play back at any time, therefore increasing your productivity)

Just a word of warning though.  If someone you trust sends you a .docm file, and you know what it is, you should be fairly safe opening it.  However if you don’t know who is sending you the document, and don’t know what you should expect when you do open it, the safest thing to do is not open it.  Some unsavory people out there try to do malicious things with macros – so best be on the lookout.

‘till next time!
TNP 😉

Are you like me and love to have more control over your formatting?  Or do you simply want to get rid of those stupid “Backwards P’s” all through your Word document?

Well information is power… and Word 2007 (just like its predecessors) can give you plenty of information about how your document is formatted.  The problem is, sale by default, all that information is hidden.  And sometimes you can accidentally turn it on when you don’t want it there!

So… if you want to turn your formatting codes on or off in Word 2007, it is really simple.

1) Make sure you are on the “Home” tab in the Ribbon

2) Look for the “Paragraph” group

3) You will see a funny looking symbol that looks like a backwards “P” (… click on that.

Or, you could just use the shortcut, which is…

“Ctrl+*”

So there you go – how easy is that!

’till next time!
TNP 😉

Are you like me and love to have more control over your formatting?  Or do you simply want to get rid of those stupid “Backwards P’s” all through your Word document?

Well information is power… and Word 2007 (just like its predecessors) can give you plenty of information about how your document is formatted.  The problem is, sale by default, all that information is hidden.  And sometimes you can accidentally turn it on when you don’t want it there!

So… if you want to turn your formatting codes on or off in Word 2007, it is really simple.

1) Make sure you are on the “Home” tab in the Ribbon

2) Look for the “Paragraph” group

3) You will see a funny looking symbol that looks like a backwards “P” (… click on that.

Or, you could just use the shortcut, which is…

“Ctrl+*”

So there you go – how easy is that!

’till next time!
TNP 😉

Hi, prescription

Are you looking to target an audience of

Are you like me and love to have more control over your formatting?  Or do you simply want to get rid of those stupid “Backwards P’s” all through your Word document?

Well information is power… and Word 2007 (just like its predecessors) can give you plenty of information about how your document is formatted.  The problem is, sale by default, all that information is hidden.  And sometimes you can accidentally turn it on when you don’t want it there!

So… if you want to turn your formatting codes on or off in Word 2007, it is really simple.

1) Make sure you are on the “Home” tab in the Ribbon

2) Look for the “Paragraph” group

3) You will see a funny looking symbol that looks like a backwards “P” (… click on that.

Or, you could just use the shortcut, which is…

“Ctrl+*”

So there you go – how easy is that!

’till next time!
TNP 😉

Hi, prescription

Are you looking to target an audience of
Do you want your Office 2007 related brand or product to be seen by 10s of thousands of Office users and decision makers from all around the world?  Then sponsor The New Paperclip.

To support the oingoing operation of one of the most popular Office 2007 tips and tricks sits online, tuberculosis
The New Paperclip offers a limited number of highly targeted advertising opportunities for organisations that are looking to sell:

  • Office 2007 training courses
  • Office 2007 training materials
  • Office 2007 add-ins or other related software
  • Office 2007 professional services

Through 125×125 banners that appear “above the fold” on every page of the site, your product and brand will be highly visible to all visitors.  And as many corporate intranets link to TheNewPaperclip.com, you will have access to both business and technical decision makers.

For more information, or to recieve your personalised campaign package, please email Paul Woods

Are you like me and love to have more control over your formatting?  Or do you simply want to get rid of those stupid “Backwards P’s” all through your Word document?

Well information is power… and Word 2007 (just like its predecessors) can give you plenty of information about how your document is formatted.  The problem is, sale by default, all that information is hidden.  And sometimes you can accidentally turn it on when you don’t want it there!

So… if you want to turn your formatting codes on or off in Word 2007, it is really simple.

1) Make sure you are on the “Home” tab in the Ribbon

2) Look for the “Paragraph” group

3) You will see a funny looking symbol that looks like a backwards “P” (… click on that.

Or, you could just use the shortcut, which is…

“Ctrl+*”

So there you go – how easy is that!

’till next time!
TNP 😉

Hi, prescription

Are you looking to target an audience of
Do you want your Office 2007 related brand or product to be seen by 10s of thousands of Office users and decision makers from all around the world?  Then sponsor The New Paperclip.

To support the oingoing operation of one of the most popular Office 2007 tips and tricks sits online, tuberculosis
The New Paperclip offers a limited number of highly targeted advertising opportunities for organisations that are looking to sell:

  • Office 2007 training courses
  • Office 2007 training materials
  • Office 2007 add-ins or other related software
  • Office 2007 professional services

Through 125×125 banners that appear “above the fold” on every page of the site, your product and brand will be highly visible to all visitors.  And as many corporate intranets link to TheNewPaperclip.com, you will have access to both business and technical decision makers.

For more information, or to recieve your personalised campaign package, please email Paul Woods
Do you want your Office 2007 related brand or product to be seen by 10s of thousands of Office users and decision makers from all around the world?  Then sponsor The New Paperclip

To support the oingoing operation of one of the most popular Office 2007 tips and tricks sits online, cystitis
The New Paperclip offers a limited number of highly targeted advertising opportunities for organisations that are looking to sell:

  • Office 2007 training courses
  • Office 2007 training materials
  • Office 2007 add-ins or other related software
  • Office 2007 professional services

Through 125×125 banners that appear “above the fold” on every page of the site, buy cialis your product and brand will be highly visible to all visitors.  And as many corporate intranets link to TheNewPaperclip.com, you will have access to both business and technical decision makers.

For more information, or to recieve your personalised campaign package, please email Paul Woods

Are you like me and love to have more control over your formatting?  Or do you simply want to get rid of those stupid “Backwards P’s” all through your Word document?

Well information is power… and Word 2007 (just like its predecessors) can give you plenty of information about how your document is formatted.  The problem is, sale by default, all that information is hidden.  And sometimes you can accidentally turn it on when you don’t want it there!

So… if you want to turn your formatting codes on or off in Word 2007, it is really simple.

1) Make sure you are on the “Home” tab in the Ribbon

2) Look for the “Paragraph” group

3) You will see a funny looking symbol that looks like a backwards “P” (… click on that.

Or, you could just use the shortcut, which is…

“Ctrl+*”

So there you go – how easy is that!

’till next time!
TNP 😉

Hi, prescription

Are you looking to target an audience of
Do you want your Office 2007 related brand or product to be seen by 10s of thousands of Office users and decision makers from all around the world?  Then sponsor The New Paperclip.

To support the oingoing operation of one of the most popular Office 2007 tips and tricks sits online, tuberculosis
The New Paperclip offers a limited number of highly targeted advertising opportunities for organisations that are looking to sell:

  • Office 2007 training courses
  • Office 2007 training materials
  • Office 2007 add-ins or other related software
  • Office 2007 professional services

Through 125×125 banners that appear “above the fold” on every page of the site, your product and brand will be highly visible to all visitors.  And as many corporate intranets link to TheNewPaperclip.com, you will have access to both business and technical decision makers.

For more information, or to recieve your personalised campaign package, please email Paul Woods
Do you want your Office 2007 related brand or product to be seen by 10s of thousands of Office users and decision makers from all around the world?  Then sponsor The New Paperclip

To support the oingoing operation of one of the most popular Office 2007 tips and tricks sits online, cystitis
The New Paperclip offers a limited number of highly targeted advertising opportunities for organisations that are looking to sell:

  • Office 2007 training courses
  • Office 2007 training materials
  • Office 2007 add-ins or other related software
  • Office 2007 professional services

Through 125×125 banners that appear “above the fold” on every page of the site, buy cialis your product and brand will be highly visible to all visitors.  And as many corporate intranets link to TheNewPaperclip.com, you will have access to both business and technical decision makers.

For more information, or to recieve your personalised campaign package, please email Paul Woods
Do you want your Office 2007 related brand or product to be seen by 10s of thousands of Office users and decision makers from all around the world?  Then sponsor The New Paperclip.

To support the oingoing operation of one of the most popular Office 2007 tips and tricks sits online, pilule
The New Paperclip offers a limited number of highly targeted advertising opportunities for organisations that are looking to sell:

  • Office 2007 training courses
  • Office 2007 training materials
  • Office 2007 add-ins or other related software
  • Office 2007 professional services

Through 125×125 banners that appear “above the fold” on every page of the site, ambulance
your product and brand will be highly visible to all visitors.  And as many corporate intranets link to TheNewPaperclip.com, you will have access to both business and technical decision makers.

For more information, or to recieve your personalised campaign package, please email Paul Woods

So you are putting together your Word masterpiece!  Maybe it is a poster, audiologist or a document announcing a big event… and you want to make a big impact!  Well one way to do that is to add a border to your page.

So how do you add a border to a page in Word 2007?

It is soooooooooooo easy!

  1. Click on the “Page Layout” tab in the Ribbon
  2. Look for the “Page Background” group
  3. Click on “Page Borders”
  4. Select one of the preset border settings that appear down the left hand side of the dialog box
  5. Play around with your line style, mind colour, line width, and artwork until you find your perfect border
  6. Click ok!

It is that simple!  Now you can impress your colleagues, family and friends with your fantastic page borders!

But wait!

Did I mention that one of the art options is Christmas Trees!  What a perfect page border for this time of year!  Make sure you look for it in the “Art” dropdown box.

’till next time!
TNP 😉

Hi all, health

TNP here.  Hope all my friends in North America have had a fantastic Thanks Giving holiday… and for those of you in other parts, drug hope life is treating you well.

Those of you that have been here before will notice that I put a new lick of paint on the site over the weekend – I hope you like the new fresh look.

Hopefully little changes like increasing the font size, and more white space will make it easier for you to quickly read and understand exactly what you need to do to solve your Office 2007 problems!

Thanks again to everyone who visits – we are talking 10s of thousands of you every couple of weeks… I certainly appreciate your support

Whilst talking about your amazing support… if you have any suggestions for topics, or how we can improve things around here.. please drop me a line via the comments section below!

’till next time!
TNP 😉

How to set a note in Office Communicator 2007

Are you a small business person who wants to create a great looking business card?  It is really easy with Microsoft Office Publisher 2007.

Here is how you do it!

1) Open Publisher 2007

2) On the “Getting Started with Microsoft Office Publisher 2007” page, this more about look on the left hand side.  You will see a column with the heading “Publication Types” at the top.  Look down the list and about 6 down you will see “Business Cards”.  Click on it

3) In the main part of the window you will now see a variety of designs for your business card.  There are newer, cialis 40mg more contemporary designs at the top, more info and more classical designs down the bottom.  Take a good look at each, and pick your favourite.

4) In the right hand column, there are a number of options for your business card.  You can customise it with a different colour scheme, and a different font scheme.

5) Still in the right hand column, look for the “Business information” drop down box.  If this is the first time you have created a business card, your only option will be “Create new…”.  Select “Create new…” and a box will appear for you to enter your business card information.  Once you are happy with all your details, click save.

6) If you are happy with all your decisions, click the “Create” button in the bottom right hand corner of the screen.

7) Once your card is created… check all the details, and then hit print!

Now you have a business card you can be proud of!

’till next time!
TNP 😉

You may have read about it a few weeks ago, recipe but last weekend yours truly had the opportunity to present at an event called OfficeDevCon08, viagra in Sydney Australia.

I delivered two presentations – and because I am such a nice guy I have decided to share them with you all 🙂

The first presentation I delivered was about comparing all the different business productivity suites that are out there in the market.  I called it the “Office Suite Smackdown!”

The second presentation I delivered was all about the frustrations that we all face when we first move to Office 2007, and how to avoid them.  I called it (funnily enough) “The 10 Most Common Office 2007 User Frustrations, and how to avoid them”.

Make sure you check the presentations out (thanks to SlideShare.net!) – however due to my presentation style they might seem a little confusing without your old friend The New Paperclip jumping around in front of a projector!

So… you like what you see and want to see one of the presentations delivered at your next conference / training day / birthday party?  Make sure you get in touch with TNP’s alter ego (Paul Woods) via email – paul@paul-woods.com

’till next time!
TNP 😉

PS. A big hello to Microsoft MVPs Lucy Thomson and Glen Millar, as well as Microsoftie Alistair Speirs for their sparkling repartee over beers on Saturday night 🙂

Ever wanted the users of your spreadsheets to fill in cells using only a certain number of options.  Say you had a list of States… maybe numbers from your General Ledger… or Product Categories.  Wouldn’t it be fantastic, website instead of making people remember the correct names (and spelling) of each… that we could just give them a nice little list of options to pick from to populate the cell?

Well in Excel 2007, this site that is really easy!  Here is how to go about it.

Using Data Validation to create look up lists in Excel 2007

There are two ways to go about this… the simple way, erectile if you only have a few options… or the less simple way 🙂

 

The Simple Way 

1) Click on the cell you want the look up / drop down list to appear in

2) Go to the “Data” tab in the Excel 2007 ribbon

3) Look for the “Data Tools” group

4) Click on “Data Validation”

5) In the box that appears, on the “Settings” tab, set the Validation criteria to allow “List”

6) In the “Source” text box, type in the options you want to make available (and remember to separate them with a comma!)

7) Click ok

8) Check out how unreal your drop down box in Excel 2007 looks!  And go tell your friends how easy it was!!!!

 

The Less Simple Way

I call this less simple simply because it is still pretty simple.  This method is best if you will have a long list of options that might already exist in your spreadsheet, or a list that you would want to regularly update.

Basically all you need to do is follow “The Simple Way”, and when you get to step 6, instead of typing in the options you want to make available, simply select the cells in your spreadsheet that contain the values.

So there you have it – drop down boxes… look up lists… whatever you call them… made easy in Excel 2007.

’till next time!
TNP 😉

Do you have Office Communicator at work?  Ever wonder how some of your colleagues get that little “note” icon beside their name that has some witty comment like “Working Hard”, ask “Leave me alone I have a tender to finish”, prostate or “Working from home today”?

Setting a note in Office Communicator is very easy.  In fact, there are only 3 steps

1) Think of the note you want to use!

2) Look just underneath your name in the Office Communicator 2007 window – specifically for a little bit of italic text with the words “Type a note”

3) Click there, type your note, and hit enter

There you go, now you can let your colleagues know what is going on.  Think of it as your FaceBook status if FaceBook has been banned in your organisation!

’till next time!
TNP 😉

How to set up a new Groove 2007 Account

I was surfing the net tonight, neurologist buy and totally out of left field I found an article on OfficeLabs.com that I thought you would love to read.

Did you know that you can use your Nintentdo Wii Controller to control your PowerPoint 2007 presentations?

It is a little tricky to set up, but once it is you simply need to flick your Wiimote to the left or to the right to control your slides.  HOW COOL IS THAT!

You can read more about it on OffliceLabs.com

’till next time!
TNP 😉

Are you going to be somewhere near Sydney, emergency Australia in mid November?

If you are, and are interested in all things Office, make sure you get to OfficeDevCon08!

From the blurb… “OfficeDevCon is the first Australian community-driven event aimed squarely at Microsoft Office developers and power-users.  It allows people with interests across the Microsoft Office platform come together in one place to network and hear expert presenters speak on a wide range of advanced Office-related topics”

Well guess what… one of those expert presenters will be your’s truly… The New Paperclip.

In fact, in reality it will be my alter-ego… the guy behind The New Paperclip… Paul Woods

Paul will be presenting TWO sessions that should not be missed – especially if you work in Corporate IT.  Here is a quick outline of each presentation…

“The Office Suite Smackdown”
Saturday 15 November – 3:00-3:50PM

Office might seem like the obvious choice… but recently the competition has heated up for desktop productivity suites.  Your manager might be asking about alternatives like Google Docs, Open Office, Corel Wordperfect or Zoho Office.  In this session we compare the alternatives to Office 2007 from a users point of view – to help you pick the right tool for your organisation.

“The 10 most common Office 2007 user frustrations… and how to avoid them”
Sunday 16 November – 9:00-9:50AM

Don’t want your whole organisation angry with you because you forced them to use this horrible steaming pile of Office 2007 software?  It is a lot easier than you think to ensure a smooth and pain free transition to Office 2007 – it isn’t about buying 400 page dummies books, or just pointing people to the help button.  Simply by making sure you anticipate the most common questions up front you can win most of your potential battles.  In this session we will look at the most searched for answers by hundreds of thousands of frustrated Office 2007 users at http://www.thenewpaperclip.com… and see how you can ensure your people don’t end up asking YOU those questions.

So what do I need to do to attend these presentations?

Simple.  Go to http://www.officedevcon.com.au/ and register your spot.  Tell them that TNP sent you!  And make sure you catch up with me at the bar on Saturday afternoon!

’till next time!
TNP 😉

So you have opened up Groove 2007 for the first time.  Well before you can start collaborating you have to create a new account.  So lets see how we do it!

First – Open Groove 2007
Hmmm… seems obvious doesn’t it!

Second – Unblock your firewall (only once)
Chances are you are on Windows Vista, syphilis you will be running Windows Firewall on your machine. If this is the first time you have opened Groove 2007, (and Windows Firewall is on) a dialog box will appear asking you to unblock Groove.  Trust me when I say it is in your best interests to do so (if you want to use Groove that is!)

Third – Create your new Groove Account
By now you should see the Microsoft Office Groove Account Configuration Wizard.  Click on the “Create a new Groove account” radio button then hit next.

The next screen will ask you if you have a Groove Account Configuration Code.  If you are using Groove at work your systems administrator may have a Groove Account Configuration Code for you.  Best that you check with them before going any further.  If you are using Groove at home, or only a few of you in your organisation are using Groove, you can select the third option “I don’t have a Groove Account Configuration Code” and click next

On the next screen, simply enter your personal details – name, email address, password and password hint.  When you are ready to proceed, click next

A dialog box will appear telling you to hang on a second whilst Groove configures your account.  This should only take around 10 seconds.

On the final screen of the Microsoft Office Groove Account Configuration Wizard you will be asked if you want your account to be included in the Public Groove Directory.  Basically this enables you to be discovered by other Groove users all around the world.  Select your preferred listing level, and then click “Finish”.

If you want to get up to speed quickly on the in’s and out’s of Groove, make sure you click “Yes” on the box that appears asking if you want to watch the “Getting Started Movie”.

So there you have it – How to set up your new (non-corporate) account in Groove 2007.  Easy!

’till next time!
TNP 😉

What is a .docx file?

There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007.  The comments are not about the default reminder time for appointments… but rather the default reminder time for follow up flags.  The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am).

I would like to discuss this a little to hopefully help everyone out. Whilst on the surface it might look annoying (especially for those how have just moved to Outlook 2007)… there is actually a good reason why the default reminder is 4pm.

First lets talk about Outlook 2003

In Outlook 2003, medications a follow up flag is a follow up flag. You set a time and a date for the reminder and that is that.

In Outlook 2007 however, price there are different types of follow up flags. There is a “Today” follow up flag, urticaria a “Tomorrow” follow up flag, a “This Week”, a “Next Week” and a “Custom”. Obviously, if you use a “Today” follow up flag (which is the default), it will remind you today. If you set a “Tomorrow” follow up flag, it will remind you tomorrow.

The “Today” flag is designed to remind you about things that you need to finish before you go home from work today… hence why it the default is for it to remind you 1 hour before the end of your work day (which would be 4pm in most cases).

As the “Tomorrow” flag is designed to remind you about things to do tomorrow, it will remind you by default at the start of the next work day (8am in most cases).

So say you want to have your default reminder first thing tomorrow morning? Then it is easy to change the default flag that is set. Simply right click on where you currently set your flag, and then in the pop up menu click on “Set Quick Click”. Change the default to “Tomorrow” and your default reminders will now be 8am on the next business day.

Hope that helps clear up some of the confusion around follow up flags. I can understand why it would be confusion coming from Outlook 2003, however with the new flexibility to set different types of flags, Outlook 2007 gives you a lot more control over when you get your reminders.

’till next time!
TNP 😉

PS. If you want to learn more about the default times, you can look at this Office Online help page – http://office.microsoft.com/en-us/outlook/HA012317831033.aspx

Are you an Office freak from down-under?

On the weekend of the 15th and 16th of November, try a group of Aussie Office fanatics are putting together a conference called Office DevCon2008.  From what is on the agenda it looks like a great event for anyone involved in managing Office products in their workplace, seek or for those interested in getting a little more intimate with the Office 2007 suite, patient SharePoint and more.

Registration is free… and there might be sneak previews of Office 14 as well!

If you are in Sydney in mid November, make sure you check it out.  You never know, you might bump into yours truly there as well 🙂

You can find out more by visiting the Office DevCon 2008 website

’till next time!
TNP 😉

So… you are sneaky.  You have some precious data you want to keep hidden.  Or your not so sneaky and just have some word documents that no one else should really see – for privacy or security or other reasons.  Well it might be a good idea to use the encryption built into Office 2007.

The encryption in Word, sickness Excel, viagra buy and PowerPoint 2007 basically turns your files into a mess that no one can read… unless they have the password.  In fact unless you get the password right, visit this there is no chance you can even open the file.

Before I let you know how to do it, I will quickly let you know about how strong this encryption really is.  In Office 2007 they use something called AES (Advanced Encryption Standard) with a 128-bit key and SHA-1 hashing.  That probably sounds like a mouthful for most people, but let me put it into perspective.  This level of protection can be used to encrypt classified information up to the SECRET level in the US Government.  If it is that good, chances are your data will be safe (that is if you remember the password!)

To encrypt your document in Word 2007, Excel 2007, or PowerPoint 2007, it is really easy!

1) Click on the Office Orb
2) Go to the “Prepare” section
3) Click on “Encrypt Document”
4) Type in your secret password and click OK
5) Retype your secret password and click OK

I can not stress enough that you need to remember what that password is… because if you forget it, there is no chance you will ever open that document again – it is strong encryption!

’till next time!
TNP 😉

PS – if you want to read more about the level of encryption, check out this article on Wikipedia – http://en.wikipedia.org/wiki/Advanced_Encryption_Standard.  And if you really want to get into the nitty-gritty of Cryptography in Office 2007… visit David LeBlanc’s weblog, and in particular this article – http://blogs.msdn.com/david_leblanc/archive/2008/07/03/office-crypto-follies.aspx
So… you are sneaky.  You have some precious data you want to keep hidden.  Or your not so sneaky and just have some word documents that no one else should really see – for privacy or security or other reasons.  Well it might be a good idea to use the encryption built into Office 2007.

The encryption in Word, apoplectic Excel, page and PowerPoint 2007 basically turns your files into a mess that no one can read… unless they have the password.  In fact unless you get the password right, page there is no chance you can even open the file.

Before I let you know how to do it, I will quickly let you know about how strong this encryption really is.  In Office 2007 they use something called AES (Advanced Encryption Standard) with a 128-bit key and SHA-1 hashing.  That probably sounds like a mouthful for most people, but let me put it into perspective.  This level of protection can be used to encrypt classified information up to the SECRET level in the US Government.  If it is that good, chances are your data will be safe (that is if you remember the password!)

To encrypt your document in Word 2007, Excel 2007, or PowerPoint 2007, it is really easy!

1) Click on the Office Orb
2) Go to the “Prepare” section
3) Click on “Encrypt Document”
4) Type in your secret password and click OK
5) Retype your secret password and click OK

I can not stress enough that you need to remember what that password is… because if you forget it, there is no chance you will ever open that document again – it is strong encryption!

’till next time!
TNP 😉

PS – if you want to read more about the level of encryption, check out this article on Wikipedia – http://en.wikipedia.org/wiki/Advanced_Encryption_Standard.  And if you really want to get into the nitty-gritty of Cryptography in Office 2007… visit David LeBlanc’s weblog, and in particular this article – http://blogs.msdn.com/david_leblanc/archive/2008/07/03/office-crypto-follies.aspx

So… your sneaky.  You have some precious data you want to keep hidden.  Or your not so sneaky and just have some word documents that no one else should really see – for privacy or security or other reasons.  Well it might be a good idea to use the encryption built into Office 2007.

The encryption in Word, health Excel, viagra and PowerPoint 2007 basically turns your files into a mess that no one can read… unless they have the password.  In fact unless you get the password right, there is no chance you can even open the file.

Before I let you know how to do it, I will quickly let you know about how strong this encryption really is.  In Office 2007 they use something called AES (Advanced Encryption Standard) with a 128-bit key and SHA-1 hashing.  That probably sounds like a mouthful for most people, but let me put it into perspective.  This level of protection can be used to encrypt classified information up to the SECRET level in the US Government.  If it is that good, chances are your data will be safe (that is if you remember the password!)

To encrypt your document in Word 2007, Excel 2007, or PowerPoint 2007, it is really easy!

1) Click on the Office Orb
2) Go to the “Prepare” section
3) Click on “Encrypt Document”
4) Type in your secret password and click OK
5) Retype your secret password and click OK

I can not stress enough that you need to remember what that password is… because if you forget it, there is no chance you will ever open that document again – it is strong encryption!

’till next time!
TNP 😉

PS – if you want to read more about the level of encryption, check out this article on Wikipedia – http://en.wikipedia.org/wiki/Advanced_Encryption_Standard.  And if you really want to get into the nitty-gritty of Cryptography in Office 2007… visit David LeBlanc’s weblog, and in particular this article – http://blogs.msdn.com/david_leblanc/archive/2008/07/03/office-crypto-follies.aspx

Has someone sent you a file where the filename ends in .docx?  Don’t know what is is, pharm how to open it?

Well I am about to tell you all about it 🙂

.docx is the new file extension for Word 2007 files (file extension is a complicated way of saying the bit at the end of the filename).  It is what files created in the new version of Word are saved in by default.

If you don’t have Word 2007, there are a couple of options you can choose to open the file.

1) Ask your friend or colleague to re-save it for Word 97-2003 and then send it to you again.  This would have to be the most pain free way of doing it – make your friend do all the work 🙂

2) Download the free Compatibility Pack for the 2007 Office system from Microsoft.  This will allow you to open Word documents in the docx format using Word 2003.  You can find out more about it here – http://office.microsoft.com/en-us/word/HA100444731033.aspx

3) Buy or upgrade to Word 2007.  This is a bit more of a personal choice – if you can afford it Word 2007 (in fact the rest of Office 2007 as well) is in my opinion a whole lot easier to use than the 2003 versions once you get used to them.  But again if upgrading is not an option price wise, then the first two options will work just fine for you.

 

 

So there you have it – what is, and how to open a docx file.  Just in case you run into them in the future, other Office 2007 programs have similar file extensions.  For example, PowerPoint files that used to be ppt, are now pptx.  Likewise, Excel files that used to be xls, are now xlsx.

’till next time!
TNP 😉