Add Commas to your numbers in Excel 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 😉

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 😉

Have you spent hours working on the perfect project plan, buy cialis with literally hundreds, no rx
if not thousands of tasks!  Chances are you might have mistyped a few things.

Luckily Project 2007 has the same great spell checking ability you will find in other Microsoft Office products.

To spell check your Project in Project 2007

1) Click on “Tools”

2) Click “Spelling”

or… just use the “F7” key on your keyboard!

 

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

Have you spent hours working on the perfect project plan, buy cialis with literally hundreds, no rx
if not thousands of tasks!  Chances are you might have mistyped a few things.

Luckily Project 2007 has the same great spell checking ability you will find in other Microsoft Office products.

To spell check your Project in Project 2007

1) Click on “Tools”

2) Click “Spelling”

or… just use the “F7” key on your keyboard!

 

‘till next time!
TNP 😉

Have you ever had a little bit too much text to fit into a cell in Excel 2007.  Maybe it is a description of a product, bronchi
a company name, for sale or simply lots of information you need to see without having to resize your columns!

Well there is an easy way to ensure you can see all that information when you need to.  You need to wrap your text!

What is wrapping text?  Wrapping text simply breaks the text into multiple lines, find
instead of one long line, and it is really easy to do!

How do you do it?

1) Select the cell (or cells) in which you want to wrap the text

2) On the “Home” tab in the Ribbon, look for the “Alignment” group

3) Click on “Wrap Text”

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

Have you spent hours working on the perfect project plan, buy cialis with literally hundreds, no rx
if not thousands of tasks!  Chances are you might have mistyped a few things.

Luckily Project 2007 has the same great spell checking ability you will find in other Microsoft Office products.

To spell check your Project in Project 2007

1) Click on “Tools”

2) Click “Spelling”

or… just use the “F7” key on your keyboard!

 

‘till next time!
TNP 😉

Have you ever had a little bit too much text to fit into a cell in Excel 2007.  Maybe it is a description of a product, bronchi
a company name, for sale or simply lots of information you need to see without having to resize your columns!

Well there is an easy way to ensure you can see all that information when you need to.  You need to wrap your text!

What is wrapping text?  Wrapping text simply breaks the text into multiple lines, find
instead of one long line, and it is really easy to do!

How do you do it?

1) Select the cell (or cells) in which you want to wrap the text

2) On the “Home” tab in the Ribbon, look for the “Alignment” group

3) Click on “Wrap Text”

‘till next time!
TNP 😉

Don’t you hate how you put lots of effort into a Word 2007 document, more about
and then you see one of your colleagues play around with the formatting, approved
or accidentally delete an important section.

Or maybe you want to force users of your document to only edit certain parts – for example if you have built a form that you want people to fill in.

Well in Word 2007 there is a great feature which can literally protect the important parts of your document, and restrict them from being changed, edited or deleted.  Funnily enough, it is called “Protect Document”

So how do you protect a Word 2007 document?

1) Create your document

2) Make sure you can see the “Developer” tab in the Ribbon.  If you can, move to step three!  If not, you need to click on the “Office Orb” in the top left hand corner, then click on “Word Options”, and finally whilst in the “Popular” section, make sure you check “Show Developer tab in the Ribbon”

3) Click on the “Developer” tab in the Ribbon

4) Look for the “Protect” group, and click on “Protect Document”

5) Click on “Restrict Formatting and Editing”

6) Look at the right hand side.  You will now see a task pane which will talk you through all the different formatting and editing restrictions you can put in place.  Select your favourite settings, and when you are ready…

7) Click on “Yes, Start Enforcing Protection”

 

Now if your employer has gone to the lengths of implementing an Information Rights Management system, there are a few other extra restrictions you can put in place, which you will find when you click on the “Protect Document” button in the Ribbon.  They are out of the scope of this article and I am sure I will write about them in the future as more and more organisations implement IRM.

So there you have it – now you can sleep at night knowing that no one is messing with your document!

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

