Level 100 - Beginner

Have you spent hours working on the perfect project plan, with literally hundreds, 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

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

Have you been working on a spreadsheet, 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, and make sure you are on the “Home” tab

3) Look to the right, 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

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

• Erika Ehrli (Adventures in Office Development and .Net):
  Links for February 6th 2009: Workflow Development Resources Interactive Map, Join Us on Facebook, + Lots of New Articles and Downloads 
• The Office for Mac Team Blog:
  the MacBU Giving Campaign
• Inside Office Online:
  Raining pennies (and other cool effects)
• The Microsoft Office Word Team’s Blog:
  Advanced Comparison of Word Documents

‘till next time!
TNP

Are you new, or have just upgraded to Word 2007?  Since starting The New Paperclip over two years ago, 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, 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

They have been closed for a while now, 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:

• Word 2007 Forum
• Outlook 2007 Forum
• Excel 2007 Forum
• PowerPoint 2007 Forum
• Access 2007 Forum
• Groove 2007 Forum
• InfoPath 2007 Forum
• OneNote 2007 Forum
• Project 2007 Forum
• Publisher 2007 Forum
• SharePoint Designer 2007 Forum
• Visio 2007 Forum

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

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

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

All you need to do is register using this form

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

’till next time!
TNP

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

But what if you didn’t get any?

Well did you know you can create your own calendars nice and quickly with Word 2007!

All you need to do is to open a new document by clicking on the “Office Orb” (the old file menu in the top left hand corner of Word), and then clicking “New”

On the New Document dialog box that appears, you will see down the left hand side a wide range of templates that are available to you.  Down in the “Microsoft Office Online” section, you will find a “Calendars” option – click on that!

Word will connect to Microsoft Office Online, and give you a wide variety of calendar options.  For your 2009 calendar, click on “2009 calendars”.  For other options such as multiple year calendars, simply click on those.

Once you click on “2009 calendars” you will see a few dozen different options to choose from – different calendar structures and different calendar designs.

My favourite, especially if you want to add your own pictures to the calendar is the “2009 Picture Calendar Featured at Office Online”.  Great for family pictures!

’till next time!
TNP

Hi all,

TNP here.  Hope all my friends in North America have had a fantastic Thanks Giving holiday… and for those of you in other parts, hope life is treating you well.

Those of you that have been here before will notice that I put a new lick of paint on the site over the weekend – I hope you like the new fresh look.

Hopefully little changes like increasing the font size, and more white space will make it easier for you to quickly read and understand exactly what you need to do to solve your Office 2007 problems!

Thanks again to everyone who visits – we are talking 10s of thousands of you every couple of weeks… I certainly appreciate your support

Whilst talking about your amazing support… if you have any suggestions for topics, or how we can improve things around here.. please drop me a line via the comments section below!

’till next time!
TNP