Archive for February, 2009

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

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