Have you spent hours working on the perfect project plan, buy cialis with literally hundreds, no rx
if not thousands of tasks!  Chances are you might have mistyped a few things.

Luckily Project 2007 has the same great spell checking ability you will find in other Microsoft Office products.

To spell check your Project in Project 2007

1) Click on “Tools”

2) Click “Spelling”

or… just use the “F7” key on your keyboard!

 

‘till next time!
TNP 😉

Have you ever had a little bit too much text to fit into a cell in Excel 2007.  Maybe it is a description of a product, bronchi
a company name, for sale or simply lots of information you need to see without having to resize your columns!

Well there is an easy way to ensure you can see all that information when you need to.  You need to wrap your text!

What is wrapping text?  Wrapping text simply breaks the text into multiple lines, find
instead of one long line, and it is really easy to do!

How do you do it?

1) Select the cell (or cells) in which you want to wrap the text

2) On the “Home” tab in the Ribbon, look for the “Alignment” group

3) Click on “Wrap Text”

‘till next time!
TNP 😉

Don’t you hate how you put lots of effort into a Word 2007 document, more about
and then you see one of your colleagues play around with the formatting, approved
or accidentally delete an important section.

Or maybe you want to force users of your document to only edit certain parts – for example if you have built a form that you want people to fill in.

Well in Word 2007 there is a great feature which can literally protect the important parts of your document, and restrict them from being changed, edited or deleted.  Funnily enough, it is called “Protect Document”

So how do you protect a Word 2007 document?

1) Create your document

2) Make sure you can see the “Developer” tab in the Ribbon.  If you can, move to step three!  If not, you need to click on the “Office Orb” in the top left hand corner, then click on “Word Options”, and finally whilst in the “Popular” section, make sure you check “Show Developer tab in the Ribbon”

3) Click on the “Developer” tab in the Ribbon

4) Look for the “Protect” group, and click on “Protect Document”

5) Click on “Restrict Formatting and Editing”

6) Look at the right hand side.  You will now see a task pane which will talk you through all the different formatting and editing restrictions you can put in place.  Select your favourite settings, and when you are ready…

7) Click on “Yes, Start Enforcing Protection”

 

Now if your employer has gone to the lengths of implementing an Information Rights Management system, there are a few other extra restrictions you can put in place, which you will find when you click on the “Protect Document” button in the Ribbon.  They are out of the scope of this article and I am sure I will write about them in the future as more and more organisations implement IRM.

So there you have it – now you can sleep at night knowing that no one is messing with your document!

‘till next time!
TNP 😉

Are you keeping your meeting minutes in OneNote 2007?  Well it would be a great idea to put all the details of the meeting at the top of your OneNote 2007 page right?

Well you can stop opening up Outlook, capsule
double clicking on the meeting, see copying the details, eczema
opening up OneNote, finding the right Notebook and the right page… and then paste (what a relief!)

So how can you save all that pain?

1) Make sure you have Outlook 2007 open!

2) Open up OneNote 2007 and find the page you want to work on

3) Click on the “Insert Menu”

4) Click on “Insert Outlook Meeting Details”

5) Select the Meeting you want to insert

6) Click “Insert Details”

 

This inserts a great summary of the meeting into your OneNote 2007 Notebook, including the name of the meeting, the Date and Location, the Attendees, and any of the details you included in the original meeting request.

What a great time saver!

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

Have you spent hours working on the perfect project plan, buy cialis with literally hundreds, no rx
if not thousands of tasks!  Chances are you might have mistyped a few things.

Luckily Project 2007 has the same great spell checking ability you will find in other Microsoft Office products.

To spell check your Project in Project 2007

1) Click on “Tools”

2) Click “Spelling”

or… just use the “F7” key on your keyboard!

 

‘till next time!
TNP 😉

Have you ever had a little bit too much text to fit into a cell in Excel 2007.  Maybe it is a description of a product, bronchi
a company name, for sale or simply lots of information you need to see without having to resize your columns!

Well there is an easy way to ensure you can see all that information when you need to.  You need to wrap your text!

