Create a new Search Folder in Outlook 2007


Who else wants to know the secret to Excel Formulas?

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



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 😉

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 😉

Hi everyone!

I am very proud to announce that today The New Paperclip was listed on Alltop.

Alltop is best described as an online magazine rack that helps you keep up to date with all the top news from around the world.  The New Paperclip is now featured in the Top Microsoft Office News section!

It wouldn’t have happened without all your support, pilule
so a big thank you to everyone in the “The New Paperclip” community!

In the spirit of community, here are a few links to a few of the top articles being featured right now in the Microsoft Office section of Alltop!

‘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 😉

Hi everyone!

I am very proud to announce that today The New Paperclip was listed on Alltop.

Alltop is best described as an online magazine rack that helps you keep up to date with all the top news from around the world.  The New Paperclip is now featured in the Top Microsoft Office News section!

It wouldn’t have happened without all your support, pilule
so a big thank you to everyone in the “The New Paperclip” community!

In the spirit of community, here are a few links to a few of the top articles being featured right now in the Microsoft Office section of Alltop!

‘till next time!
TNP 😉

Have you been working on a spreadsheet, sale but then suddenly realised that you need to add another column?

Well there are a couple of ways to add a column to your spreadsheet in Excel 2007.

The long way

1) Select the cell that is to the right of where you want the new column to appear

2) Look at the ribbon, see
and make sure you are on the “Home” tab

3) Look to the right, buy
and you will see the “Cells” group

4) Click on “Insert”, and then select “Insert Sheet Columns”

 

The short way

1) Right click on the top of the column (the letter) that is to the right of where you want the new column to appear

2) Click “Insert” from the menu that appears

 

If you want to add two or more columns, you can use one of the methods above, and simply use the “Redo” command to keep inserting new columns – either use the button in the top left hand corner (in the Quick Access Toolbar), or simply use the shortcut – CTRL+Y

‘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 😉

Hi everyone!

I am very proud to announce that today The New Paperclip was listed on Alltop.

Alltop is best described as an online magazine rack that helps you keep up to date with all the top news from around the world.  The New Paperclip is now featured in the Top Microsoft Office News section!

It wouldn’t have happened without all your support, pilule
so a big thank you to everyone in the “The New Paperclip” community!

In the spirit of community, here are a few links to a few of the top articles being featured right now in the Microsoft Office section of Alltop!

‘till next time!
TNP 😉

Have you been working on a spreadsheet, sale but then suddenly realised that you need to add another column?

Well there are a couple of ways to add a column to your spreadsheet in Excel 2007.

The long way

1) Select the cell that is to the right of where you want the new column to appear

2) Look at the ribbon, see
and make sure you are on the “Home” tab

3) Look to the right, buy
and you will see the “Cells” group

4) Click on “Insert”, and then select “Insert Sheet Columns”

 

The short way

1) Right click on the top of the column (the letter) that is to the right of where you want the new column to appear

2) Click “Insert” from the menu that appears

 

If you want to add two or more columns, you can use one of the methods above, and simply use the “Redo” command to keep inserting new columns – either use the button in the top left hand corner (in the Quick Access Toolbar), or simply use the shortcut – CTRL+Y

‘till next time!
TNP 😉

Are you writing a report, approved
an assignment, nurse
or just a plain old document and need to hyphenate you paragraphs?

By default, Word 2007 has hyphenation turned off, but it is really easy to turn it on, and there are a number of options to control how the hyphenation works.

To turn on hyphenation in Word 2007 to hyphenate your document, simply:

1) Go to the “Page Layout” tab on the Ribbon

2) Look for the “Page Setup” group

3) Click on “Hyphenation”

4) Select “Automatic”

 

Now that your document is hyphenated, lets look at the settings you can change to control exactly how the hyphenation works!

5) Click on “Hyphenation” again

6) Click on “Hyphenation Options…”

 

In the box that appears, there are two key settings you can play with.  The first is the “Hyphenation zone”, and the second is “Limit consecutive hyphens to”.  Change these settings to adjust the hyphenation to meet your needs!

‘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 😉

Hi everyone!

I am very proud to announce that today The New Paperclip was listed on Alltop.

Alltop is best described as an online magazine rack that helps you keep up to date with all the top news from around the world.  The New Paperclip is now featured in the Top Microsoft Office News section!

It wouldn’t have happened without all your support, pilule
so a big thank you to everyone in the “The New Paperclip” community!

In the spirit of community, here are a few links to a few of the top articles being featured right now in the Microsoft Office section of Alltop!

‘till next time!
TNP 😉

Have you been working on a spreadsheet, sale but then suddenly realised that you need to add another column?

Well there are a couple of ways to add a column to your spreadsheet in Excel 2007.

The long way

1) Select the cell that is to the right of where you want the new column to appear

2) Look at the ribbon, see
and make sure you are on the “Home” tab

3) Look to the right, buy
and you will see the “Cells” group

