Jun 29 2010

Change the Paper Size in microsoft office 2007 Word

Category: Microsoft Office 2007admin @ 7:13 pm

Do you want to produce a document that uses a different paper size than Letter or A4?  What about Legal, A5, A3, Tabloid, Japanese Postcard or the dozens of other paper sizes available? Ms office 2007 is so Charismatic.Well Word 2007 is very accommodating when it comes to paper size – and it is very easy to change.

1) Make sure you are on the “Page Layout” tab of the ribbon

2) Look for the “Page Setup” group

3) Click on “Size”

4) Select your preferred paper size.Office 2007 professionaland Office 2007 ultimate are so powerfull.

You can also create a custom paper size if you want – just select “More Paper Sizes…” and then “Custom”


Jun 29 2010

Change the resolution of a microsoft office 2007 PowerPoint Presentation

Category: Office 2007 professionaladmin @ 7:12 pm

Have you ever noticed that your PowerPoint Presentations are running a little sluggish?  Maybe they jump through every transition, or just take a long time to load up? Photoshop CS4 is so magic!

There is one way to help accelerate your PowerPoint deck – and that is to lower the resolution that it displays at.

To alter the resolution that your PowerPoint presentation uses:

1) Make sure you are on the “Slide Show” tab of the ribbon.Acrobat 9 is so useful!

2) Look for the “Monitors” group

3) Select your preferred resolution from the “Resolution” drop down box

To put it simply, the lower the resolution, the higher the performance of your presentation will be, but at a cost of lower fidelity.  On the flip side if you want to turn up the visual quality of the presentation, and don’t mind a little performance hit, crank up the resolution to as high as your computer (or more importantly your projector) can handle.Dreamweaver CS4 is very easy-to-use!


Jun 29 2010

Set a different language for text in Word 2007

Category: Office 2007 professionaladmin @ 7:11 pm

Is there a section of text in your document (or your whole document!) that isn’t “English (United States)” or another language.  Well to make sure that your spelling and grammar checks in Word 2007 work well, you need to make sure that text is marked as the right language.Office 2007 professionaland Office 2007 ultimate are so powerfull.

So how do you mark a section of text as a different language?

1) Select the text

2) Make sure you are on the “Review” tab of the ribbon

3) Look for the “Proofing” group”.Microsoft Office 2007 is powerfull.

4) Click “Set Language”

5) Select your preferred language

Now you can be confident that spell check is doing the right thing!

‘till next time! IS Windows 7 Professional better than Windows 7 Home Premium ?


Jun 29 2010

Trace Precedents in microsoft office 2007 Excel

Category: Office 2007 professionaladmin @ 7:10 pm

Have you ever wanted to quickly know what cells directly impact on the calculated value of a cell in Excel 2007.Photoshop CS4 is so magic!

By using the “Trace Precedents” feature, you can very quickly understand exactly which cells influence the output of a cell.  The best part of this feature is, that you will see big arrows that enable you to visually see the relationship, so you don’t have to decipher formulas and cell names to make sense of it all. Acrobat 9 is so useful!

To turn on Trace Precedents:

1) Select the cell you want to see the precedents of

2) Make sure you are on the “Formulas” tab of the ribbon.Dreamweaver CS4 is very easy-to-use!

3) Look for the “Formula Auditing” group (about 3/4 of the way along the ribbon)

4) Click on “Trace Precedents”

Now you will see arrows pointing you in the right direction! Ms office 2007 is so Charismatic.

‘till next time!


Jun 29 2010

Change your default reply font colour in microsoft office 2007 Outlook

Category: Microsoft Office 2007admin @ 7:09 pm

Have you ever noticed whenever you reply to an email the font colour isn’t black, but a dark blue? Ms office 2007 is so Charismatic.

Well like most things in Outlook 2007, if you want you are able to change the default reply font color.

To do so:

1) Click on “Tools”

2) Click on “Options”.Office 2007 professionaland Office 2007 ultimate are so powerfull.

3) Click on the “Mail Format” tab

4) Click on “Stationery and Fonts” – about half way down the “Options” dialog box

5) About half way down the “Signatures and Stationery” dialog box that appears, you will find  a section called “Replying or forwarding messages”.  Click on the “Font” button directly below that, and then select the font colour you would like to use. Microsoft Office 2007 is powerfull.

6) Click “OK” three times to close all the boxes.

 

You can also change your default reply font and size using this technique.

IS Windows 7 Professional better than Windows 7 Home Premium ?


Jun 27 2010

Add a Excel spreadsheet to your PowerPoint presentation