What is wrapping text?  Wrapping text simply breaks the text into multiple lines, find
instead of one long line, and it is really easy to do!

How do you do it?

1) Select the cell (or cells) in which you want to wrap the text

2) On the “Home” tab in the Ribbon, look for the “Alignment” group

3) Click on “Wrap Text”

‘till next time!
TNP 😉

Don’t you hate how you put lots of effort into a Word 2007 document, more about
and then you see one of your colleagues play around with the formatting, approved
or accidentally delete an important section.

Or maybe you want to force users of your document to only edit certain parts – for example if you have built a form that you want people to fill in.

Well in Word 2007 there is a great feature which can literally protect the important parts of your document, and restrict them from being changed, edited or deleted.  Funnily enough, it is called “Protect Document”

So how do you protect a Word 2007 document?

1) Create your document

2) Make sure you can see the “Developer” tab in the Ribbon.  If you can, move to step three!  If not, you need to click on the “Office Orb” in the top left hand corner, then click on “Word Options”, and finally whilst in the “Popular” section, make sure you check “Show Developer tab in the Ribbon”

3) Click on the “Developer” tab in the Ribbon

4) Look for the “Protect” group, and click on “Protect Document”

5) Click on “Restrict Formatting and Editing”

6) Look at the right hand side.  You will now see a task pane which will talk you through all the different formatting and editing restrictions you can put in place.  Select your favourite settings, and when you are ready…

7) Click on “Yes, Start Enforcing Protection”

 

Now if your employer has gone to the lengths of implementing an Information Rights Management system, there are a few other extra restrictions you can put in place, which you will find when you click on the “Protect Document” button in the Ribbon.  They are out of the scope of this article and I am sure I will write about them in the future as more and more organisations implement IRM.

So there you have it – now you can sleep at night knowing that no one is messing with your document!

‘till next time!
TNP 😉

Are you keeping your meeting minutes in OneNote 2007?  Well it would be a great idea to put all the details of the meeting at the top of your OneNote 2007 page right?

Well you can stop opening up Outlook, capsule
double clicking on the meeting, see copying the details, eczema
opening up OneNote, finding the right Notebook and the right page… and then paste (what a relief!)

So how can you save all that pain?

1) Make sure you have Outlook 2007 open!

2) Open up OneNote 2007 and find the page you want to work on

3) Click on the “Insert Menu”

4) Click on “Insert Outlook Meeting Details”

5) Select the Meeting you want to insert

6) Click “Insert Details”

 

This inserts a great summary of the meeting into your OneNote 2007 Notebook, including the name of the meeting, the Date and Location, the Attendees, and any of the details you included in the original meeting request.

What a great time saver!

‘till next time!
TNP 😉

Do you want a little extra space before a paragraph?  Or maybe you want a big break after one?  Well lucky for you you can change the spacing before and after each of your paragraphs in Word 2007.  And the best part is that you can be very granular in how much space you want there to be!

Here is how:

1) Select the paragraph or paragraphs you want to change the paragraph spacing of

2) In the “Ribbon”, ophthalmologist
make sure you are on the “Page Layout” tab

3) Look for the “Paragraph” group

4) Simply enter how much space you want before, or after your paragraph.  You can use “pt” points (just like your font size), or you can use cm, mm, inches.

Now you can get your paragraphs to sit exactly where you want them to!

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

Have you spent hours working on the perfect project plan, buy cialis with literally hundreds, no rx
if not thousands of tasks!  Chances are you might have mistyped a few things.

Luckily Project 2007 has the same great spell checking ability you will find in other Microsoft Office products.

To spell check your Project in Project 2007

1) Click on “Tools”

2) Click “Spelling”

or… just use the “F7” key on your keyboard!

 

‘till next time!
TNP 😉

Have you ever had a little bit too much text to fit into a cell in Excel 2007.  Maybe it is a description of a product, bronchi
a company name, for sale or simply lots of information you need to see without having to resize your columns!