4) Click on “Insert”, and then select “Insert Sheet Columns”

 

The short way

1) Right click on the top of the column (the letter) that is to the right of where you want the new column to appear

2) Click “Insert” from the menu that appears

 

If you want to add two or more columns, you can use one of the methods above, and simply use the “Redo” command to keep inserting new columns – either use the button in the top left hand corner (in the Quick Access Toolbar), or simply use the shortcut – CTRL+Y

‘till next time!
TNP 😉

Are you writing a report, approved
an assignment, nurse
or just a plain old document and need to hyphenate you paragraphs?

By default, Word 2007 has hyphenation turned off, but it is really easy to turn it on, and there are a number of options to control how the hyphenation works.

To turn on hyphenation in Word 2007 to hyphenate your document, simply:

1) Go to the “Page Layout” tab on the Ribbon

2) Look for the “Page Setup” group

3) Click on “Hyphenation”

4) Select “Automatic”

 

Now that your document is hyphenated, lets look at the settings you can change to control exactly how the hyphenation works!

5) Click on “Hyphenation” again

6) Click on “Hyphenation Options…”

 

In the box that appears, there are two key settings you can play with.  The first is the “Hyphenation zone”, and the second is “Limit consecutive hyphens to”.  Change these settings to adjust the hyphenation to meet your needs!

‘till next time!
TNP 😉

Are you lazy like me and feel that clicking your mouse to change slides in PowerPoint 2007 is not a good use of your time?

Maybe not!

… but maybe you just want a series of slides to advance automatically whilst you talk to your PowerPoint deck.  Well with PowerPoint 2007 it is easy.

1) Select the slides you want to have automatically advance

2) In the Ribbon, pathopsychology
make sure you are on the “Animations” tab

3) Look to the far right hand side, find
and make sure you check “Automatically After”

4) Beside that checkbox, visit this site
enter the number of seconds you want to the slide wait before it automatically transitions to the next.

Simple as that!  Whilst you are there, you can also change the transition – whether you want a fade, dissolve, wipe, push and cover, or stripes and bars – just choose your favourite from the transition gallery!

‘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 😉

Hi everyone!

I am very proud to announce that today The New Paperclip was listed on Alltop.

Alltop is best described as an online magazine rack that helps you keep up to date with all the top news from around the world.  The New Paperclip is now featured in the Top Microsoft Office News section!

It wouldn’t have happened without all your support, pilule
so a big thank you to everyone in the “The New Paperclip” community!

In the spirit of community, here are a few links to a few of the top articles being featured right now in the Microsoft Office section of Alltop!

‘till next time!
TNP 😉

Have you been working on a spreadsheet, sale but then suddenly realised that you need to add another column?

Well there are a couple of ways to add a column to your spreadsheet in Excel 2007.

The long way

1) Select the cell that is to the right of where you want the new column to appear

2) Look at the ribbon, see
and make sure you are on the “Home” tab

3) Look to the right, buy
and you will see the “Cells” group

4) Click on “Insert”, and then select “Insert Sheet Columns”

 

The short way

1) Right click on the top of the column (the letter) that is to the right of where you want the new column to appear

2) Click “Insert” from the menu that appears

 

If you want to add two or more columns, you can use one of the methods above, and simply use the “Redo” command to keep inserting new columns – either use the button in the top left hand corner (in the Quick Access Toolbar), or simply use the shortcut – CTRL+Y

‘till next time!
TNP 😉

Are you writing a report, approved
an assignment, nurse
or just a plain old document and need to hyphenate you paragraphs?

By default, Word 2007 has hyphenation turned off, but it is really easy to turn it on, and there are a number of options to control how the hyphenation works.

To turn on hyphenation in Word 2007 to hyphenate your document, simply:

1) Go to the “Page Layout” tab on the Ribbon

2) Look for the “Page Setup” group

3) Click on “Hyphenation”

4) Select “Automatic”

 

Now that your document is hyphenated, lets look at the settings you can change to control exactly how the hyphenation works!

5) Click on “Hyphenation” again

6) Click on “Hyphenation Options…”

 

In the box that appears, there are two key settings you can play with.  The first is the “Hyphenation zone”, and the second is “Limit consecutive hyphens to”.  Change these settings to adjust the hyphenation to meet your needs!

‘till next time!
TNP 😉

Are you lazy like me and feel that clicking your mouse to change slides in PowerPoint 2007 is not a good use of your time?

Maybe not!

… but maybe you just want a series of slides to advance automatically whilst you talk to your PowerPoint deck.  Well with PowerPoint 2007 it is easy.

1) Select the slides you want to have automatically advance

2) In the Ribbon, pathopsychology
make sure you are on the “Animations” tab

3) Look to the far right hand side, find
and make sure you check “Automatically After”

4) Beside that checkbox, visit this site
enter the number of seconds you want to the slide wait before it automatically transitions to the next.