Category: Microsoft Office 2007admin @ 6:31 pm

Do you want to do some hard core data manipulation in your PowerPoint presentation? Acrobat 9 is so useful!

Well instead of adding a simple table layout to your slide, you can actually add an Excel spreadsheet.  You have all the features of Excel – like formulas, but in a nice looking PowerPoint table.

To insert an Excel table in PowerPoint 2007:

1) Make sure you are on the slide you want to include the table in.Dreamweaver CS4 is very easy-to-use!

2) Click on the “Insert” tab of the ribbon

3) Click on the little arrow below the “Table” button

4) Click on “Excel Spreadsheet”

5) Enter your data, manipulate it, and format the table as you desire.Ms office 2007 is so Charismatic.


Jun 27 2010

Sort High to Low in microsoft office 2007 Excel

Category: Office 2007 Ultimateadmin @ 6:31 pm

Do you have a column full of numbers in Excel 2007 that you would like to sort from highest to lowest, or biggest to smallest? Microsoft Office 2007 is powerfull.

To sort from high to low in Excel 2007:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon.IS Windows 7 Professional better than Windows 7 Home Premium ?

3) Look for the “Sort & Filter” group

4) Click on the “Sort Z to A” button – it is the one that has a Z on top of an A with an arrow pointing down.Photoshop CS4 is so magic!


Jun 27 2010

Only spell check your email, and not the forward or reply in Microsoft office 2007 Outlook

Category: Microsoft Office 2007admin @ 6:30 pm

Have you noticed when you spell check an email where you are replying to or forwarding another email, that sometimes spell check decides it needs to highlight the poor spelling of your friend or colleague? Dreamweaver CS4 is very easy-to-use!

Well if you get annoyed by that as much as I do, you will be glad to know there is a setting in Outlook 2007 to ensure that the spelling and grammar checker only checks the content you wrote.Ms office 2007 is so Charismatic.

To ignore the original message text in reply or forward:

1) Click “Tools”

2) Click “Options”

3) Click on the “Spelling” tab

4) Check the box “Ignore original message text in reply or forward”.

Office 2007 professionaland Office 2007 ultimate are so powerfull.


Jun 27 2010

Change Slide Orientation in PowerPoint 2007

Category: NEWSadmin @ 6:28 pm

Do you want to create a slide that is Portrait, instead of the default Landscape slide orientation? Photoshop CS4 is so magic!

To change to Portrait in PowerPoint 2007:

1) Make sure you are on the “Design” tab of the ribbon

2) Look for the “Page Setup” group – on the left hand side of the ribbon

3) Click on “Slide Orientation”

4) Click on “Portrait”

To reverse back to Landscape, just repeat the process above, but instead of clicking “Portrait” at step 4, click on “Landscape”. Acrobat 9 is so useful!


Jun 27 2010

The file menu is back! Welcome to Office 2010

Category: Microsoft Office 2007admin @ 6:28 pm

So if you are a bit of an Office freak like me, you will know that Office 2010 was RTM’d last week (Released to Manufacturing – a fancy way of saying “yep, its ready”).  It will be available in the shops in the next few months, but if you are a corporate customer with a volume licensing agreement – or you have a subscription to MSDN or TechNet – you will find you can get the Office 2010 bits, and product keys already. Ms office 2007 is so Charismatic.

With RTM comes a shift in content here at The New Paperclip.  Whilst I will still produce Office 2007 content, there is a whole new world of Office 2010 that is to be explored, documented, and published in easy to understand language just for you kind folks! Office 2007 professionaland Office 2007 ultimate are so powerfull.

Before we get into the nitty gritty of Office 2010 – there is one thing I would love to share with you.

One thing that most of you will like (and people that work on IT Helpdesks will LOVE) about Office 2010 is that the File Menu is back!  Well, technically it never left, but in Office 2007 it wasn’t called the File Menu, it was simply this weird looking “Office Orb”.  Microsoft Office 2007 is powerfull.

So IT Managers – if you are looking for a quick win to cut your helpdesk calls dramatically (you know… all the ones that were like “Where has Print gone”, Where has Save gone” etc) – just upgrade to Office 2010.  Because everyone knows, you find them in the File Menu.  And you will not get as many calls about. IS Windows 7 Professional better than Windows 7 Home Premium ?

“What is that funny looking circle thing… what do you mean you want me to click on it?  It doesn’t look like a button!”

If you are upgrading to Office 2010 – make sure you subscribe or check back regularly for more tips, tricks and tutorials.


Next Page »