Well there is an easy way to ensure you can see all that information when you need to.  You need to wrap your text!

What is wrapping text?  Wrapping text simply breaks the text into multiple lines, find
instead of one long line, and it is really easy to do!

How do you do it?

1) Select the cell (or cells) in which you want to wrap the text

2) On the “Home” tab in the Ribbon, look for the “Alignment” group

3) Click on “Wrap Text”

‘till next time!
TNP 😉

Don’t you hate how you put lots of effort into a Word 2007 document, more about
and then you see one of your colleagues play around with the formatting, approved
or accidentally delete an important section.

Or maybe you want to force users of your document to only edit certain parts – for example if you have built a form that you want people to fill in.

Well in Word 2007 there is a great feature which can literally protect the important parts of your document, and restrict them from being changed, edited or deleted.  Funnily enough, it is called “Protect Document”

So how do you protect a Word 2007 document?

1) Create your document

2) Make sure you can see the “Developer” tab in the Ribbon.  If you can, move to step three!  If not, you need to click on the “Office Orb” in the top left hand corner, then click on “Word Options”, and finally whilst in the “Popular” section, make sure you check “Show Developer tab in the Ribbon”

3) Click on the “Developer” tab in the Ribbon

4) Look for the “Protect” group, and click on “Protect Document”

5) Click on “Restrict Formatting and Editing”

6) Look at the right hand side.  You will now see a task pane which will talk you through all the different formatting and editing restrictions you can put in place.  Select your favourite settings, and when you are ready…

7) Click on “Yes, Start Enforcing Protection”

 

Now if your employer has gone to the lengths of implementing an Information Rights Management system, there are a few other extra restrictions you can put in place, which you will find when you click on the “Protect Document” button in the Ribbon.  They are out of the scope of this article and I am sure I will write about them in the future as more and more organisations implement IRM.

So there you have it – now you can sleep at night knowing that no one is messing with your document!

‘till next time!
TNP 😉

Are you keeping your meeting minutes in OneNote 2007?  Well it would be a great idea to put all the details of the meeting at the top of your OneNote 2007 page right?

Well you can stop opening up Outlook, capsule
double clicking on the meeting, see copying the details, eczema
opening up OneNote, finding the right Notebook and the right page… and then paste (what a relief!)

So how can you save all that pain?

1) Make sure you have Outlook 2007 open!

2) Open up OneNote 2007 and find the page you want to work on

3) Click on the “Insert Menu”

4) Click on “Insert Outlook Meeting Details”

5) Select the Meeting you want to insert

6) Click “Insert Details”

 

This inserts a great summary of the meeting into your OneNote 2007 Notebook, including the name of the meeting, the Date and Location, the Attendees, and any of the details you included in the original meeting request.

What a great time saver!

‘till next time!
TNP 😉

Do you want a little extra space before a paragraph?  Or maybe you want a big break after one?  Well lucky for you you can change the spacing before and after each of your paragraphs in Word 2007.  And the best part is that you can be very granular in how much space you want there to be!

Here is how:

1) Select the paragraph or paragraphs you want to change the paragraph spacing of

2) In the “Ribbon”, ophthalmologist
make sure you are on the “Page Layout” tab

3) Look for the “Paragraph” group

4) Simply enter how much space you want before, or after your paragraph.  You can use “pt” points (just like your font size), or you can use cm, mm, inches.

Now you can get your paragraphs to sit exactly where you want them to!

‘till next time!
TNP 😉

So you have created your PowerPoint masterpiece!  But now you want to make sure a couple of the slides you put in don’t show up when you do your presentation.  Or maybe you have a few slides that are “work in progress”?  Either way there is a quick and easy way to make sure those slides do not show up on the big screen!

You can hide one, capsule
two, Hemophilia
three, otolaryngologist
four, five, ten, twenty, in fact as many slides as you want!  Here is how

1) Select the slides you want to hide

2) Right click on the slides you have selected, and click “Hide Slide”

Simple as that!

 

There is another way using the “Ribbon” if you prefer to do it that way