Simple as that!  Whilst you are there, you can also change the transition – whether you want a fade, dissolve, wipe, push and cover, or stripes and bars – just choose your favourite from the transition gallery!

‘till next time!
TNP 😉

Do you need to find a phone number of one of your colleagues?  Well if you have Office Communicator 2007 you can quickly look up their digits.

1) Find the person in your contact list, approved
or using the Search feature

2) Look for the phone beside their name

3) Hover your mouse over the phone, and click on the little arrow that appears

4) You will find the phone number on the fly-out menu

 

‘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 😉

Hi everyone!

I am very proud to announce that today The New Paperclip was listed on Alltop.

Alltop is best described as an online magazine rack that helps you keep up to date with all the top news from around the world.  The New Paperclip is now featured in the Top Microsoft Office News section!

It wouldn’t have happened without all your support, pilule
so a big thank you to everyone in the “The New Paperclip” community!

In the spirit of community, here are a few links to a few of the top articles being featured right now in the Microsoft Office section of Alltop!

‘till next time!
TNP 😉

Have you been working on a spreadsheet, sale but then suddenly realised that you need to add another column?

Well there are a couple of ways to add a column to your spreadsheet in Excel 2007.

The long way

1) Select the cell that is to the right of where you want the new column to appear

2) Look at the ribbon, see
and make sure you are on the “Home” tab

3) Look to the right, buy
and you will see the “Cells” group

4) Click on “Insert”, and then select “Insert Sheet Columns”

 

The short way

1) Right click on the top of the column (the letter) that is to the right of where you want the new column to appear

2) Click “Insert” from the menu that appears

 

If you want to add two or more columns, you can use one of the methods above, and simply use the “Redo” command to keep inserting new columns – either use the button in the top left hand corner (in the Quick Access Toolbar), or simply use the shortcut – CTRL+Y

‘till next time!
TNP 😉

Are you writing a report, approved
an assignment, nurse
or just a plain old document and need to hyphenate you paragraphs?

By default, Word 2007 has hyphenation turned off, but it is really easy to turn it on, and there are a number of options to control how the hyphenation works.

To turn on hyphenation in Word 2007 to hyphenate your document, simply:

1) Go to the “Page Layout” tab on the Ribbon

2) Look for the “Page Setup” group

3) Click on “Hyphenation”

4) Select “Automatic”

 

Now that your document is hyphenated, lets look at the settings you can change to control exactly how the hyphenation works!

5) Click on “Hyphenation” again

6) Click on “Hyphenation Options…”

 

In the box that appears, there are two key settings you can play with.  The first is the “Hyphenation zone”, and the second is “Limit consecutive hyphens to”.  Change these settings to adjust the hyphenation to meet your needs!

‘till next time!
TNP 😉

Are you lazy like me and feel that clicking your mouse to change slides in PowerPoint 2007 is not a good use of your time?

Maybe not!

… but maybe you just want a series of slides to advance automatically whilst you talk to your PowerPoint deck.  Well with PowerPoint 2007 it is easy.

1) Select the slides you want to have automatically advance

2) In the Ribbon, pathopsychology
make sure you are on the “Animations” tab

3) Look to the far right hand side, find
and make sure you check “Automatically After”

4) Beside that checkbox, visit this site
enter the number of seconds you want to the slide wait before it automatically transitions to the next.

Simple as that!  Whilst you are there, you can also change the transition – whether you want a fade, dissolve, wipe, push and cover, or stripes and bars – just choose your favourite from the transition gallery!

‘till next time!
TNP 😉

Do you need to find a phone number of one of your colleagues?  Well if you have Office Communicator 2007 you can quickly look up their digits.

1) Find the person in your contact list, approved
or using the Search feature

2) Look for the phone beside their name

3) Hover your mouse over the phone, and click on the little arrow that appears

4) You will find the phone number on the fly-out menu

 

‘till next time!
TNP 😉

Search folders are one of the great new features of Outlook 2007 that can really help you be more productive.  Essentially they are a view of your inbox based on certain criteria that you can pick yourself. 

For example, tuberculosis
maybe you want a search folder that shows you all your emails from your boss?  Or a folder that shows you all the emails you have over 200kb?

Outlook 2007 comes setup with a few default search folders, tadalafil
like “Unread Mail”.  That being said, it is really easy to set up your own.

1) Click on the little arrow beside the “New” button in the top left hand corner of your Outlook 2007 window

2) In the drop-down menu that appears, click on “Search Folder” (or just use the shortcut – CTRL+SHFT+P)

3) In the box that appears, start to select the criteria you want to use

4) Depending on what you just chose, fill in the box below – for example, if you want to show all the emails from your boss… put their email address in there

5) Click “OK”

 

Now you can keep track of your email by looking at it in different ways… and make sure you know where your boss’s emails are just in case they come asking questions!

‘till next time!
TNP 😉

Leave a Reply

Your email address will not be published. Required fields are marked *