1) Select the slides you want to hide

2) Make sure you are on the “Slide Show” tab in the Ribbon

3) Look for the “Set Up” group

4) Click on the “Hide Slide” button

There you go!

 

But now you want to make your slides appear again?  Just do exactly the same!  Select the hidden slides you want to unhide, then click “Hide Slide” again!

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

Have you spent hours working on the perfect project plan, buy cialis with literally hundreds, no rx
if not thousands of tasks!  Chances are you might have mistyped a few things.

Luckily Project 2007 has the same great spell checking ability you will find in other Microsoft Office products.

To spell check your Project in Project 2007

1) Click on “Tools”

2) Click “Spelling”

or… just use the “F7” key on your keyboard!

 

‘till next time!
TNP 😉

Have you ever had a little bit too much text to fit into a cell in Excel 2007.  Maybe it is a description of a product, bronchi
a company name, for sale or simply lots of information you need to see without having to resize your columns!

Well there is an easy way to ensure you can see all that information when you need to.  You need to wrap your text!

What is wrapping text?  Wrapping text simply breaks the text into multiple lines, find
instead of one long line, and it is really easy to do!

How do you do it?

1) Select the cell (or cells) in which you want to wrap the text

2) On the “Home” tab in the Ribbon, look for the “Alignment” group

3) Click on “Wrap Text”

‘till next time!
TNP 😉

Don’t you hate how you put lots of effort into a Word 2007 document, more about
and then you see one of your colleagues play around with the formatting, approved
or accidentally delete an important section.

Or maybe you want to force users of your document to only edit certain parts – for example if you have built a form that you want people to fill in.

Well in Word 2007 there is a great feature which can literally protect the important parts of your document, and restrict them from being changed, edited or deleted.  Funnily enough, it is called “Protect Document”

So how do you protect a Word 2007 document?

1) Create your document

2) Make sure you can see the “Developer” tab in the Ribbon.  If you can, move to step three!  If not, you need to click on the “Office Orb” in the top left hand corner, then click on “Word Options”, and finally whilst in the “Popular” section, make sure you check “Show Developer tab in the Ribbon”

3) Click on the “Developer” tab in the Ribbon

4) Look for the “Protect” group, and click on “Protect Document”

5) Click on “Restrict Formatting and Editing”

6) Look at the right hand side.  You will now see a task pane which will talk you through all the different formatting and editing restrictions you can put in place.  Select your favourite settings, and when you are ready…

7) Click on “Yes, Start Enforcing Protection”

 

Now if your employer has gone to the lengths of implementing an Information Rights Management system, there are a few other extra restrictions you can put in place, which you will find when you click on the “Protect Document” button in the Ribbon.  They are out of the scope of this article and I am sure I will write about them in the future as more and more organisations implement IRM.

So there you have it – now you can sleep at night knowing that no one is messing with your document!

‘till next time!
TNP 😉

Are you keeping your meeting minutes in OneNote 2007?  Well it would be a great idea to put all the details of the meeting at the top of your OneNote 2007 page right?

Well you can stop opening up Outlook, capsule
double clicking on the meeting, see copying the details, eczema
opening up OneNote, finding the right Notebook and the right page… and then paste (what a relief!)

So how can you save all that pain?

1) Make sure you have Outlook 2007 open!

2) Open up OneNote 2007 and find the page you want to work on

3) Click on the “Insert Menu”

4) Click on “Insert Outlook Meeting Details”

5) Select the Meeting you want to insert

6) Click “Insert Details”

 

This inserts a great summary of the meeting into your OneNote 2007 Notebook, including the name of the meeting, the Date and Location, the Attendees, and any of the details you included in the original meeting request.

What a great time saver!

‘till next time!
TNP 😉

Do you want a little extra space before a paragraph?  Or maybe you want a big break after one?  Well lucky for you you can change the spacing before and after each of your paragraphs in Word 2007.  And the best part is that you can be very granular in how much space you want there to be!

Here is how:

1) Select the paragraph or paragraphs you want to change the paragraph spacing of

2) In the “Ribbon”, ophthalmologist
make sure you are on the “Page Layout” tab

3) Look for the “Paragraph” group

4) Simply enter how much space you want before, or after your paragraph.  You can use “pt” points (just like your font size), or you can use cm, mm, inches.

Now you can get your paragraphs to sit exactly where you want them to!

‘till next time!
TNP 😉

So you have created your PowerPoint masterpiece!  But now you want to make sure a couple of the slides you put in don’t show up when you do your presentation.  Or maybe you have a few slides that are “work in progress”?  Either way there is a quick and easy way to make sure those slides do not show up on the big screen!

You can hide one, capsule
two, Hemophilia
three, otolaryngologist
four, five, ten, twenty, in fact as many slides as you want!  Here is how

1) Select the slides you want to hide

2) Right click on the slides you have selected, and click “Hide Slide”

Simple as that!

 

There is another way using the “Ribbon” if you prefer to do it that way

1) Select the slides you want to hide

2) Make sure you are on the “Slide Show” tab in the Ribbon

3) Look for the “Set Up” group

4) Click on the “Hide Slide” button

There you go!

 

But now you want to make your slides appear again?  Just do exactly the same!  Select the hidden slides you want to unhide, then click “Hide Slide” again!

‘till next time!
TNP 😉

Do you spend hours making your cells in Excel look pretty?  Well maybe not pretty, health but do you use colors, healing font sizes, infertility
borders etc etc to make certain cells in your spreadsheet stick out?

Well instead of spending all your time trying to be one of those creative folk in Marketing, you can focus on doing what you do best… driving those formulas!

All you need to do is use Cell Styles in Excel 2007, Excel 2010 and Excel 2013!

1) Select the cell you want to highlight!

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

3) Look for the “Styles” Group

4) Click on “Cell Styles”

5) Select your favorite cell style!

It is as simple as that!

‘till next time!
TNP 😉

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 😉

Have you spent hours working on the perfect project plan, buy cialis with literally hundreds, no rx
if not thousands of tasks!  Chances are you might have mistyped a few things.

Luckily Project 2007 has the same great spell checking ability you will find in other Microsoft Office products.

To spell check your Project in Project 2007

1) Click on “Tools”

2) Click “Spelling”

or… just use the “F7” key on your keyboard!

 

‘till next time!
TNP 😉

Have you ever had a little bit too much text to fit into a cell in Excel 2007.  Maybe it is a description of a product, bronchi
a company name, for sale or simply lots of information you need to see without having to resize your columns!

Well there is an easy way to ensure you can see all that information when you need to.  You need to wrap your text!

What is wrapping text?  Wrapping text simply breaks the text into multiple lines, find
instead of one long line, and it is really easy to do!

How do you do it?

1) Select the cell (or cells) in which you want to wrap the text

2) On the “Home” tab in the Ribbon, look for the “Alignment” group

3) Click on “Wrap Text”

‘till next time!
TNP 😉

Don’t you hate how you put lots of effort into a Word 2007 document, more about
and then you see one of your colleagues play around with the formatting, approved
or accidentally delete an important section.

Or maybe you want to force users of your document to only edit certain parts – for example if you have built a form that you want people to fill in.

Well in Word 2007 there is a great feature which can literally protect the important parts of your document, and restrict them from being changed, edited or deleted.  Funnily enough, it is called “Protect Document”

So how do you protect a Word 2007 document?

1) Create your document

2) Make sure you can see the “Developer” tab in the Ribbon.  If you can, move to step three!  If not, you need to click on the “Office Orb” in the top left hand corner, then click on “Word Options”, and finally whilst in the “Popular” section, make sure you check “Show Developer tab in the Ribbon”

3) Click on the “Developer” tab in the Ribbon

4) Look for the “Protect” group, and click on “Protect Document”

5) Click on “Restrict Formatting and Editing”

6) Look at the right hand side.  You will now see a task pane which will talk you through all the different formatting and editing restrictions you can put in place.  Select your favourite settings, and when you are ready…

7) Click on “Yes, Start Enforcing Protection”

 

Now if your employer has gone to the lengths of implementing an Information Rights Management system, there are a few other extra restrictions you can put in place, which you will find when you click on the “Protect Document” button in the Ribbon.  They are out of the scope of this article and I am sure I will write about them in the future as more and more organisations implement IRM.

So there you have it – now you can sleep at night knowing that no one is messing with your document!

‘till next time!
TNP 😉

Are you keeping your meeting minutes in OneNote 2007?  Well it would be a great idea to put all the details of the meeting at the top of your OneNote 2007 page right?

Well you can stop opening up Outlook, capsule
double clicking on the meeting, see copying the details, eczema
opening up OneNote, finding the right Notebook and the right page… and then paste (what a relief!)

So how can you save all that pain?

1) Make sure you have Outlook 2007 open!

2) Open up OneNote 2007 and find the page you want to work on

3) Click on the “Insert Menu”

4) Click on “Insert Outlook Meeting Details”

5) Select the Meeting you want to insert

6) Click “Insert Details”

 

This inserts a great summary of the meeting into your OneNote 2007 Notebook, including the name of the meeting, the Date and Location, the Attendees, and any of the details you included in the original meeting request.

What a great time saver!

‘till next time!
TNP 😉

Do you want a little extra space before a paragraph?  Or maybe you want a big break after one?  Well lucky for you you can change the spacing before and after each of your paragraphs in Word 2007.  And the best part is that you can be very granular in how much space you want there to be!

Here is how:

1) Select the paragraph or paragraphs you want to change the paragraph spacing of

2) In the “Ribbon”, ophthalmologist
make sure you are on the “Page Layout” tab

3) Look for the “Paragraph” group

4) Simply enter how much space you want before, or after your paragraph.  You can use “pt” points (just like your font size), or you can use cm, mm, inches.

Now you can get your paragraphs to sit exactly where you want them to!

‘till next time!
TNP 😉

So you have created your PowerPoint masterpiece!  But now you want to make sure a couple of the slides you put in don’t show up when you do your presentation.  Or maybe you have a few slides that are “work in progress”?  Either way there is a quick and easy way to make sure those slides do not show up on the big screen!

You can hide one, capsule
two, Hemophilia
three, otolaryngologist
four, five, ten, twenty, in fact as many slides as you want!  Here is how

1) Select the slides you want to hide

2) Right click on the slides you have selected, and click “Hide Slide”

Simple as that!

 

There is another way using the “Ribbon” if you prefer to do it that way

1) Select the slides you want to hide

2) Make sure you are on the “Slide Show” tab in the Ribbon

3) Look for the “Set Up” group

4) Click on the “Hide Slide” button

There you go!

 

But now you want to make your slides appear again?  Just do exactly the same!  Select the hidden slides you want to unhide, then click “Hide Slide” again!

‘till next time!
TNP 😉

Do you spend hours making your cells in Excel look pretty?  Well maybe not pretty, health but do you use colors, healing font sizes, infertility
borders etc etc to make certain cells in your spreadsheet stick out?

Well instead of spending all your time trying to be one of those creative folk in Marketing, you can focus on doing what you do best… driving those formulas!

All you need to do is use Cell Styles in Excel 2007, Excel 2010 and Excel 2013!

1) Select the cell you want to highlight!

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

3) Look for the “Styles” Group

4) Click on “Cell Styles”

5) Select your favorite cell style!

It is as simple as that!

‘till next time!
TNP 😉

So you have typed all your data into Excel.  But your numbers don’t have those commas that you had on paper?  How do you add commas, capsule
or thousands separators to your numbers in Excel 2007?

1) Select the cells you want to have the commas (or thousands separators)

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

3) Look for the “Number” group

4) Click on the button that looks like a comma!

 

‘till next time!
TNP 😉

One thought on “Add Commas to your numbers in Excel 2007

Leave a Reply

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