Print on one page Excel 2013

So you are sick and tired of printing your spreadsheet to find a single column or row on a second page?  Well did you know you can quickly print your spreadsheet on a single page.  Here is how to do it in Excel 2013

  1. Click “File”
  2. Click “Print”
  3. Look for the drop down box that says “No Scaling, buy Print sheets at their actual size”.  We don’t want to do that!  Click on the dropdown and select the option you want – either “Fit on one page”, visit this “Fit all columns on one page”, or “Fit all rows on one page”
  4. Click Print!

There you have it, the quick and easy way to make sure your spreadsheet ends up on one page when you print it!

’till next time!
TNP 😉

What is the annoying Yellow Bar in Word, Excel or PowerPoint?

Don’t you hate that annoying email pop up whenever you get an email in Outlook 2013?  Well there is an easy way to turn it off.  All you have to do is:

  1. Click on “File”
  2. Click on “Options”
  3. From the Outlook Options dialog box that appears, page click on “Mail” in the left hand column
  4. Look for the section called “Message Arrival”.  If you want to turn all notifications off, purchase including sound, the mouse pointer turning into an envelope, the envelope icon in the task bar and the pesky desktop alert, simply untick the options you don’t want.
  5. Click “OK”

Simple as that!  If you want to turn them back on simply repeat the process, but tick the notifications you want!  If you are using Outlook 2010 the process is very similar

’till next time
TNP 😉

Are you deploying Office 2010 in your organisation and looking for a great (ie FREE!) way to increase the adoption of Office 2010?  Or maybe you are a home user just interested in learning more about Word, clinic Outlook or Excel?

Either way – Microsoft have a great training tool available which can help you or  your people get more out of Office 2010.  It is the Office 2010 Getting Started Screensaver.

Now you need to be running Windows 7 to use it, glands
but if you are, it is one of the better ways I have seen to learn more about Office.

Click here to download the screensaver today.  Thanks to Ian Palangio from Microsoft Australia for pointing it out!

‘till next time!
TNP Winking smile

Are you one of the thousands of businesses around the word looking to use Microsoft’s Office 365 “cloud” service, sales but don’t know where to start?

Well Microsoft Press have made available a free e-book which helps you get started.  Called “pilule
Anytime.”

I like this book for a few reasons.  Firstly – FREE!  Secondly, ambulance
it covers a lot of the questions you probably have about Office 365 and gives you some pretty good answers.  It covers topics like:

  • Getting Started with Office 365
  • Administering an Office 365 Account
  • What your team can do with Office 365
  • Creating your Team Site with SharePoint Online
  • Posting, Sharing and Managing Files
  • Adding and Managing Workflows
  • Working with Office 2010 Web Apps
  • Going Mobile with Office 365

It is a good blend of technical content for the folk that need to set up and run Office 365 for others, plus a little bit of user content to help you understand exactly how Office 365 works under the covers, and how you can use it to work better, faster, and stronger!

You can download the free Office 365 ebook from Microsoft here.

Don’t you hate when you are typing an email address into an email you are sending, stuff
and you accidently add the wrong one!  Maybe there are two people you have emailed before.  Both with the same first name, rehabilitation
and similar surnames.  But one is your boss, salve
and the other is your best friend. 

You don’t want to accidently send your boss those pictures from the weekend right!!??!?!?!

That feature, where the names automatically pop us is called “Auto Complete”.  It is a handy feature if you email people regularly, but can cause you problems if you are not careful.

So – if you want to delete a name form your Auto Complete list in Outlook 2010… what do you do?

Simple!

Just start typing their name in.  When it appears in the auto complete list, simply look to the right of their name.  You should see a cross or a check – ie a delete button.  Just click on that, and that name and email address is removed from your auto complete list.

Easy!

‘till next time!
TNP 😉

One of my favourite things about Office 365 is that by using the SharePoint Online functionality that comes with it, remedy you can quickly create a secure extranet to share documents, medications
collaborate, adiposity
and communicate with people outside your organisation.

In fact, depending on the Office 365 plan you are on, you can invite up to 50 people who are not on your Office 365 environment to participate!

Not only that, the best part is that it only takes a couple of minutes to set up, and once you have, it is even faster next time you want to create another extranet (maybe for another customer or supplier)

So how do you do it?

1) Go to the Office 365 Admin Portal (portal.microsoftonline.com, and click on “Admin”)

2) Click on “Manage SharePoint”

3) Click on “Manage Site Collections

4) Click on “Settings”

5) Click “Manage External Users”

6) Click “Allow” and “Save”

7) Go to the site collection (the site that will be your extranet) then click “Site Actions”

8) "Click “Site Settings”

9) Look for “Site Collection Administration” and click on “Site Collection Features”

10) Look for “External User Invitations” and click “Activate” (if it isn’t activated already)

11) Go to the site you want to share, click “Site Settings”

12) Click “Share Site”

13) Type in the email addresses of the folk that you want to invite to participate in your new Office 365 / SharePoint Online extranet!!!!

Now one thing that you should note is that at the time of writing this article, your external parties need to use a Hotmail ID, or a Microsoft Online Services ID to log into your extranet.  In the future you should be able to use any email address which will make it even easier.

So there you have it – a fully functioning, secure extranet in just minutes using Office 365!  How good is that!!!!

‘till next time!
TNP 😉

Are you considering moving your business to Office 365?  Well the www.office365.com website does a good job of explaining at a high level what you get for your dollar – but for some of us that isn’t enough information.

What if you want to get down to the fine detail before making a decision to go to Office 365?

Well luckily Microsoft have published what the call “Service Descriptions”.  These documents outline exactly what you get, implant
explain the differences between all the plans, there and ultimately help you decide what plan is right for you.

The Office 365 for Enterprise Service Descriptions include:

  • Microsoft Exchange Online Archiving Service Description
  • Microsoft Exchange Online for Enterprises Service Description
  • Microsoft Lync Online for Enterprises Service Description
  • Microsoft Office Professional Plus Service Description
  • Microsoft Office Web Apps Service Description
  • Microsoft SharePoint Online for Enterprises Service Description
  • Office 365 for Enterprises Service Description
  • Office 365 Identity Service Description
  • Office 365 Mobility Service Description
  • Office 365 Security and Service Continuity Service Description
  • Office 365 Support for Apple Mac and iOS Devices

You can find all the information here.

‘till next time!
TNP 😉

Are you working on a PowerPoint presentation and want to insert a new slide?  By default, drugs
chances are you will get a slide which has a title at the top, refractionist
and a big box below that in which you can add your bullet points.

The default layout is what we call “Title and Content”, nurse but there are many others you can choose from.  For example:

  • Title Slide (the first slide you see when you create a new presentation)
  • Section Header
  • Two Content
  • Comparison
  • Title Only
  • Blank
  • Content with Caption
  • Picture with Caption

To create a new slide with one of these layouts, simply click on the bottom half of the “New Slide” button on the “Home” tab in PowerPoint.

A small menu will appear with pictures of what each layout looks like.  Simply click on the layout you like and it will be inserted into your document.

Now if you want to change the layout of an existing slide:

1) Click on the slide that you want to change

2) On the “Home” tab, just to the right of the new slide button you will see one called “Layout” – click on that

3) From the menu that appears, select the layout that you want

Now your presentation will have a bit of variety!

‘till next time!
TNP 😉
Are you working on a PowerPoint presentation and want to insert a new slide?  By default, side effects
chances are you will get a slide which has a title at the top, and a big box below that in which you can add your bullet points.

The default layout is what we call “Title and Content”, but there are many others you can choose from.  For example:

  • Title Slide (the first slide you see when you create a new presentation)
  • Section Header
  • Two Content
  • Comparison
  • Title Only
  • Blank
  • Content with Caption
  • Picture with Caption

To create a new slide with one of these layouts, simply click on the bottom half of the “New Slide” button on the “Home” tab in PowerPoint.

A small menu will appear with pictures of what each layout looks like.  Simply click on the layout you like and it will be inserted into your document.

Now if you want to change the layout of an existing slide:

1) Click on the slide that you want to change

2) On the “Home” tab, just to the right of the new slide button you will see one called “Layout” – click on that

3) From the menu that appears, select the layout that you want

Now your presentation will have a bit of variety!

‘till next time!
TNP 😉

Do you need to create some simple business cards?  Well it isn’t all that hard using Microsoft Word, ampoule
and some of the templates available at www.Office.com.

In fact, sick one of the Microsoft team have put together a great video showing you exactly how easy it is.

Watch the video by Doug Thomas over at the Office Casual Blog – and you too can create a simple business card in just 90 seconds!

WOW – that is quick!

‘till next time!
TNP 😉

If you have been using Microsoft Office 2007 or 2010 for a while, click you might have come across what most people call the “Annoying Yellow Bar”

If you don’t know what I am talking about – open up a word document that someone has send you via email – or a spread sheet that you might find on a website.  Chances are when you open that Word, store
Excel or PowerPoint file, you will see the “Annoying Yellow Bar” – and you will not be able to edit, print, or save your document.

Well it may be annoying, but it is actually really important.  The yellow bar shows you that Word, Excel or PowerPoint is running in what we call “Protected Mode”.  Any time you open a file that isn’t on your computer, or from somewhere that you can’t trust (like the internet), the document will be opened in protected mode, to (as the name suggests) protect your computer from harm.

It opens up the document so you can take a look at it, and then if you are sure it is what you are looking for, and you trust that it will not do any harm, you can then click on the “Enable Editing” button, which sits on the yellow protected view bar.

Now there are ways to stop Protected View from happening, but trust me, it is worth putting up with because if you accidently open a document that causes damage to your computer, it is a LOT more annoying!

‘till next time!
TNP 😉

Building an add-in for Microsoft Office

Soon I will be publishing a series of articles on The New Paperclip which dive a bit deeper into extending the functionality of Microsoft Office.  Probably a scary thought for most of you, more about
but I have found that if we want to extract that extra 10-50% more out of Office there comes a time where you need to start coding.

In particular I am going to focus on building high value add-ins for Microsoft Office.

Now when it comes to writing an add-in, pulmonologist
there are a couple of ways to go about it.

1) Roll your own

If you are confident C#  or VB coder there is nothing stopping you from cracking open Visual Studio, ed
downloading Visual Studio Tools for Office and giving it your best shot.  I must admit I tried this at first, and had some success.

But that success was time consuming, and when I wanted to build an add-in that was backwards compatible with Outlook 2007 (which has that horrible combination of ribbon and command bar), Office 2003/XP and beyond it became VERY time consuming.

So I decided to use an alternative.

2) Use Add-in-Express

Before I share my experience with Add-in-Express… here is what the brochure says!

Add-in Express for Office and .NET is the only all-in-one platform that includes all the features you may expect for your Microsoft Office extensions such as Office COM add-ins, smart tags, Excel XLLs, RTD servers and Automation add-ins (UDFs). It fully supports Microsoft Visual Studio 2010, 2008 and 2005 and makes it very comfortable for developing application-level extensions for all available Office versions from 2000 to 2010.”

What that means for people new to Office Development is that Add-in-Express makes it easy to quickly extend the functionality of Microsoft Office, irrespective of what version you are running.  And after spending about a month using the tool to build some add-ins myself, I have to agree.  For someone who is exploring Office Development for the first time, taking the painful parts of COM out of the picture meant that I could focus on the features and functionality I wanted to build, and not spend hours pulling my hair out!

For example, being able to access all the key events in Office without having to write event handlers accelerated development time.  Sure, it may only seem like a small thing, but as any developer knows, anything that saves you time, and takes the pain of troubleshooting away is a good thing!

Anyways – if you are interested in developing your own Office Add-in, make sure you subscribe and check back in the next few weeks for more content about my development experiences – and some examples that will get your Office Development journey started.

‘till next time!
TNP Winking smile

Freeze the Top Row in Excel

So if you have been reading The New Paperclip for a while, surgeon you will know that the guy behind The New Paperclip is Paul Woods. Recently he delivered two presentations at two separate events – Microsoft’s TechEd Australia Conference, prescription and the community driven OfficeDevCon09. Here are the two presentations available on Slideshare…

web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
View more presentations from Paul Woods.
View more presentations from Paul Woods.

I hope you enjoy!

’till next time!
TNP 😉

Oh My!  Hasn’t Christmas snuck up on us this year!  Just over two weeks until the big day, prosthetic
I thought I might share with you some great resources over at Office Online which will help you make the most of Christmas this year!

1) Christmas Clipart!

Are you looking for some pictures or artwork to make your home made Christmas Cards look amazing!  There are over 100 pages of Christmas Clipart available at

2) Holiday Letter Tutorial!

This is a great course that will help you create a decorate a newsletter, create mailing labels for your envelopes, and create some holiday decorations.  It is about 30 minutes long – but will be a great investment of your time this Christmas to help you spread the holiday cheer!

3) Create your own Holiday Greeting Cards!

Another great resource to help you great special greeting cards to share with your family and friends – from the traditional, to the new age multimedia greeting cards with PowerPoint.

So there you have it, three great resources to help you make the most of Christmas this year!

‘till next time!
TNP 😉

With 2009 almost behind us, healthful
now is the time to start creating your own 2010 calendars using Word 2007.

It is a lot simpler than you think!  Here is how you do it.

1) Make sure you are connected to the internet

2) Click on the Office Orb in the top left hand corner of the screen (the old file menu)

3) Click on “New”

4) In the “New Document” dialog box that appears, on the left hand side you will see a long list of different template types you can find on Microsoft Office Online.  click on “Calendars”

5) Click on “2010 calendars”

6) Pick your favourite design from the dozens that appear!  Once you have selected the one you like, just click “Download” in the bottom right hand corner

7) After Word downloads the Calendar, it will appear ready for you to use, edit or print straight away.

How easy is that!  Happy New Year!

‘till next time!
TNP 😉

Did you know in Word you can automatically select all the text in a document that shares the same formatting?

For example, read
you can select all text that is Arial, click 12pt.  Very handy if you are not using styles, dosage
yet want to apply a formatting change across select blocks of text.

To select text with similar formatting in Word 2007:

1) Select some of the text you want to select

2) Make sure you are on the home tab of the ribbon

3) Look for the “Editing” group on the right hand side of the ribbon

4) Click on “Select”

5) Click on “Select Text with Similar Formatting”

‘till next time!
TNP 😉

Do you want to quickly change some text from lowercase to uppercase, online without having to retype it?

It is really simple in Word 2007!

1) Select the text you want to change to UPPERCASE

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

3) Look for the “Font” group

4) Click on the “Change Case” button – which you will find directly below where you select the font size

5) From the menu that appears, decease
click on “UPPERCASE”

Whilst you are there, check out some of the other case options you can have… like Sentence case, lowercase, Capitalize Each Word, and tOGGLE cASE.

‘till next time!
TNP 😉

You know there are just some times when you really need to make a point!  And using a double underline is a great way of making sure your readers know exactly what you mean!

Doing a normal, women’s health
single underline in Word 2007 is easy… but what about a double underline?  Well it is just as easy.

1) Select the text you want to double underline

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

3) Look for the “Font” group"

4) Click on the little down arrow beside the “Underline” button – that is the one that looks like a U with a underline below it

5) Select the underline that you would like to use.

‘till next time!
TNP 😉

Are you doing a school assignment, anorexia
or a report for work, medicine and have been told you need to use “Double Line Spacing

In Word 2007, visit this
is is fairly simple to do just that.

1) Select the text in your document that you want to apply double line spacing to

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

3) Look for the “Paragraph” group

4) Look for the button that has an up arrow and a down arrow, with lines beside them – that is the “Line Spacing” button.  Click on that, and select “2.0” – that is double line spacing.

To change back to the default spacing (1.15) or single line spacing (1.0), simply repeat the procedure above.

‘till next time!
TNP 😉

Do you want to produce a document that uses a different paper size than Letter or A4?  What about Legal, nurse
A5, A3, Tabloid, Japanese Postcard or the dozens of other paper sizes available?

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

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

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, ampoule you need to make sure that text is marked as the right language.

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”

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!
TNP 😉

Word 2007 has some fairly powerful translation features that can help you quickly understand what a word is in a different language.

By using the “Translation ScreenTip” you can see the translation of most words simply by moving the mouse over them!

Translation ScreenTip works for the following languages:

  • Arabic (Saudi Arabia)
  • English (United States)
  • French (France)
  • Spanish (Spain, here International Sort)

To turn on Translation ScreenTip:

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

2) Look for the “Proofing” group

3) Click on “Translation ScreenTip”

4) Select the language you want to see the translation for, meningitis
or click on “Turn Off Translation ScreenTip” to turn the translation off.

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, diabetes and Pregnancy
or click on “Define New Bullet”

If you are defining a new bullet, store
you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, story
or click on “Define New Bullet”

If you are defining a new bullet, you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Just like a header or footer in Word 2007, capsule
you can quickly add a header or footer to a workbook in Excel 2007.  You can add the date, time, filename or any other information you would like to make available to readers of your spreadsheet.

To create a header or footer in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Text” group – it will be on the right hand side of the ribbon

3) Click on “Header & Footer”

You will see a new tab appear on the ribbon called “Header & Footer Tools – Design”.  Using the buttons on this tab of the ribbon, you can quickly add:

  • Page Number;
  • Number of Pages;
  • Current Date;
  • Current Time;
  • File Path;
  • File Name;
  • Sheet Name; or a
  • Picture

To the header or footer of your document.  To switch from the header to the footer, simply click on “Go to Footer” which you will find in the “Navigation” group about half way along the ribbon.

‘till next time!
TNP 😉
Do you want to stop people messing with your data, site formulas, hospital
formatting, or all of the above in Excel 2007?  Well did you know you very quickly protect your spreadsheet from those rogue operators!

Here is how you do it in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are currently looking at the sheet you want to protect

2) Click on the “Review” tab in the ribbon”

3) Look for the “Changes” group”

4) Click on “Protect Sheet”

A little “Protect Sheet” dialog box will appear that will give you a number of options, so you can be very granular in how much control you want people to have over the sheet.

For example, you can allow users to select cells, but not format them.  You can allow people to insert rows, but not insert columns.  And best of all you can add a password to the sheet to ensure only you can make any changes to what can and can’t be modified.

Now, you are really in control!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells directly impact on the calculated value of a cell in Excel 2007.

By using the “Trace Precedents” feature, buy cialis
you can very quickly understand exactly which cells influence the output of a cell.  The best part of this feature is, nurse
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.

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

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!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007, search
Excel 2010 or Excel 2013.

By using the “Trace Dependents” feature, you can very quickly understand exactly the influence a cell has in your spreadsheet.  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.

To turn on Trace Dependents:

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

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

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

4) Click on “Trace Dependents”

Now you will see arrows pointing you in the right direction!

‘till next time!
TNP 😉

Did you start creating a presentation in PowerPoint 2007, troche only to realise after you perfected 67 different slides that you really should have used Arial instead of Verdana?

Well there is a very quick way to replace one font with another in PowerPoint 2007.  Here is how:

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

2) Look for the “Editing” group – which you will find on the right hand side of the ribbon

3) Click on the little arrow beside “Replace”

4) Click on “Replace Fonts…”

From the box that appears, simply select the font you want to replace, with the new font, and click “Replace”

‘till next time!
TNP 😉

Have you ever built an awesome slide with lots of different objects?  Well then I am sure you will understand how frustrating it can be when you need to select an object that is behind 3 or 4 other ones!

Did you know there is a great tool you can use called the “Selection Pane”, recipe that will help you select those pesky, online
hard to get to objects?

Selection Pane simply lists all the objects that are on a slide, sovaldi sale in a simple to use task pane to the right hand side of your PowerPoint 2007 screen.  Using Selection pan you can quickly select any object, not matter how far to the back of the slide it is.

To turn on the selection pane:

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

2) Look for the “Editing” Group – you will find it on the far right hand side of the ribbon

3) Click on the little arrow beside the “Select” button

4) Click on “Selection Pane…”

 

‘till next time!
TNP 😉

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

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

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.

‘till next time!
TNP 😉

Are you sick of clicking your mouse, health hitting a key, mind or pressing next on your wireless presenter?

Well in PowerPoint 2007, no rx you can set up your presentation so that each slide automatically advances after so many seconds.

To make a slide automatically advance after a certain amount of time:

1) Make sure you are looking at the slide you want to apply the timing to

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

3) Look for the “Advance Slide” section at the far right hand side of the ribbon

4) Check the “Automatically After:” box, and then input the number of minutes and seconds you would like the slide to be visible before advancing to the next.

If you are unhappy with automatically advancing slides, don’t worry – you can still use the mouse click to move to the next one.  And if you really hate it, you can simply uncheck the “Automatically After:” check box to stop the timed slide advance from occurring.

‘till next time!
TNP 😉

Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, prostate and what the email subject is?

Well using the “Auto Preview” feature in Outlook 2007, more about
you can now view the first couple of lines of an email – giving you all the information you need to triage and prioritise the long list of emails in your inbox.

To turn on (or off) Auto Preview in Outlook 2007:

1) Click on “View”

2) Click on “AutoPreview”

 

Simple as that!

‘till next time!
TNP 😉

Have you ever noticed whenever you reply to an email the font colour isn’t black, one Health
but a dark blue?

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

To do so:

1) Click on “Tools”

2) Click on “Options”

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. 

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

 

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

‘till next time!
TNP 😉

If you regularly use the quick search feature of Outlook 2007, prescription
you will be very familiar with the yellow highlight that is used to highlight search terms found in your inbox.

But did you know, medicine
if yellow isn’t your favourite colour, urologist
you can change the search highlight to any colour you want?

To change the search highlight color in Outlook 2007:

1) Click on “Tools”

2) Run your mouse over “Instant Search” to expand the menu

3) Click on “Search Options”

4) Look just over half way down the “Search Options” box, and click on “Change…”

5) Select your favourite colour from the “Color” box that appears

6) Click “OK”

Now you can highlight your search terms in pink, blue, red, orange or any other colour under the rainbow!

‘till next time!
TNP 😉

Are you sick of those extra long forwarded emails that seem to go on forever and ever?  Did you want to keep all that content for reference, ambulance
but make sure that what you have to add to the forward is clearly delivered?

One way to do that is to forward an email as an attachment.  Instead of a long email thread appearing below your message, it is neatly tucked away in an attachment so your message gets all the attention!

To forward an email as an attachment in Outlook 2007:

1) Select the email you want to forward

2) Click on “Actions”

3) Click on “ Forward as Attachment”

4) Compose your message, and hit Send

‘till next time!
TNP 😉

Does your Junk Mail folder in Outlook 2007 seem to continually build up with… well… junk mail?  If you are confident that no important mail ever ends up in your junk mail folder, epilepsy
you can set Outlook to automatically delete junk mail instead.

To automatically delete junk mail in Outlook 2007:

1) Click on “Tools”

2) Click on “Options”

3) Make sure you are on the “Preferences” tab”

4) In the “E-mail” section, click on the “Junk E-mail…” button

5) On the “Options” tab, look half way down for a checkbox that says “Permanently delete suspected junk e-mail instead of moving it to the Junk E-mail folder”.  Check that check box.

To stop the automatic deletion of junk mail, repeat the process, and just uncheck the checkbox in step 5

‘till next time!
TNP 😉

You know how that box always pops up whenever you have a reminder in Outlook 2007?  Well if you accidentally close it, site and want to review all the reminders you currently have, obesity
there is a quick way to make the reminders window appear again.

1) Click on “View”

2) Click on “Reminders Window”

 

Easy as that!

‘till next time!
TNP 😉

Do you want a great looking presentation, stuff
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?

Well the simple, Breast
and great looking option is to use a Slide Background.  A slide background is a simple gradient that will turn any standard barebones deck into one that looks very professional.

To add a simple background to your PowerPoint 2007 presentation:

1) Click on the “Design” tab of the ribbon

2) Look for the “Background” group – on the right hand side of the ribbon

3) Click on “Background Styles”

4) Select your preferred background

 

You will notice that not all the colours of the rainbow are available.  Background styles are linked to the current colour palette that you have selected in the document.  If you play around with the colors by clicking on the “Colors” button whilst you are still on the “Design” tab of the ribbon, you will notice the background colour change to match the new palette.

‘till next time!
TNP 😉

Do you want to do some hard core data manipulation in your PowerPoint presentation?

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

To insert an Excel table in PowerPoint 2007, no rx PowerPoint 2010 or PowerPoint 2013:

1) Make sure you are on the slide you want to include the table in

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

 

‘till next time!
TNP 😉

Do you want to copy one, this
two, prostate three or more slides and reuse them in your PowerPoint 2007 slide deck?

There are two ways you can go about it – the first is plain old copy and paste.  The other is to use the “Duplicate Slide” feature.

To duplicate slides in PowerPoint 2007:

1) Select the slide or slides you want to duplicate

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

3) Look for the “Slides” group

4) Click on the little arrow underneath “New Slide”

5) Click on “Duplicate Selected Slides”

 

‘till next time!
TNP 😉

Do you want to create a slide that is Portrait, symptoms
instead of the default Landscape slide orientation?

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, discount
just repeat the process above, but instead of clicking “Portrait” at step 4, click on “Landscape”.

 

‘till next time!
TNP 😉

Don’t you hate it when you accidently click on a text box on your slide and move it?  Before you know it, rx
your heading one one slide, or the body text on another is completely out of whack with the rest of your presentation.

The good news is that there is a way to reset the slide back to normal.  Funnily enough, it is called “Reset”.  The best of this feature is, that it only resets the layout of the slide – your text will remain intact!

To reset a slide in PowerPoint 2007:

1) Select the slide you want to reset

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

3) Look for the “Slides” group, close to the left hand side of the ribbon

4) Click on the “Reset” button – the button that looks like a slide with a blue arrow pointing to the left

 

‘till next time!
TNP 😉

Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?

To do that, sale you need to “Freeze” the top row of your sheet.

To Freeze the top row in Excel 2007, Excel 2010 or Excel 2013:

1) Click on the “View” tab of the ribbon

2) Look for the “Window” group

3) Click on “Freeze Panes”

4) Click on “Freeze Top Row”

 

To unfreeze the top row, just repeat the process above, but instead of clicking “Freeze Top Row” in step 4), just click on “Unfreeze Panes”

‘till next time!
TNP 😉

Sort Low to High in Excel

So if you have been reading The New Paperclip for a while, surgeon you will know that the guy behind The New Paperclip is Paul Woods. Recently he delivered two presentations at two separate events – Microsoft’s TechEd Australia Conference, prescription and the community driven OfficeDevCon09. Here are the two presentations available on Slideshare…

web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
View more presentations from Paul Woods.
View more presentations from Paul Woods.

I hope you enjoy!

’till next time!
TNP 😉

Oh My!  Hasn’t Christmas snuck up on us this year!  Just over two weeks until the big day, prosthetic
I thought I might share with you some great resources over at Office Online which will help you make the most of Christmas this year!

1) Christmas Clipart!

Are you looking for some pictures or artwork to make your home made Christmas Cards look amazing!  There are over 100 pages of Christmas Clipart available at

2) Holiday Letter Tutorial!

This is a great course that will help you create a decorate a newsletter, create mailing labels for your envelopes, and create some holiday decorations.  It is about 30 minutes long – but will be a great investment of your time this Christmas to help you spread the holiday cheer!

3) Create your own Holiday Greeting Cards!

Another great resource to help you great special greeting cards to share with your family and friends – from the traditional, to the new age multimedia greeting cards with PowerPoint.

So there you have it, three great resources to help you make the most of Christmas this year!

‘till next time!
TNP 😉

With 2009 almost behind us, healthful
now is the time to start creating your own 2010 calendars using Word 2007.

It is a lot simpler than you think!  Here is how you do it.

1) Make sure you are connected to the internet

2) Click on the Office Orb in the top left hand corner of the screen (the old file menu)

3) Click on “New”

4) In the “New Document” dialog box that appears, on the left hand side you will see a long list of different template types you can find on Microsoft Office Online.  click on “Calendars”

5) Click on “2010 calendars”

6) Pick your favourite design from the dozens that appear!  Once you have selected the one you like, just click “Download” in the bottom right hand corner

7) After Word downloads the Calendar, it will appear ready for you to use, edit or print straight away.

How easy is that!  Happy New Year!

‘till next time!
TNP 😉

Did you know in Word you can automatically select all the text in a document that shares the same formatting?

For example, read
you can select all text that is Arial, click 12pt.  Very handy if you are not using styles, dosage
yet want to apply a formatting change across select blocks of text.

To select text with similar formatting in Word 2007:

1) Select some of the text you want to select

2) Make sure you are on the home tab of the ribbon

3) Look for the “Editing” group on the right hand side of the ribbon

4) Click on “Select”

5) Click on “Select Text with Similar Formatting”

‘till next time!
TNP 😉

Do you want to quickly change some text from lowercase to uppercase, online without having to retype it?

It is really simple in Word 2007!

1) Select the text you want to change to UPPERCASE

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

3) Look for the “Font” group

4) Click on the “Change Case” button – which you will find directly below where you select the font size

5) From the menu that appears, decease
click on “UPPERCASE”

Whilst you are there, check out some of the other case options you can have… like Sentence case, lowercase, Capitalize Each Word, and tOGGLE cASE.

‘till next time!
TNP 😉

You know there are just some times when you really need to make a point!  And using a double underline is a great way of making sure your readers know exactly what you mean!

Doing a normal, women’s health
single underline in Word 2007 is easy… but what about a double underline?  Well it is just as easy.

1) Select the text you want to double underline

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

3) Look for the “Font” group"

4) Click on the little down arrow beside the “Underline” button – that is the one that looks like a U with a underline below it

5) Select the underline that you would like to use.

‘till next time!
TNP 😉

Are you doing a school assignment, anorexia
or a report for work, medicine and have been told you need to use “Double Line Spacing

In Word 2007, visit this
is is fairly simple to do just that.

1) Select the text in your document that you want to apply double line spacing to

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

3) Look for the “Paragraph” group

4) Look for the button that has an up arrow and a down arrow, with lines beside them – that is the “Line Spacing” button.  Click on that, and select “2.0” – that is double line spacing.

To change back to the default spacing (1.15) or single line spacing (1.0), simply repeat the procedure above.

‘till next time!
TNP 😉

Do you want to produce a document that uses a different paper size than Letter or A4?  What about Legal, nurse
A5, A3, Tabloid, Japanese Postcard or the dozens of other paper sizes available?

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

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

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, ampoule you need to make sure that text is marked as the right language.

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”

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!
TNP 😉

Word 2007 has some fairly powerful translation features that can help you quickly understand what a word is in a different language.

By using the “Translation ScreenTip” you can see the translation of most words simply by moving the mouse over them!

Translation ScreenTip works for the following languages:

  • Arabic (Saudi Arabia)
  • English (United States)
  • French (France)
  • Spanish (Spain, here International Sort)

To turn on Translation ScreenTip:

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

2) Look for the “Proofing” group

3) Click on “Translation ScreenTip”

4) Select the language you want to see the translation for, meningitis
or click on “Turn Off Translation ScreenTip” to turn the translation off.

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, diabetes and Pregnancy
or click on “Define New Bullet”

If you are defining a new bullet, store
you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, story
or click on “Define New Bullet”

If you are defining a new bullet, you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Just like a header or footer in Word 2007, capsule
you can quickly add a header or footer to a workbook in Excel 2007.  You can add the date, time, filename or any other information you would like to make available to readers of your spreadsheet.

To create a header or footer in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Text” group – it will be on the right hand side of the ribbon

3) Click on “Header & Footer”

You will see a new tab appear on the ribbon called “Header & Footer Tools – Design”.  Using the buttons on this tab of the ribbon, you can quickly add:

  • Page Number;
  • Number of Pages;
  • Current Date;
  • Current Time;
  • File Path;
  • File Name;
  • Sheet Name; or a
  • Picture

To the header or footer of your document.  To switch from the header to the footer, simply click on “Go to Footer” which you will find in the “Navigation” group about half way along the ribbon.

‘till next time!
TNP 😉
Do you want to stop people messing with your data, site formulas, hospital
formatting, or all of the above in Excel 2007?  Well did you know you very quickly protect your spreadsheet from those rogue operators!

Here is how you do it in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are currently looking at the sheet you want to protect

2) Click on the “Review” tab in the ribbon”

3) Look for the “Changes” group”

4) Click on “Protect Sheet”

A little “Protect Sheet” dialog box will appear that will give you a number of options, so you can be very granular in how much control you want people to have over the sheet.

For example, you can allow users to select cells, but not format them.  You can allow people to insert rows, but not insert columns.  And best of all you can add a password to the sheet to ensure only you can make any changes to what can and can’t be modified.

Now, you are really in control!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells directly impact on the calculated value of a cell in Excel 2007.

By using the “Trace Precedents” feature, buy cialis
you can very quickly understand exactly which cells influence the output of a cell.  The best part of this feature is, nurse
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.

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

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!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007, search
Excel 2010 or Excel 2013.

By using the “Trace Dependents” feature, you can very quickly understand exactly the influence a cell has in your spreadsheet.  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.

To turn on Trace Dependents:

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

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

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

4) Click on “Trace Dependents”

Now you will see arrows pointing you in the right direction!

‘till next time!
TNP 😉

Did you start creating a presentation in PowerPoint 2007, troche only to realise after you perfected 67 different slides that you really should have used Arial instead of Verdana?

Well there is a very quick way to replace one font with another in PowerPoint 2007.  Here is how:

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

2) Look for the “Editing” group – which you will find on the right hand side of the ribbon

3) Click on the little arrow beside “Replace”

4) Click on “Replace Fonts…”

From the box that appears, simply select the font you want to replace, with the new font, and click “Replace”

‘till next time!
TNP 😉

Have you ever built an awesome slide with lots of different objects?  Well then I am sure you will understand how frustrating it can be when you need to select an object that is behind 3 or 4 other ones!

Did you know there is a great tool you can use called the “Selection Pane”, recipe that will help you select those pesky, online
hard to get to objects?

Selection Pane simply lists all the objects that are on a slide, sovaldi sale in a simple to use task pane to the right hand side of your PowerPoint 2007 screen.  Using Selection pan you can quickly select any object, not matter how far to the back of the slide it is.

To turn on the selection pane:

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

2) Look for the “Editing” Group – you will find it on the far right hand side of the ribbon

3) Click on the little arrow beside the “Select” button

4) Click on “Selection Pane…”

 

‘till next time!
TNP 😉

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

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

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.

‘till next time!
TNP 😉

Are you sick of clicking your mouse, health hitting a key, mind or pressing next on your wireless presenter?

Well in PowerPoint 2007, no rx you can set up your presentation so that each slide automatically advances after so many seconds.

To make a slide automatically advance after a certain amount of time:

1) Make sure you are looking at the slide you want to apply the timing to

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

3) Look for the “Advance Slide” section at the far right hand side of the ribbon

4) Check the “Automatically After:” box, and then input the number of minutes and seconds you would like the slide to be visible before advancing to the next.

If you are unhappy with automatically advancing slides, don’t worry – you can still use the mouse click to move to the next one.  And if you really hate it, you can simply uncheck the “Automatically After:” check box to stop the timed slide advance from occurring.

‘till next time!
TNP 😉

Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, prostate and what the email subject is?

Well using the “Auto Preview” feature in Outlook 2007, more about
you can now view the first couple of lines of an email – giving you all the information you need to triage and prioritise the long list of emails in your inbox.

To turn on (or off) Auto Preview in Outlook 2007:

1) Click on “View”

2) Click on “AutoPreview”

 

Simple as that!

‘till next time!
TNP 😉

Have you ever noticed whenever you reply to an email the font colour isn’t black, one Health
but a dark blue?

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

To do so:

1) Click on “Tools”

2) Click on “Options”

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. 

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

 

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

‘till next time!
TNP 😉

If you regularly use the quick search feature of Outlook 2007, prescription
you will be very familiar with the yellow highlight that is used to highlight search terms found in your inbox.

But did you know, medicine
if yellow isn’t your favourite colour, urologist
you can change the search highlight to any colour you want?

To change the search highlight color in Outlook 2007:

1) Click on “Tools”

2) Run your mouse over “Instant Search” to expand the menu

3) Click on “Search Options”

4) Look just over half way down the “Search Options” box, and click on “Change…”

5) Select your favourite colour from the “Color” box that appears

6) Click “OK”

Now you can highlight your search terms in pink, blue, red, orange or any other colour under the rainbow!

‘till next time!
TNP 😉

Are you sick of those extra long forwarded emails that seem to go on forever and ever?  Did you want to keep all that content for reference, ambulance
but make sure that what you have to add to the forward is clearly delivered?

One way to do that is to forward an email as an attachment.  Instead of a long email thread appearing below your message, it is neatly tucked away in an attachment so your message gets all the attention!

To forward an email as an attachment in Outlook 2007:

1) Select the email you want to forward

2) Click on “Actions”

3) Click on “ Forward as Attachment”

4) Compose your message, and hit Send

‘till next time!
TNP 😉

Does your Junk Mail folder in Outlook 2007 seem to continually build up with… well… junk mail?  If you are confident that no important mail ever ends up in your junk mail folder, epilepsy
you can set Outlook to automatically delete junk mail instead.

To automatically delete junk mail in Outlook 2007:

1) Click on “Tools”

2) Click on “Options”

3) Make sure you are on the “Preferences” tab”

4) In the “E-mail” section, click on the “Junk E-mail…” button

5) On the “Options” tab, look half way down for a checkbox that says “Permanently delete suspected junk e-mail instead of moving it to the Junk E-mail folder”.  Check that check box.

To stop the automatic deletion of junk mail, repeat the process, and just uncheck the checkbox in step 5

‘till next time!
TNP 😉

You know how that box always pops up whenever you have a reminder in Outlook 2007?  Well if you accidentally close it, site and want to review all the reminders you currently have, obesity
there is a quick way to make the reminders window appear again.

1) Click on “View”

2) Click on “Reminders Window”

 

Easy as that!

‘till next time!
TNP 😉

Do you want a great looking presentation, stuff
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?

Well the simple, Breast
and great looking option is to use a Slide Background.  A slide background is a simple gradient that will turn any standard barebones deck into one that looks very professional.

To add a simple background to your PowerPoint 2007 presentation:

1) Click on the “Design” tab of the ribbon

2) Look for the “Background” group – on the right hand side of the ribbon

3) Click on “Background Styles”

4) Select your preferred background

 

You will notice that not all the colours of the rainbow are available.  Background styles are linked to the current colour palette that you have selected in the document.  If you play around with the colors by clicking on the “Colors” button whilst you are still on the “Design” tab of the ribbon, you will notice the background colour change to match the new palette.

‘till next time!
TNP 😉

Do you want to do some hard core data manipulation in your PowerPoint presentation?

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

To insert an Excel table in PowerPoint 2007, no rx PowerPoint 2010 or PowerPoint 2013:

1) Make sure you are on the slide you want to include the table in

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

 

‘till next time!
TNP 😉

Do you want to copy one, this
two, prostate three or more slides and reuse them in your PowerPoint 2007 slide deck?

There are two ways you can go about it – the first is plain old copy and paste.  The other is to use the “Duplicate Slide” feature.

To duplicate slides in PowerPoint 2007:

1) Select the slide or slides you want to duplicate

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

3) Look for the “Slides” group

4) Click on the little arrow underneath “New Slide”

5) Click on “Duplicate Selected Slides”

 

‘till next time!
TNP 😉

Do you want to create a slide that is Portrait, symptoms
instead of the default Landscape slide orientation?

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, discount
just repeat the process above, but instead of clicking “Portrait” at step 4, click on “Landscape”.

 

‘till next time!
TNP 😉

Don’t you hate it when you accidently click on a text box on your slide and move it?  Before you know it, rx
your heading one one slide, or the body text on another is completely out of whack with the rest of your presentation.

The good news is that there is a way to reset the slide back to normal.  Funnily enough, it is called “Reset”.  The best of this feature is, that it only resets the layout of the slide – your text will remain intact!

To reset a slide in PowerPoint 2007:

1) Select the slide you want to reset

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

3) Look for the “Slides” group, close to the left hand side of the ribbon

4) Click on the “Reset” button – the button that looks like a slide with a blue arrow pointing to the left

 

‘till next time!
TNP 😉

Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?

To do that, sale you need to “Freeze” the top row of your sheet.

To Freeze the top row in Excel 2007, Excel 2010 or Excel 2013:

1) Click on the “View” tab of the ribbon

2) Look for the “Window” group

3) Click on “Freeze Panes”

4) Click on “Freeze Top Row”

 

To unfreeze the top row, just repeat the process above, but instead of clicking “Freeze Top Row” in step 4), just click on “Unfreeze Panes”

‘till next time!
TNP 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from highest to lowest, urticaria
or biggest to smallest?

To sort from high to low in Excel 2007, Sildenafil
Excel 2010 or Excel 2013
:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon

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.

 

‘till next time!
TNP 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from lowest to highest, rx or smallest to biggest?

To sort from low to high in Excel 2007, Excel 2010 or Excel 2013:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon

3) Look for the “Sort & Filter” group

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

 

‘till next time!
TNP 😉

Sort High to Low in Excel

So if you have been reading The New Paperclip for a while, surgeon you will know that the guy behind The New Paperclip is Paul Woods. Recently he delivered two presentations at two separate events – Microsoft’s TechEd Australia Conference, prescription and the community driven OfficeDevCon09. Here are the two presentations available on Slideshare…

web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
View more presentations from Paul Woods.
View more presentations from Paul Woods.

I hope you enjoy!

’till next time!
TNP 😉

Oh My!  Hasn’t Christmas snuck up on us this year!  Just over two weeks until the big day, prosthetic
I thought I might share with you some great resources over at Office Online which will help you make the most of Christmas this year!

1) Christmas Clipart!

Are you looking for some pictures or artwork to make your home made Christmas Cards look amazing!  There are over 100 pages of Christmas Clipart available at

2) Holiday Letter Tutorial!

This is a great course that will help you create a decorate a newsletter, create mailing labels for your envelopes, and create some holiday decorations.  It is about 30 minutes long – but will be a great investment of your time this Christmas to help you spread the holiday cheer!

3) Create your own Holiday Greeting Cards!

Another great resource to help you great special greeting cards to share with your family and friends – from the traditional, to the new age multimedia greeting cards with PowerPoint.

So there you have it, three great resources to help you make the most of Christmas this year!

‘till next time!
TNP 😉

With 2009 almost behind us, healthful
now is the time to start creating your own 2010 calendars using Word 2007.

It is a lot simpler than you think!  Here is how you do it.

1) Make sure you are connected to the internet

2) Click on the Office Orb in the top left hand corner of the screen (the old file menu)

3) Click on “New”

4) In the “New Document” dialog box that appears, on the left hand side you will see a long list of different template types you can find on Microsoft Office Online.  click on “Calendars”

5) Click on “2010 calendars”

6) Pick your favourite design from the dozens that appear!  Once you have selected the one you like, just click “Download” in the bottom right hand corner

7) After Word downloads the Calendar, it will appear ready for you to use, edit or print straight away.

How easy is that!  Happy New Year!

‘till next time!
TNP 😉

Did you know in Word you can automatically select all the text in a document that shares the same formatting?

For example, read
you can select all text that is Arial, click 12pt.  Very handy if you are not using styles, dosage
yet want to apply a formatting change across select blocks of text.

To select text with similar formatting in Word 2007:

1) Select some of the text you want to select

2) Make sure you are on the home tab of the ribbon

3) Look for the “Editing” group on the right hand side of the ribbon

4) Click on “Select”

5) Click on “Select Text with Similar Formatting”

‘till next time!
TNP 😉

Do you want to quickly change some text from lowercase to uppercase, online without having to retype it?

It is really simple in Word 2007!

1) Select the text you want to change to UPPERCASE

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

3) Look for the “Font” group

4) Click on the “Change Case” button – which you will find directly below where you select the font size

5) From the menu that appears, decease
click on “UPPERCASE”

Whilst you are there, check out some of the other case options you can have… like Sentence case, lowercase, Capitalize Each Word, and tOGGLE cASE.

‘till next time!
TNP 😉

You know there are just some times when you really need to make a point!  And using a double underline is a great way of making sure your readers know exactly what you mean!

Doing a normal, women’s health
single underline in Word 2007 is easy… but what about a double underline?  Well it is just as easy.

1) Select the text you want to double underline

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

3) Look for the “Font” group"

4) Click on the little down arrow beside the “Underline” button – that is the one that looks like a U with a underline below it

5) Select the underline that you would like to use.

‘till next time!
TNP 😉

Are you doing a school assignment, anorexia
or a report for work, medicine and have been told you need to use “Double Line Spacing

In Word 2007, visit this
is is fairly simple to do just that.

1) Select the text in your document that you want to apply double line spacing to

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

3) Look for the “Paragraph” group

4) Look for the button that has an up arrow and a down arrow, with lines beside them – that is the “Line Spacing” button.  Click on that, and select “2.0” – that is double line spacing.

To change back to the default spacing (1.15) or single line spacing (1.0), simply repeat the procedure above.

‘till next time!
TNP 😉

Do you want to produce a document that uses a different paper size than Letter or A4?  What about Legal, nurse
A5, A3, Tabloid, Japanese Postcard or the dozens of other paper sizes available?

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

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

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, ampoule you need to make sure that text is marked as the right language.

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”

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!
TNP 😉

Word 2007 has some fairly powerful translation features that can help you quickly understand what a word is in a different language.

By using the “Translation ScreenTip” you can see the translation of most words simply by moving the mouse over them!

Translation ScreenTip works for the following languages:

  • Arabic (Saudi Arabia)
  • English (United States)
  • French (France)
  • Spanish (Spain, here International Sort)

To turn on Translation ScreenTip:

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

2) Look for the “Proofing” group

3) Click on “Translation ScreenTip”

4) Select the language you want to see the translation for, meningitis
or click on “Turn Off Translation ScreenTip” to turn the translation off.

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, diabetes and Pregnancy
or click on “Define New Bullet”

If you are defining a new bullet, store
you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, story
or click on “Define New Bullet”

If you are defining a new bullet, you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Just like a header or footer in Word 2007, capsule
you can quickly add a header or footer to a workbook in Excel 2007.  You can add the date, time, filename or any other information you would like to make available to readers of your spreadsheet.

To create a header or footer in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Text” group – it will be on the right hand side of the ribbon

3) Click on “Header & Footer”

You will see a new tab appear on the ribbon called “Header & Footer Tools – Design”.  Using the buttons on this tab of the ribbon, you can quickly add:

  • Page Number;
  • Number of Pages;
  • Current Date;
  • Current Time;
  • File Path;
  • File Name;
  • Sheet Name; or a
  • Picture

To the header or footer of your document.  To switch from the header to the footer, simply click on “Go to Footer” which you will find in the “Navigation” group about half way along the ribbon.

‘till next time!
TNP 😉
Do you want to stop people messing with your data, site formulas, hospital
formatting, or all of the above in Excel 2007?  Well did you know you very quickly protect your spreadsheet from those rogue operators!

Here is how you do it in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are currently looking at the sheet you want to protect

2) Click on the “Review” tab in the ribbon”

3) Look for the “Changes” group”

4) Click on “Protect Sheet”

A little “Protect Sheet” dialog box will appear that will give you a number of options, so you can be very granular in how much control you want people to have over the sheet.

For example, you can allow users to select cells, but not format them.  You can allow people to insert rows, but not insert columns.  And best of all you can add a password to the sheet to ensure only you can make any changes to what can and can’t be modified.

Now, you are really in control!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells directly impact on the calculated value of a cell in Excel 2007.

By using the “Trace Precedents” feature, buy cialis
you can very quickly understand exactly which cells influence the output of a cell.  The best part of this feature is, nurse
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.

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

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!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007, search
Excel 2010 or Excel 2013.

By using the “Trace Dependents” feature, you can very quickly understand exactly the influence a cell has in your spreadsheet.  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.

To turn on Trace Dependents:

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

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

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

4) Click on “Trace Dependents”

Now you will see arrows pointing you in the right direction!

‘till next time!
TNP 😉

Did you start creating a presentation in PowerPoint 2007, troche only to realise after you perfected 67 different slides that you really should have used Arial instead of Verdana?

Well there is a very quick way to replace one font with another in PowerPoint 2007.  Here is how:

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

2) Look for the “Editing” group – which you will find on the right hand side of the ribbon

3) Click on the little arrow beside “Replace”

4) Click on “Replace Fonts…”

From the box that appears, simply select the font you want to replace, with the new font, and click “Replace”

‘till next time!
TNP 😉

Have you ever built an awesome slide with lots of different objects?  Well then I am sure you will understand how frustrating it can be when you need to select an object that is behind 3 or 4 other ones!

Did you know there is a great tool you can use called the “Selection Pane”, recipe that will help you select those pesky, online
hard to get to objects?

Selection Pane simply lists all the objects that are on a slide, sovaldi sale in a simple to use task pane to the right hand side of your PowerPoint 2007 screen.  Using Selection pan you can quickly select any object, not matter how far to the back of the slide it is.

To turn on the selection pane:

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

2) Look for the “Editing” Group – you will find it on the far right hand side of the ribbon

3) Click on the little arrow beside the “Select” button

4) Click on “Selection Pane…”

 

‘till next time!
TNP 😉

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

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

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.

‘till next time!
TNP 😉

Are you sick of clicking your mouse, health hitting a key, mind or pressing next on your wireless presenter?

Well in PowerPoint 2007, no rx you can set up your presentation so that each slide automatically advances after so many seconds.

To make a slide automatically advance after a certain amount of time:

1) Make sure you are looking at the slide you want to apply the timing to

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

3) Look for the “Advance Slide” section at the far right hand side of the ribbon

4) Check the “Automatically After:” box, and then input the number of minutes and seconds you would like the slide to be visible before advancing to the next.

If you are unhappy with automatically advancing slides, don’t worry – you can still use the mouse click to move to the next one.  And if you really hate it, you can simply uncheck the “Automatically After:” check box to stop the timed slide advance from occurring.

‘till next time!
TNP 😉

Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, prostate and what the email subject is?

Well using the “Auto Preview” feature in Outlook 2007, more about
you can now view the first couple of lines of an email – giving you all the information you need to triage and prioritise the long list of emails in your inbox.

To turn on (or off) Auto Preview in Outlook 2007:

1) Click on “View”

2) Click on “AutoPreview”

 

Simple as that!

‘till next time!
TNP 😉

Have you ever noticed whenever you reply to an email the font colour isn’t black, one Health
but a dark blue?

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

To do so:

1) Click on “Tools”

2) Click on “Options”

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. 

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

 

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

‘till next time!
TNP 😉

If you regularly use the quick search feature of Outlook 2007, prescription
you will be very familiar with the yellow highlight that is used to highlight search terms found in your inbox.

But did you know, medicine
if yellow isn’t your favourite colour, urologist
you can change the search highlight to any colour you want?

To change the search highlight color in Outlook 2007:

1) Click on “Tools”

2) Run your mouse over “Instant Search” to expand the menu

3) Click on “Search Options”

4) Look just over half way down the “Search Options” box, and click on “Change…”

5) Select your favourite colour from the “Color” box that appears

6) Click “OK”

Now you can highlight your search terms in pink, blue, red, orange or any other colour under the rainbow!

‘till next time!
TNP 😉

Are you sick of those extra long forwarded emails that seem to go on forever and ever?  Did you want to keep all that content for reference, ambulance
but make sure that what you have to add to the forward is clearly delivered?

One way to do that is to forward an email as an attachment.  Instead of a long email thread appearing below your message, it is neatly tucked away in an attachment so your message gets all the attention!

To forward an email as an attachment in Outlook 2007:

1) Select the email you want to forward

2) Click on “Actions”

3) Click on “ Forward as Attachment”

4) Compose your message, and hit Send

‘till next time!
TNP 😉

Does your Junk Mail folder in Outlook 2007 seem to continually build up with… well… junk mail?  If you are confident that no important mail ever ends up in your junk mail folder, epilepsy
you can set Outlook to automatically delete junk mail instead.

To automatically delete junk mail in Outlook 2007:

1) Click on “Tools”

2) Click on “Options”

3) Make sure you are on the “Preferences” tab”

4) In the “E-mail” section, click on the “Junk E-mail…” button

5) On the “Options” tab, look half way down for a checkbox that says “Permanently delete suspected junk e-mail instead of moving it to the Junk E-mail folder”.  Check that check box.

To stop the automatic deletion of junk mail, repeat the process, and just uncheck the checkbox in step 5

‘till next time!
TNP 😉

You know how that box always pops up whenever you have a reminder in Outlook 2007?  Well if you accidentally close it, site and want to review all the reminders you currently have, obesity
there is a quick way to make the reminders window appear again.

1) Click on “View”

2) Click on “Reminders Window”

 

Easy as that!

‘till next time!
TNP 😉

Do you want a great looking presentation, stuff
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?

Well the simple, Breast
and great looking option is to use a Slide Background.  A slide background is a simple gradient that will turn any standard barebones deck into one that looks very professional.

To add a simple background to your PowerPoint 2007 presentation:

1) Click on the “Design” tab of the ribbon

2) Look for the “Background” group – on the right hand side of the ribbon

3) Click on “Background Styles”

4) Select your preferred background

 

You will notice that not all the colours of the rainbow are available.  Background styles are linked to the current colour palette that you have selected in the document.  If you play around with the colors by clicking on the “Colors” button whilst you are still on the “Design” tab of the ribbon, you will notice the background colour change to match the new palette.

‘till next time!
TNP 😉

Do you want to do some hard core data manipulation in your PowerPoint presentation?

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

To insert an Excel table in PowerPoint 2007, no rx PowerPoint 2010 or PowerPoint 2013:

1) Make sure you are on the slide you want to include the table in

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

 

‘till next time!
TNP 😉

Do you want to copy one, this
two, prostate three or more slides and reuse them in your PowerPoint 2007 slide deck?

There are two ways you can go about it – the first is plain old copy and paste.  The other is to use the “Duplicate Slide” feature.

To duplicate slides in PowerPoint 2007:

1) Select the slide or slides you want to duplicate

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

3) Look for the “Slides” group

4) Click on the little arrow underneath “New Slide”

5) Click on “Duplicate Selected Slides”

 

‘till next time!
TNP 😉

Do you want to create a slide that is Portrait, symptoms
instead of the default Landscape slide orientation?

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, discount
just repeat the process above, but instead of clicking “Portrait” at step 4, click on “Landscape”.

 

‘till next time!
TNP 😉

Don’t you hate it when you accidently click on a text box on your slide and move it?  Before you know it, rx
your heading one one slide, or the body text on another is completely out of whack with the rest of your presentation.

The good news is that there is a way to reset the slide back to normal.  Funnily enough, it is called “Reset”.  The best of this feature is, that it only resets the layout of the slide – your text will remain intact!

To reset a slide in PowerPoint 2007:

1) Select the slide you want to reset

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

3) Look for the “Slides” group, close to the left hand side of the ribbon

4) Click on the “Reset” button – the button that looks like a slide with a blue arrow pointing to the left

 

‘till next time!
TNP 😉

Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?

To do that, sale you need to “Freeze” the top row of your sheet.

To Freeze the top row in Excel 2007, Excel 2010 or Excel 2013:

1) Click on the “View” tab of the ribbon

2) Look for the “Window” group

3) Click on “Freeze Panes”

4) Click on “Freeze Top Row”

 

To unfreeze the top row, just repeat the process above, but instead of clicking “Freeze Top Row” in step 4), just click on “Unfreeze Panes”

‘till next time!
TNP 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from highest to lowest, urticaria
or biggest to smallest?

To sort from high to low in Excel 2007, Sildenafil
Excel 2010 or Excel 2013
:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon

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.

 

‘till next time!
TNP 😉

Add a Excel spreadsheet to your PowerPoint presentation

So if you have been reading The New Paperclip for a while, surgeon you will know that the guy behind The New Paperclip is Paul Woods. Recently he delivered two presentations at two separate events – Microsoft’s TechEd Australia Conference, prescription and the community driven OfficeDevCon09. Here are the two presentations available on Slideshare…

web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
View more presentations from Paul Woods.
View more presentations from Paul Woods.

I hope you enjoy!

’till next time!
TNP 😉

Oh My!  Hasn’t Christmas snuck up on us this year!  Just over two weeks until the big day, prosthetic
I thought I might share with you some great resources over at Office Online which will help you make the most of Christmas this year!

1) Christmas Clipart!

Are you looking for some pictures or artwork to make your home made Christmas Cards look amazing!  There are over 100 pages of Christmas Clipart available at

2) Holiday Letter Tutorial!

This is a great course that will help you create a decorate a newsletter, create mailing labels for your envelopes, and create some holiday decorations.  It is about 30 minutes long – but will be a great investment of your time this Christmas to help you spread the holiday cheer!

3) Create your own Holiday Greeting Cards!

Another great resource to help you great special greeting cards to share with your family and friends – from the traditional, to the new age multimedia greeting cards with PowerPoint.

So there you have it, three great resources to help you make the most of Christmas this year!

‘till next time!
TNP 😉

With 2009 almost behind us, healthful
now is the time to start creating your own 2010 calendars using Word 2007.

It is a lot simpler than you think!  Here is how you do it.

1) Make sure you are connected to the internet

2) Click on the Office Orb in the top left hand corner of the screen (the old file menu)

3) Click on “New”

4) In the “New Document” dialog box that appears, on the left hand side you will see a long list of different template types you can find on Microsoft Office Online.  click on “Calendars”

5) Click on “2010 calendars”

6) Pick your favourite design from the dozens that appear!  Once you have selected the one you like, just click “Download” in the bottom right hand corner

7) After Word downloads the Calendar, it will appear ready for you to use, edit or print straight away.

How easy is that!  Happy New Year!

‘till next time!
TNP 😉

Did you know in Word you can automatically select all the text in a document that shares the same formatting?

For example, read
you can select all text that is Arial, click 12pt.  Very handy if you are not using styles, dosage
yet want to apply a formatting change across select blocks of text.

To select text with similar formatting in Word 2007:

1) Select some of the text you want to select

2) Make sure you are on the home tab of the ribbon

3) Look for the “Editing” group on the right hand side of the ribbon

4) Click on “Select”

5) Click on “Select Text with Similar Formatting”

‘till next time!
TNP 😉

Do you want to quickly change some text from lowercase to uppercase, online without having to retype it?

It is really simple in Word 2007!

1) Select the text you want to change to UPPERCASE

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

3) Look for the “Font” group

4) Click on the “Change Case” button – which you will find directly below where you select the font size

5) From the menu that appears, decease
click on “UPPERCASE”

Whilst you are there, check out some of the other case options you can have… like Sentence case, lowercase, Capitalize Each Word, and tOGGLE cASE.

‘till next time!
TNP 😉

You know there are just some times when you really need to make a point!  And using a double underline is a great way of making sure your readers know exactly what you mean!

Doing a normal, women’s health
single underline in Word 2007 is easy… but what about a double underline?  Well it is just as easy.

1) Select the text you want to double underline

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

3) Look for the “Font” group"

4) Click on the little down arrow beside the “Underline” button – that is the one that looks like a U with a underline below it

5) Select the underline that you would like to use.

‘till next time!
TNP 😉

Are you doing a school assignment, anorexia
or a report for work, medicine and have been told you need to use “Double Line Spacing

In Word 2007, visit this
is is fairly simple to do just that.

1) Select the text in your document that you want to apply double line spacing to

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

3) Look for the “Paragraph” group

4) Look for the button that has an up arrow and a down arrow, with lines beside them – that is the “Line Spacing” button.  Click on that, and select “2.0” – that is double line spacing.

To change back to the default spacing (1.15) or single line spacing (1.0), simply repeat the procedure above.

‘till next time!
TNP 😉

Do you want to produce a document that uses a different paper size than Letter or A4?  What about Legal, nurse
A5, A3, Tabloid, Japanese Postcard or the dozens of other paper sizes available?

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

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

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, ampoule you need to make sure that text is marked as the right language.

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”

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!
TNP 😉

Word 2007 has some fairly powerful translation features that can help you quickly understand what a word is in a different language.

By using the “Translation ScreenTip” you can see the translation of most words simply by moving the mouse over them!

Translation ScreenTip works for the following languages:

  • Arabic (Saudi Arabia)
  • English (United States)
  • French (France)
  • Spanish (Spain, here International Sort)

To turn on Translation ScreenTip:

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

2) Look for the “Proofing” group

3) Click on “Translation ScreenTip”

4) Select the language you want to see the translation for, meningitis
or click on “Turn Off Translation ScreenTip” to turn the translation off.

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, diabetes and Pregnancy
or click on “Define New Bullet”

If you are defining a new bullet, store
you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, story
or click on “Define New Bullet”

If you are defining a new bullet, you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Just like a header or footer in Word 2007, capsule
you can quickly add a header or footer to a workbook in Excel 2007.  You can add the date, time, filename or any other information you would like to make available to readers of your spreadsheet.

To create a header or footer in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Text” group – it will be on the right hand side of the ribbon

3) Click on “Header & Footer”

You will see a new tab appear on the ribbon called “Header & Footer Tools – Design”.  Using the buttons on this tab of the ribbon, you can quickly add:

  • Page Number;
  • Number of Pages;
  • Current Date;
  • Current Time;
  • File Path;
  • File Name;
  • Sheet Name; or a
  • Picture

To the header or footer of your document.  To switch from the header to the footer, simply click on “Go to Footer” which you will find in the “Navigation” group about half way along the ribbon.

‘till next time!
TNP 😉
Do you want to stop people messing with your data, site formulas, hospital
formatting, or all of the above in Excel 2007?  Well did you know you very quickly protect your spreadsheet from those rogue operators!

Here is how you do it in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are currently looking at the sheet you want to protect

2) Click on the “Review” tab in the ribbon”

3) Look for the “Changes” group”

4) Click on “Protect Sheet”

A little “Protect Sheet” dialog box will appear that will give you a number of options, so you can be very granular in how much control you want people to have over the sheet.

For example, you can allow users to select cells, but not format them.  You can allow people to insert rows, but not insert columns.  And best of all you can add a password to the sheet to ensure only you can make any changes to what can and can’t be modified.

Now, you are really in control!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells directly impact on the calculated value of a cell in Excel 2007.

By using the “Trace Precedents” feature, buy cialis
you can very quickly understand exactly which cells influence the output of a cell.  The best part of this feature is, nurse
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.

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

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!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007, search
Excel 2010 or Excel 2013.

By using the “Trace Dependents” feature, you can very quickly understand exactly the influence a cell has in your spreadsheet.  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.

To turn on Trace Dependents:

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

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

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

4) Click on “Trace Dependents”

Now you will see arrows pointing you in the right direction!

‘till next time!
TNP 😉

Did you start creating a presentation in PowerPoint 2007, troche only to realise after you perfected 67 different slides that you really should have used Arial instead of Verdana?

Well there is a very quick way to replace one font with another in PowerPoint 2007.  Here is how:

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

2) Look for the “Editing” group – which you will find on the right hand side of the ribbon

3) Click on the little arrow beside “Replace”

4) Click on “Replace Fonts…”

From the box that appears, simply select the font you want to replace, with the new font, and click “Replace”

‘till next time!
TNP 😉

Have you ever built an awesome slide with lots of different objects?  Well then I am sure you will understand how frustrating it can be when you need to select an object that is behind 3 or 4 other ones!

Did you know there is a great tool you can use called the “Selection Pane”, recipe that will help you select those pesky, online
hard to get to objects?

Selection Pane simply lists all the objects that are on a slide, sovaldi sale in a simple to use task pane to the right hand side of your PowerPoint 2007 screen.  Using Selection pan you can quickly select any object, not matter how far to the back of the slide it is.

To turn on the selection pane:

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

2) Look for the “Editing” Group – you will find it on the far right hand side of the ribbon

3) Click on the little arrow beside the “Select” button

4) Click on “Selection Pane…”

 

‘till next time!
TNP 😉

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

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

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.

‘till next time!
TNP 😉

Are you sick of clicking your mouse, health hitting a key, mind or pressing next on your wireless presenter?

Well in PowerPoint 2007, no rx you can set up your presentation so that each slide automatically advances after so many seconds.

To make a slide automatically advance after a certain amount of time:

1) Make sure you are looking at the slide you want to apply the timing to

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

3) Look for the “Advance Slide” section at the far right hand side of the ribbon

4) Check the “Automatically After:” box, and then input the number of minutes and seconds you would like the slide to be visible before advancing to the next.

If you are unhappy with automatically advancing slides, don’t worry – you can still use the mouse click to move to the next one.  And if you really hate it, you can simply uncheck the “Automatically After:” check box to stop the timed slide advance from occurring.

‘till next time!
TNP 😉

Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, prostate and what the email subject is?

Well using the “Auto Preview” feature in Outlook 2007, more about
you can now view the first couple of lines of an email – giving you all the information you need to triage and prioritise the long list of emails in your inbox.

To turn on (or off) Auto Preview in Outlook 2007:

1) Click on “View”

2) Click on “AutoPreview”

 

Simple as that!

‘till next time!
TNP 😉

Have you ever noticed whenever you reply to an email the font colour isn’t black, one Health
but a dark blue?

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

To do so:

1) Click on “Tools”

2) Click on “Options”

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. 

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

 

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

‘till next time!
TNP 😉

If you regularly use the quick search feature of Outlook 2007, prescription
you will be very familiar with the yellow highlight that is used to highlight search terms found in your inbox.

But did you know, medicine
if yellow isn’t your favourite colour, urologist
you can change the search highlight to any colour you want?

To change the search highlight color in Outlook 2007:

1) Click on “Tools”

2) Run your mouse over “Instant Search” to expand the menu

3) Click on “Search Options”

4) Look just over half way down the “Search Options” box, and click on “Change…”

5) Select your favourite colour from the “Color” box that appears

6) Click “OK”

Now you can highlight your search terms in pink, blue, red, orange or any other colour under the rainbow!

‘till next time!
TNP 😉

Are you sick of those extra long forwarded emails that seem to go on forever and ever?  Did you want to keep all that content for reference, ambulance
but make sure that what you have to add to the forward is clearly delivered?

One way to do that is to forward an email as an attachment.  Instead of a long email thread appearing below your message, it is neatly tucked away in an attachment so your message gets all the attention!

To forward an email as an attachment in Outlook 2007:

1) Select the email you want to forward

2) Click on “Actions”

3) Click on “ Forward as Attachment”

4) Compose your message, and hit Send

‘till next time!
TNP 😉

Does your Junk Mail folder in Outlook 2007 seem to continually build up with… well… junk mail?  If you are confident that no important mail ever ends up in your junk mail folder, epilepsy
you can set Outlook to automatically delete junk mail instead.

To automatically delete junk mail in Outlook 2007:

1) Click on “Tools”

2) Click on “Options”

3) Make sure you are on the “Preferences” tab”

4) In the “E-mail” section, click on the “Junk E-mail…” button

5) On the “Options” tab, look half way down for a checkbox that says “Permanently delete suspected junk e-mail instead of moving it to the Junk E-mail folder”.  Check that check box.

To stop the automatic deletion of junk mail, repeat the process, and just uncheck the checkbox in step 5

‘till next time!
TNP 😉

You know how that box always pops up whenever you have a reminder in Outlook 2007?  Well if you accidentally close it, site and want to review all the reminders you currently have, obesity
there is a quick way to make the reminders window appear again.

1) Click on “View”

2) Click on “Reminders Window”

 

Easy as that!

‘till next time!
TNP 😉

Do you want a great looking presentation, stuff
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?

Well the simple, Breast
and great looking option is to use a Slide Background.  A slide background is a simple gradient that will turn any standard barebones deck into one that looks very professional.

To add a simple background to your PowerPoint 2007 presentation:

1) Click on the “Design” tab of the ribbon

2) Look for the “Background” group – on the right hand side of the ribbon

3) Click on “Background Styles”

4) Select your preferred background

 

You will notice that not all the colours of the rainbow are available.  Background styles are linked to the current colour palette that you have selected in the document.  If you play around with the colors by clicking on the “Colors” button whilst you are still on the “Design” tab of the ribbon, you will notice the background colour change to match the new palette.

‘till next time!
TNP 😉

Do you want to do some hard core data manipulation in your PowerPoint presentation?

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

To insert an Excel table in PowerPoint 2007, no rx PowerPoint 2010 or PowerPoint 2013:

1) Make sure you are on the slide you want to include the table in

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

 

‘till next time!
TNP 😉

Change the default width of cells in Excel

So if you have been reading The New Paperclip for a while, surgeon you will know that the guy behind The New Paperclip is Paul Woods. Recently he delivered two presentations at two separate events – Microsoft’s TechEd Australia Conference, prescription and the community driven OfficeDevCon09. Here are the two presentations available on Slideshare…

web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
View more presentations from Paul Woods.
View more presentations from Paul Woods.

I hope you enjoy!

’till next time!
TNP 😉

Oh My!  Hasn’t Christmas snuck up on us this year!  Just over two weeks until the big day, prosthetic
I thought I might share with you some great resources over at Office Online which will help you make the most of Christmas this year!

1) Christmas Clipart!

Are you looking for some pictures or artwork to make your home made Christmas Cards look amazing!  There are over 100 pages of Christmas Clipart available at

2) Holiday Letter Tutorial!

This is a great course that will help you create a decorate a newsletter, create mailing labels for your envelopes, and create some holiday decorations.  It is about 30 minutes long – but will be a great investment of your time this Christmas to help you spread the holiday cheer!

3) Create your own Holiday Greeting Cards!

Another great resource to help you great special greeting cards to share with your family and friends – from the traditional, to the new age multimedia greeting cards with PowerPoint.

So there you have it, three great resources to help you make the most of Christmas this year!

‘till next time!
TNP 😉

With 2009 almost behind us, healthful
now is the time to start creating your own 2010 calendars using Word 2007.

It is a lot simpler than you think!  Here is how you do it.

1) Make sure you are connected to the internet

2) Click on the Office Orb in the top left hand corner of the screen (the old file menu)

3) Click on “New”

4) In the “New Document” dialog box that appears, on the left hand side you will see a long list of different template types you can find on Microsoft Office Online.  click on “Calendars”

5) Click on “2010 calendars”

6) Pick your favourite design from the dozens that appear!  Once you have selected the one you like, just click “Download” in the bottom right hand corner

7) After Word downloads the Calendar, it will appear ready for you to use, edit or print straight away.

How easy is that!  Happy New Year!

‘till next time!
TNP 😉

Did you know in Word you can automatically select all the text in a document that shares the same formatting?

For example, read
you can select all text that is Arial, click 12pt.  Very handy if you are not using styles, dosage
yet want to apply a formatting change across select blocks of text.

To select text with similar formatting in Word 2007:

1) Select some of the text you want to select

2) Make sure you are on the home tab of the ribbon

3) Look for the “Editing” group on the right hand side of the ribbon

4) Click on “Select”

5) Click on “Select Text with Similar Formatting”

‘till next time!
TNP 😉

Do you want to quickly change some text from lowercase to uppercase, online without having to retype it?

It is really simple in Word 2007!

1) Select the text you want to change to UPPERCASE

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

3) Look for the “Font” group

4) Click on the “Change Case” button – which you will find directly below where you select the font size

5) From the menu that appears, decease
click on “UPPERCASE”

Whilst you are there, check out some of the other case options you can have… like Sentence case, lowercase, Capitalize Each Word, and tOGGLE cASE.

‘till next time!
TNP 😉

You know there are just some times when you really need to make a point!  And using a double underline is a great way of making sure your readers know exactly what you mean!

Doing a normal, women’s health
single underline in Word 2007 is easy… but what about a double underline?  Well it is just as easy.

1) Select the text you want to double underline

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

3) Look for the “Font” group"

4) Click on the little down arrow beside the “Underline” button – that is the one that looks like a U with a underline below it

5) Select the underline that you would like to use.

‘till next time!
TNP 😉

Are you doing a school assignment, anorexia
or a report for work, medicine and have been told you need to use “Double Line Spacing

In Word 2007, visit this
is is fairly simple to do just that.

1) Select the text in your document that you want to apply double line spacing to

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

3) Look for the “Paragraph” group

4) Look for the button that has an up arrow and a down arrow, with lines beside them – that is the “Line Spacing” button.  Click on that, and select “2.0” – that is double line spacing.

To change back to the default spacing (1.15) or single line spacing (1.0), simply repeat the procedure above.

‘till next time!
TNP 😉

Do you want to produce a document that uses a different paper size than Letter or A4?  What about Legal, nurse
A5, A3, Tabloid, Japanese Postcard or the dozens of other paper sizes available?

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

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

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, ampoule you need to make sure that text is marked as the right language.

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”

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!
TNP 😉

Word 2007 has some fairly powerful translation features that can help you quickly understand what a word is in a different language.

By using the “Translation ScreenTip” you can see the translation of most words simply by moving the mouse over them!

Translation ScreenTip works for the following languages:

  • Arabic (Saudi Arabia)
  • English (United States)
  • French (France)
  • Spanish (Spain, here International Sort)

To turn on Translation ScreenTip:

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

2) Look for the “Proofing” group

3) Click on “Translation ScreenTip”

4) Select the language you want to see the translation for, meningitis
or click on “Turn Off Translation ScreenTip” to turn the translation off.

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, diabetes and Pregnancy
or click on “Define New Bullet”

If you are defining a new bullet, store
you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, story
or click on “Define New Bullet”

If you are defining a new bullet, you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Just like a header or footer in Word 2007, capsule
you can quickly add a header or footer to a workbook in Excel 2007.  You can add the date, time, filename or any other information you would like to make available to readers of your spreadsheet.

To create a header or footer in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Text” group – it will be on the right hand side of the ribbon

3) Click on “Header & Footer”

You will see a new tab appear on the ribbon called “Header & Footer Tools – Design”.  Using the buttons on this tab of the ribbon, you can quickly add:

  • Page Number;
  • Number of Pages;
  • Current Date;
  • Current Time;
  • File Path;
  • File Name;
  • Sheet Name; or a
  • Picture

To the header or footer of your document.  To switch from the header to the footer, simply click on “Go to Footer” which you will find in the “Navigation” group about half way along the ribbon.

‘till next time!
TNP 😉
Do you want to stop people messing with your data, site formulas, hospital
formatting, or all of the above in Excel 2007?  Well did you know you very quickly protect your spreadsheet from those rogue operators!

Here is how you do it in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are currently looking at the sheet you want to protect

2) Click on the “Review” tab in the ribbon”

3) Look for the “Changes” group”

4) Click on “Protect Sheet”

A little “Protect Sheet” dialog box will appear that will give you a number of options, so you can be very granular in how much control you want people to have over the sheet.

For example, you can allow users to select cells, but not format them.  You can allow people to insert rows, but not insert columns.  And best of all you can add a password to the sheet to ensure only you can make any changes to what can and can’t be modified.

Now, you are really in control!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells directly impact on the calculated value of a cell in Excel 2007.

By using the “Trace Precedents” feature, buy cialis
you can very quickly understand exactly which cells influence the output of a cell.  The best part of this feature is, nurse
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.

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

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!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007, search
Excel 2010 or Excel 2013.

By using the “Trace Dependents” feature, you can very quickly understand exactly the influence a cell has in your spreadsheet.  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.

To turn on Trace Dependents:

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

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

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

4) Click on “Trace Dependents”

Now you will see arrows pointing you in the right direction!

‘till next time!
TNP 😉

Did you start creating a presentation in PowerPoint 2007, troche only to realise after you perfected 67 different slides that you really should have used Arial instead of Verdana?

Well there is a very quick way to replace one font with another in PowerPoint 2007.  Here is how:

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

2) Look for the “Editing” group – which you will find on the right hand side of the ribbon

3) Click on the little arrow beside “Replace”

4) Click on “Replace Fonts…”

From the box that appears, simply select the font you want to replace, with the new font, and click “Replace”

‘till next time!
TNP 😉

Have you ever built an awesome slide with lots of different objects?  Well then I am sure you will understand how frustrating it can be when you need to select an object that is behind 3 or 4 other ones!

Did you know there is a great tool you can use called the “Selection Pane”, recipe that will help you select those pesky, online
hard to get to objects?

Selection Pane simply lists all the objects that are on a slide, sovaldi sale in a simple to use task pane to the right hand side of your PowerPoint 2007 screen.  Using Selection pan you can quickly select any object, not matter how far to the back of the slide it is.

To turn on the selection pane:

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

2) Look for the “Editing” Group – you will find it on the far right hand side of the ribbon

3) Click on the little arrow beside the “Select” button

4) Click on “Selection Pane…”

 

‘till next time!
TNP 😉

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

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

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.

‘till next time!
TNP 😉

Are you sick of clicking your mouse, health hitting a key, mind or pressing next on your wireless presenter?

Well in PowerPoint 2007, no rx you can set up your presentation so that each slide automatically advances after so many seconds.

To make a slide automatically advance after a certain amount of time:

1) Make sure you are looking at the slide you want to apply the timing to

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

3) Look for the “Advance Slide” section at the far right hand side of the ribbon

4) Check the “Automatically After:” box, and then input the number of minutes and seconds you would like the slide to be visible before advancing to the next.

If you are unhappy with automatically advancing slides, don’t worry – you can still use the mouse click to move to the next one.  And if you really hate it, you can simply uncheck the “Automatically After:” check box to stop the timed slide advance from occurring.

‘till next time!
TNP 😉

Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, prostate and what the email subject is?

Well using the “Auto Preview” feature in Outlook 2007, more about
you can now view the first couple of lines of an email – giving you all the information you need to triage and prioritise the long list of emails in your inbox.

To turn on (or off) Auto Preview in Outlook 2007:

1) Click on “View”

2) Click on “AutoPreview”

 

Simple as that!

‘till next time!
TNP 😉

Have you ever noticed whenever you reply to an email the font colour isn’t black, one Health
but a dark blue?

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

To do so:

1) Click on “Tools”

2) Click on “Options”

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. 

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

 

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

‘till next time!
TNP 😉

If you regularly use the quick search feature of Outlook 2007, prescription
you will be very familiar with the yellow highlight that is used to highlight search terms found in your inbox.

But did you know, medicine
if yellow isn’t your favourite colour, urologist
you can change the search highlight to any colour you want?

To change the search highlight color in Outlook 2007:

1) Click on “Tools”

2) Run your mouse over “Instant Search” to expand the menu

3) Click on “Search Options”

4) Look just over half way down the “Search Options” box, and click on “Change…”

5) Select your favourite colour from the “Color” box that appears

6) Click “OK”

Now you can highlight your search terms in pink, blue, red, orange or any other colour under the rainbow!

‘till next time!
TNP 😉

Are you sick of those extra long forwarded emails that seem to go on forever and ever?  Did you want to keep all that content for reference, ambulance
but make sure that what you have to add to the forward is clearly delivered?

One way to do that is to forward an email as an attachment.  Instead of a long email thread appearing below your message, it is neatly tucked away in an attachment so your message gets all the attention!

To forward an email as an attachment in Outlook 2007:

1) Select the email you want to forward

2) Click on “Actions”

3) Click on “ Forward as Attachment”

4) Compose your message, and hit Send

‘till next time!
TNP 😉

Does your Junk Mail folder in Outlook 2007 seem to continually build up with… well… junk mail?  If you are confident that no important mail ever ends up in your junk mail folder, epilepsy
you can set Outlook to automatically delete junk mail instead.

To automatically delete junk mail in Outlook 2007:

1) Click on “Tools”

2) Click on “Options”

3) Make sure you are on the “Preferences” tab”

4) In the “E-mail” section, click on the “Junk E-mail…” button

5) On the “Options” tab, look half way down for a checkbox that says “Permanently delete suspected junk e-mail instead of moving it to the Junk E-mail folder”.  Check that check box.

To stop the automatic deletion of junk mail, repeat the process, and just uncheck the checkbox in step 5

‘till next time!
TNP 😉

You know how that box always pops up whenever you have a reminder in Outlook 2007?  Well if you accidentally close it, site and want to review all the reminders you currently have, obesity
there is a quick way to make the reminders window appear again.

1) Click on “View”

2) Click on “Reminders Window”

 

Easy as that!

‘till next time!
TNP 😉

Do you want a great looking presentation, stuff
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?

Well the simple, Breast
and great looking option is to use a Slide Background.  A slide background is a simple gradient that will turn any standard barebones deck into one that looks very professional.

To add a simple background to your PowerPoint 2007 presentation:

1) Click on the “Design” tab of the ribbon

2) Look for the “Background” group – on the right hand side of the ribbon

3) Click on “Background Styles”

4) Select your preferred background

 

You will notice that not all the colours of the rainbow are available.  Background styles are linked to the current colour palette that you have selected in the document.  If you play around with the colors by clicking on the “Colors” button whilst you are still on the “Design” tab of the ribbon, you will notice the background colour change to match the new palette.

‘till next time!
TNP 😉

Do you want to do some hard core data manipulation in your PowerPoint presentation?

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

To insert an Excel table in PowerPoint 2007, no rx PowerPoint 2010 or PowerPoint 2013:

1) Make sure you are on the slide you want to include the table in

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

 

‘till next time!
TNP 😉

Do you want to copy one, this
two, prostate three or more slides and reuse them in your PowerPoint 2007 slide deck?

There are two ways you can go about it – the first is plain old copy and paste.  The other is to use the “Duplicate Slide” feature.

To duplicate slides in PowerPoint 2007:

1) Select the slide or slides you want to duplicate

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

3) Look for the “Slides” group

4) Click on the little arrow underneath “New Slide”

5) Click on “Duplicate Selected Slides”

 

‘till next time!
TNP 😉

Do you want to create a slide that is Portrait, symptoms
instead of the default Landscape slide orientation?

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, discount
just repeat the process above, but instead of clicking “Portrait” at step 4, click on “Landscape”.

 

‘till next time!
TNP 😉

Don’t you hate it when you accidently click on a text box on your slide and move it?  Before you know it, rx
your heading one one slide, or the body text on another is completely out of whack with the rest of your presentation.

The good news is that there is a way to reset the slide back to normal.  Funnily enough, it is called “Reset”.  The best of this feature is, that it only resets the layout of the slide – your text will remain intact!

To reset a slide in PowerPoint 2007:

1) Select the slide you want to reset

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

3) Look for the “Slides” group, close to the left hand side of the ribbon

4) Click on the “Reset” button – the button that looks like a slide with a blue arrow pointing to the left

 

‘till next time!
TNP 😉

Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?

To do that, sale you need to “Freeze” the top row of your sheet.

To Freeze the top row in Excel 2007, Excel 2010 or Excel 2013:

1) Click on the “View” tab of the ribbon

2) Look for the “Window” group

3) Click on “Freeze Panes”

4) Click on “Freeze Top Row”

 

To unfreeze the top row, just repeat the process above, but instead of clicking “Freeze Top Row” in step 4), just click on “Unfreeze Panes”

‘till next time!
TNP 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from highest to lowest, urticaria
or biggest to smallest?

To sort from high to low in Excel 2007, Sildenafil
Excel 2010 or Excel 2013
:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon

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.

 

‘till next time!
TNP 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from lowest to highest, rx or smallest to biggest?

To sort from low to high in Excel 2007, Excel 2010 or Excel 2013:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon

3) Look for the “Sort & Filter” group

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

 

‘till next time!
TNP 😉
Do you regularly resize the width of your columns and cells in Excel 2007?  Maybe you make them bigger?  Maybe you make them smaller.  Either way, information pills
there is a quick method to change the width of all the columns (and therefore cells) in your spreadsheet.

To change the default width in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Cells” group

3) Click on “Format”

4) Click on “Default Width…”

5) in the “Standard Width” box that appears, type in the desired width of your columns

6) Click “OK”

 

‘till next time!
TNP 😉

Merge (but don’t center) in Excel

So if you have been reading The New Paperclip for a while, surgeon you will know that the guy behind The New Paperclip is Paul Woods. Recently he delivered two presentations at two separate events – Microsoft’s TechEd Australia Conference, prescription and the community driven OfficeDevCon09. Here are the two presentations available on Slideshare…

web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
View more presentations from Paul Woods.
View more presentations from Paul Woods.

I hope you enjoy!

’till next time!
TNP 😉

Oh My!  Hasn’t Christmas snuck up on us this year!  Just over two weeks until the big day, prosthetic
I thought I might share with you some great resources over at Office Online which will help you make the most of Christmas this year!

1) Christmas Clipart!

Are you looking for some pictures or artwork to make your home made Christmas Cards look amazing!  There are over 100 pages of Christmas Clipart available at

2) Holiday Letter Tutorial!

This is a great course that will help you create a decorate a newsletter, create mailing labels for your envelopes, and create some holiday decorations.  It is about 30 minutes long – but will be a great investment of your time this Christmas to help you spread the holiday cheer!

3) Create your own Holiday Greeting Cards!

Another great resource to help you great special greeting cards to share with your family and friends – from the traditional, to the new age multimedia greeting cards with PowerPoint.

So there you have it, three great resources to help you make the most of Christmas this year!

‘till next time!
TNP 😉

With 2009 almost behind us, healthful
now is the time to start creating your own 2010 calendars using Word 2007.

It is a lot simpler than you think!  Here is how you do it.

1) Make sure you are connected to the internet

2) Click on the Office Orb in the top left hand corner of the screen (the old file menu)

3) Click on “New”

4) In the “New Document” dialog box that appears, on the left hand side you will see a long list of different template types you can find on Microsoft Office Online.  click on “Calendars”

5) Click on “2010 calendars”

6) Pick your favourite design from the dozens that appear!  Once you have selected the one you like, just click “Download” in the bottom right hand corner

7) After Word downloads the Calendar, it will appear ready for you to use, edit or print straight away.

How easy is that!  Happy New Year!

‘till next time!
TNP 😉

Did you know in Word you can automatically select all the text in a document that shares the same formatting?

For example, read
you can select all text that is Arial, click 12pt.  Very handy if you are not using styles, dosage
yet want to apply a formatting change across select blocks of text.

To select text with similar formatting in Word 2007:

1) Select some of the text you want to select

2) Make sure you are on the home tab of the ribbon

3) Look for the “Editing” group on the right hand side of the ribbon

4) Click on “Select”

5) Click on “Select Text with Similar Formatting”

‘till next time!
TNP 😉

Do you want to quickly change some text from lowercase to uppercase, online without having to retype it?

It is really simple in Word 2007!

1) Select the text you want to change to UPPERCASE

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

3) Look for the “Font” group

4) Click on the “Change Case” button – which you will find directly below where you select the font size

5) From the menu that appears, decease
click on “UPPERCASE”

Whilst you are there, check out some of the other case options you can have… like Sentence case, lowercase, Capitalize Each Word, and tOGGLE cASE.

‘till next time!
TNP 😉

You know there are just some times when you really need to make a point!  And using a double underline is a great way of making sure your readers know exactly what you mean!

Doing a normal, women’s health
single underline in Word 2007 is easy… but what about a double underline?  Well it is just as easy.

1) Select the text you want to double underline

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

3) Look for the “Font” group"

4) Click on the little down arrow beside the “Underline” button – that is the one that looks like a U with a underline below it

5) Select the underline that you would like to use.

‘till next time!
TNP 😉

Are you doing a school assignment, anorexia
or a report for work, medicine and have been told you need to use “Double Line Spacing

In Word 2007, visit this
is is fairly simple to do just that.

1) Select the text in your document that you want to apply double line spacing to

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

3) Look for the “Paragraph” group

4) Look for the button that has an up arrow and a down arrow, with lines beside them – that is the “Line Spacing” button.  Click on that, and select “2.0” – that is double line spacing.

To change back to the default spacing (1.15) or single line spacing (1.0), simply repeat the procedure above.

‘till next time!
TNP 😉

Do you want to produce a document that uses a different paper size than Letter or A4?  What about Legal, nurse
A5, A3, Tabloid, Japanese Postcard or the dozens of other paper sizes available?

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

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

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, ampoule you need to make sure that text is marked as the right language.

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”

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!
TNP 😉

Word 2007 has some fairly powerful translation features that can help you quickly understand what a word is in a different language.

By using the “Translation ScreenTip” you can see the translation of most words simply by moving the mouse over them!

Translation ScreenTip works for the following languages:

  • Arabic (Saudi Arabia)
  • English (United States)
  • French (France)
  • Spanish (Spain, here International Sort)

To turn on Translation ScreenTip:

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

2) Look for the “Proofing” group

3) Click on “Translation ScreenTip”

4) Select the language you want to see the translation for, meningitis
or click on “Turn Off Translation ScreenTip” to turn the translation off.

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, diabetes and Pregnancy
or click on “Define New Bullet”

If you are defining a new bullet, store
you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, story
or click on “Define New Bullet”

If you are defining a new bullet, you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Just like a header or footer in Word 2007, capsule
you can quickly add a header or footer to a workbook in Excel 2007.  You can add the date, time, filename or any other information you would like to make available to readers of your spreadsheet.

To create a header or footer in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Text” group – it will be on the right hand side of the ribbon

3) Click on “Header & Footer”

You will see a new tab appear on the ribbon called “Header & Footer Tools – Design”.  Using the buttons on this tab of the ribbon, you can quickly add:

  • Page Number;
  • Number of Pages;
  • Current Date;
  • Current Time;
  • File Path;
  • File Name;
  • Sheet Name; or a
  • Picture

To the header or footer of your document.  To switch from the header to the footer, simply click on “Go to Footer” which you will find in the “Navigation” group about half way along the ribbon.

‘till next time!
TNP 😉
Do you want to stop people messing with your data, site formulas, hospital
formatting, or all of the above in Excel 2007?  Well did you know you very quickly protect your spreadsheet from those rogue operators!

Here is how you do it in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are currently looking at the sheet you want to protect

2) Click on the “Review” tab in the ribbon”

3) Look for the “Changes” group”

4) Click on “Protect Sheet”

A little “Protect Sheet” dialog box will appear that will give you a number of options, so you can be very granular in how much control you want people to have over the sheet.

For example, you can allow users to select cells, but not format them.  You can allow people to insert rows, but not insert columns.  And best of all you can add a password to the sheet to ensure only you can make any changes to what can and can’t be modified.

Now, you are really in control!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells directly impact on the calculated value of a cell in Excel 2007.

By using the “Trace Precedents” feature, buy cialis
you can very quickly understand exactly which cells influence the output of a cell.  The best part of this feature is, nurse
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.

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

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!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007, search
Excel 2010 or Excel 2013.

By using the “Trace Dependents” feature, you can very quickly understand exactly the influence a cell has in your spreadsheet.  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.

To turn on Trace Dependents:

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

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

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

4) Click on “Trace Dependents”

Now you will see arrows pointing you in the right direction!

‘till next time!
TNP 😉

Did you start creating a presentation in PowerPoint 2007, troche only to realise after you perfected 67 different slides that you really should have used Arial instead of Verdana?

Well there is a very quick way to replace one font with another in PowerPoint 2007.  Here is how:

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

2) Look for the “Editing” group – which you will find on the right hand side of the ribbon

3) Click on the little arrow beside “Replace”

4) Click on “Replace Fonts…”

From the box that appears, simply select the font you want to replace, with the new font, and click “Replace”

‘till next time!
TNP 😉

Have you ever built an awesome slide with lots of different objects?  Well then I am sure you will understand how frustrating it can be when you need to select an object that is behind 3 or 4 other ones!

Did you know there is a great tool you can use called the “Selection Pane”, recipe that will help you select those pesky, online
hard to get to objects?

Selection Pane simply lists all the objects that are on a slide, sovaldi sale in a simple to use task pane to the right hand side of your PowerPoint 2007 screen.  Using Selection pan you can quickly select any object, not matter how far to the back of the slide it is.

To turn on the selection pane:

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

2) Look for the “Editing” Group – you will find it on the far right hand side of the ribbon

3) Click on the little arrow beside the “Select” button

4) Click on “Selection Pane…”

 

‘till next time!
TNP 😉

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

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

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.

‘till next time!
TNP 😉

Are you sick of clicking your mouse, health hitting a key, mind or pressing next on your wireless presenter?

Well in PowerPoint 2007, no rx you can set up your presentation so that each slide automatically advances after so many seconds.

To make a slide automatically advance after a certain amount of time:

1) Make sure you are looking at the slide you want to apply the timing to

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

3) Look for the “Advance Slide” section at the far right hand side of the ribbon

4) Check the “Automatically After:” box, and then input the number of minutes and seconds you would like the slide to be visible before advancing to the next.

If you are unhappy with automatically advancing slides, don’t worry – you can still use the mouse click to move to the next one.  And if you really hate it, you can simply uncheck the “Automatically After:” check box to stop the timed slide advance from occurring.

‘till next time!
TNP 😉

Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, prostate and what the email subject is?

Well using the “Auto Preview” feature in Outlook 2007, more about
you can now view the first couple of lines of an email – giving you all the information you need to triage and prioritise the long list of emails in your inbox.

To turn on (or off) Auto Preview in Outlook 2007:

1) Click on “View”

2) Click on “AutoPreview”

 

Simple as that!

‘till next time!
TNP 😉

Have you ever noticed whenever you reply to an email the font colour isn’t black, one Health
but a dark blue?

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

To do so:

1) Click on “Tools”

2) Click on “Options”

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. 

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

 

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

‘till next time!
TNP 😉

If you regularly use the quick search feature of Outlook 2007, prescription
you will be very familiar with the yellow highlight that is used to highlight search terms found in your inbox.

But did you know, medicine
if yellow isn’t your favourite colour, urologist
you can change the search highlight to any colour you want?

To change the search highlight color in Outlook 2007:

1) Click on “Tools”

2) Run your mouse over “Instant Search” to expand the menu

3) Click on “Search Options”

4) Look just over half way down the “Search Options” box, and click on “Change…”

5) Select your favourite colour from the “Color” box that appears

6) Click “OK”

Now you can highlight your search terms in pink, blue, red, orange or any other colour under the rainbow!

‘till next time!
TNP 😉

Are you sick of those extra long forwarded emails that seem to go on forever and ever?  Did you want to keep all that content for reference, ambulance
but make sure that what you have to add to the forward is clearly delivered?

One way to do that is to forward an email as an attachment.  Instead of a long email thread appearing below your message, it is neatly tucked away in an attachment so your message gets all the attention!

To forward an email as an attachment in Outlook 2007:

1) Select the email you want to forward

2) Click on “Actions”

3) Click on “ Forward as Attachment”

4) Compose your message, and hit Send

‘till next time!
TNP 😉

Does your Junk Mail folder in Outlook 2007 seem to continually build up with… well… junk mail?  If you are confident that no important mail ever ends up in your junk mail folder, epilepsy
you can set Outlook to automatically delete junk mail instead.

To automatically delete junk mail in Outlook 2007:

1) Click on “Tools”

2) Click on “Options”

3) Make sure you are on the “Preferences” tab”

4) In the “E-mail” section, click on the “Junk E-mail…” button

5) On the “Options” tab, look half way down for a checkbox that says “Permanently delete suspected junk e-mail instead of moving it to the Junk E-mail folder”.  Check that check box.

To stop the automatic deletion of junk mail, repeat the process, and just uncheck the checkbox in step 5

‘till next time!
TNP 😉

You know how that box always pops up whenever you have a reminder in Outlook 2007?  Well if you accidentally close it, site and want to review all the reminders you currently have, obesity
there is a quick way to make the reminders window appear again.

1) Click on “View”

2) Click on “Reminders Window”

 

Easy as that!

‘till next time!
TNP 😉

Do you want a great looking presentation, stuff
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?

Well the simple, Breast
and great looking option is to use a Slide Background.  A slide background is a simple gradient that will turn any standard barebones deck into one that looks very professional.

To add a simple background to your PowerPoint 2007 presentation:

1) Click on the “Design” tab of the ribbon

2) Look for the “Background” group – on the right hand side of the ribbon

3) Click on “Background Styles”

4) Select your preferred background

 

You will notice that not all the colours of the rainbow are available.  Background styles are linked to the current colour palette that you have selected in the document.  If you play around with the colors by clicking on the “Colors” button whilst you are still on the “Design” tab of the ribbon, you will notice the background colour change to match the new palette.

‘till next time!
TNP 😉

Do you want to do some hard core data manipulation in your PowerPoint presentation?

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

To insert an Excel table in PowerPoint 2007, no rx PowerPoint 2010 or PowerPoint 2013:

1) Make sure you are on the slide you want to include the table in

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

 

‘till next time!
TNP 😉

Do you want to copy one, this
two, prostate three or more slides and reuse them in your PowerPoint 2007 slide deck?

There are two ways you can go about it – the first is plain old copy and paste.  The other is to use the “Duplicate Slide” feature.

To duplicate slides in PowerPoint 2007:

1) Select the slide or slides you want to duplicate

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

3) Look for the “Slides” group

4) Click on the little arrow underneath “New Slide”

5) Click on “Duplicate Selected Slides”

 

‘till next time!
TNP 😉

Do you want to create a slide that is Portrait, symptoms
instead of the default Landscape slide orientation?

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, discount
just repeat the process above, but instead of clicking “Portrait” at step 4, click on “Landscape”.

 

‘till next time!
TNP 😉

Don’t you hate it when you accidently click on a text box on your slide and move it?  Before you know it, rx
your heading one one slide, or the body text on another is completely out of whack with the rest of your presentation.

The good news is that there is a way to reset the slide back to normal.  Funnily enough, it is called “Reset”.  The best of this feature is, that it only resets the layout of the slide – your text will remain intact!

To reset a slide in PowerPoint 2007:

1) Select the slide you want to reset

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

3) Look for the “Slides” group, close to the left hand side of the ribbon

4) Click on the “Reset” button – the button that looks like a slide with a blue arrow pointing to the left

 

‘till next time!
TNP 😉

Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?

To do that, sale you need to “Freeze” the top row of your sheet.

To Freeze the top row in Excel 2007, Excel 2010 or Excel 2013:

1) Click on the “View” tab of the ribbon

2) Look for the “Window” group

3) Click on “Freeze Panes”

4) Click on “Freeze Top Row”

 

To unfreeze the top row, just repeat the process above, but instead of clicking “Freeze Top Row” in step 4), just click on “Unfreeze Panes”

‘till next time!
TNP 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from highest to lowest, urticaria
or biggest to smallest?

To sort from high to low in Excel 2007, Sildenafil
Excel 2010 or Excel 2013
:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon

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.

 

‘till next time!
TNP 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from lowest to highest, rx or smallest to biggest?

To sort from low to high in Excel 2007, Excel 2010 or Excel 2013:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon

3) Look for the “Sort & Filter” group

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

 

‘till next time!
TNP 😉
Do you regularly resize the width of your columns and cells in Excel 2007?  Maybe you make them bigger?  Maybe you make them smaller.  Either way, information pills
there is a quick method to change the width of all the columns (and therefore cells) in your spreadsheet.

To change the default width in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Cells” group

3) Click on “Format”

4) Click on “Default Width…”

5) in the “Standard Width” box that appears, type in the desired width of your columns

6) Click “OK”

 

‘till next time!
TNP 😉
Do you regularly resize the width of your columns and cells in Excel 2007?  Maybe you make them bigger?  Maybe you make them smaller.  Either way, allergist
there is a quick method to change the width of all the columns (and therefore cells) in your spreadsheet.

To change the default width in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Cells” group

3) Click on “Format”

4) Click on “Default Width…”

5) in the “Standard Width” box that appears, type in the desired width of your columns

6) Click “OK”

 

‘till next time!
TNP 😉
You might already know about a great feature in Excel 2007 called “Merge and Center”.  Basically it allows you to create a cell that spans across multiple columns – great for headings for example.

But sometimes you want to merge the cells – but not centre the text.  That is where “Merge Across” comes in handy.  “Merge Across” does exactly the same as “Merge and Center”, discount except it keeps the text left justified!

How good is that!  No more having to change the paragraph alignment!!!

To merge across a number of cells in Excel 2007, Excel 2010 or Excel 2013:

1) Select the cells you want to merge

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

3) Look for the “Alignment” group

4) Click on the small arrow beside “Merge & Center”

5) Click on “Merge Across”

 

To unmerge, all you need to do is select the cell, and click on the “Merge & Center” button.

 

‘till next time!
TNP 😉

Add commas to your numbers in Excel

So if you have been reading The New Paperclip for a while, surgeon you will know that the guy behind The New Paperclip is Paul Woods. Recently he delivered two presentations at two separate events – Microsoft’s TechEd Australia Conference, prescription and the community driven OfficeDevCon09. Here are the two presentations available on Slideshare…

web Arial,Sans-serif;display:block;margin:12px 0 3px 0;text-decoration:underline;” title=”Office Dev Con 09 After Deployment” href=”http://www.slideshare.net/pwoods/office-dev-con-09-after-deployment”>Office Dev Con 09 After Deployment
View more presentations from Paul Woods.
View more presentations from Paul Woods.

I hope you enjoy!

’till next time!
TNP 😉

Oh My!  Hasn’t Christmas snuck up on us this year!  Just over two weeks until the big day, prosthetic
I thought I might share with you some great resources over at Office Online which will help you make the most of Christmas this year!

1) Christmas Clipart!

Are you looking for some pictures or artwork to make your home made Christmas Cards look amazing!  There are over 100 pages of Christmas Clipart available at

2) Holiday Letter Tutorial!

This is a great course that will help you create a decorate a newsletter, create mailing labels for your envelopes, and create some holiday decorations.  It is about 30 minutes long – but will be a great investment of your time this Christmas to help you spread the holiday cheer!

3) Create your own Holiday Greeting Cards!

Another great resource to help you great special greeting cards to share with your family and friends – from the traditional, to the new age multimedia greeting cards with PowerPoint.

So there you have it, three great resources to help you make the most of Christmas this year!

‘till next time!
TNP 😉

With 2009 almost behind us, healthful
now is the time to start creating your own 2010 calendars using Word 2007.

It is a lot simpler than you think!  Here is how you do it.

1) Make sure you are connected to the internet

2) Click on the Office Orb in the top left hand corner of the screen (the old file menu)

3) Click on “New”

4) In the “New Document” dialog box that appears, on the left hand side you will see a long list of different template types you can find on Microsoft Office Online.  click on “Calendars”

5) Click on “2010 calendars”

6) Pick your favourite design from the dozens that appear!  Once you have selected the one you like, just click “Download” in the bottom right hand corner

7) After Word downloads the Calendar, it will appear ready for you to use, edit or print straight away.

How easy is that!  Happy New Year!

‘till next time!
TNP 😉

Did you know in Word you can automatically select all the text in a document that shares the same formatting?

For example, read
you can select all text that is Arial, click 12pt.  Very handy if you are not using styles, dosage
yet want to apply a formatting change across select blocks of text.

To select text with similar formatting in Word 2007:

1) Select some of the text you want to select

2) Make sure you are on the home tab of the ribbon

3) Look for the “Editing” group on the right hand side of the ribbon

4) Click on “Select”

5) Click on “Select Text with Similar Formatting”

‘till next time!
TNP 😉

Do you want to quickly change some text from lowercase to uppercase, online without having to retype it?

It is really simple in Word 2007!

1) Select the text you want to change to UPPERCASE

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

3) Look for the “Font” group

4) Click on the “Change Case” button – which you will find directly below where you select the font size

5) From the menu that appears, decease
click on “UPPERCASE”

Whilst you are there, check out some of the other case options you can have… like Sentence case, lowercase, Capitalize Each Word, and tOGGLE cASE.

‘till next time!
TNP 😉

You know there are just some times when you really need to make a point!  And using a double underline is a great way of making sure your readers know exactly what you mean!

Doing a normal, women’s health
single underline in Word 2007 is easy… but what about a double underline?  Well it is just as easy.

1) Select the text you want to double underline

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

3) Look for the “Font” group"

4) Click on the little down arrow beside the “Underline” button – that is the one that looks like a U with a underline below it

5) Select the underline that you would like to use.

‘till next time!
TNP 😉

Are you doing a school assignment, anorexia
or a report for work, medicine and have been told you need to use “Double Line Spacing

In Word 2007, visit this
is is fairly simple to do just that.

1) Select the text in your document that you want to apply double line spacing to

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

3) Look for the “Paragraph” group

4) Look for the button that has an up arrow and a down arrow, with lines beside them – that is the “Line Spacing” button.  Click on that, and select “2.0” – that is double line spacing.

To change back to the default spacing (1.15) or single line spacing (1.0), simply repeat the procedure above.

‘till next time!
TNP 😉

Do you want to produce a document that uses a different paper size than Letter or A4?  What about Legal, nurse
A5, A3, Tabloid, Japanese Postcard or the dozens of other paper sizes available?

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

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

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, ampoule you need to make sure that text is marked as the right language.

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”

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!
TNP 😉

Word 2007 has some fairly powerful translation features that can help you quickly understand what a word is in a different language.

By using the “Translation ScreenTip” you can see the translation of most words simply by moving the mouse over them!

Translation ScreenTip works for the following languages:

  • Arabic (Saudi Arabia)
  • English (United States)
  • French (France)
  • Spanish (Spain, here International Sort)

To turn on Translation ScreenTip:

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

2) Look for the “Proofing” group

3) Click on “Translation ScreenTip”

4) Select the language you want to see the translation for, meningitis
or click on “Turn Off Translation ScreenTip” to turn the translation off.

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, diabetes and Pregnancy
or click on “Define New Bullet”

If you are defining a new bullet, store
you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Are you bored of bullets that just look like… well… bullets?  Did you know you can change the look of the bullets in your bulleted lists in Word 2007?

To do so…

1) Make sure you are on the “Home” tab of the Ribbon”

2) Look for the “Paragraph” group

3) Click on the little arrow beside the “Bullet” button

4) Select a bullet design from the “Bullet Library”, story
or click on “Define New Bullet”

If you are defining a new bullet, you will see that you can select any symbol or picture that you want!  You could literally use a mug shot of yourself as a bullet if you really wanted to!

That could be too much fun!

‘till next time!
TNP 😉

Just like a header or footer in Word 2007, capsule
you can quickly add a header or footer to a workbook in Excel 2007.  You can add the date, time, filename or any other information you would like to make available to readers of your spreadsheet.

To create a header or footer in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Text” group – it will be on the right hand side of the ribbon

3) Click on “Header & Footer”

You will see a new tab appear on the ribbon called “Header & Footer Tools – Design”.  Using the buttons on this tab of the ribbon, you can quickly add:

  • Page Number;
  • Number of Pages;
  • Current Date;
  • Current Time;
  • File Path;
  • File Name;
  • Sheet Name; or a
  • Picture

To the header or footer of your document.  To switch from the header to the footer, simply click on “Go to Footer” which you will find in the “Navigation” group about half way along the ribbon.

‘till next time!
TNP 😉
Do you want to stop people messing with your data, site formulas, hospital
formatting, or all of the above in Excel 2007?  Well did you know you very quickly protect your spreadsheet from those rogue operators!

Here is how you do it in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are currently looking at the sheet you want to protect

2) Click on the “Review” tab in the ribbon”

3) Look for the “Changes” group”

4) Click on “Protect Sheet”

A little “Protect Sheet” dialog box will appear that will give you a number of options, so you can be very granular in how much control you want people to have over the sheet.

For example, you can allow users to select cells, but not format them.  You can allow people to insert rows, but not insert columns.  And best of all you can add a password to the sheet to ensure only you can make any changes to what can and can’t be modified.

Now, you are really in control!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells directly impact on the calculated value of a cell in Excel 2007.

By using the “Trace Precedents” feature, buy cialis
you can very quickly understand exactly which cells influence the output of a cell.  The best part of this feature is, nurse
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.

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

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!

‘till next time!
TNP 😉

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007, search
Excel 2010 or Excel 2013.

By using the “Trace Dependents” feature, you can very quickly understand exactly the influence a cell has in your spreadsheet.  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.

To turn on Trace Dependents:

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

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

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

4) Click on “Trace Dependents”

Now you will see arrows pointing you in the right direction!

‘till next time!
TNP 😉

Did you start creating a presentation in PowerPoint 2007, troche only to realise after you perfected 67 different slides that you really should have used Arial instead of Verdana?

Well there is a very quick way to replace one font with another in PowerPoint 2007.  Here is how:

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

2) Look for the “Editing” group – which you will find on the right hand side of the ribbon

3) Click on the little arrow beside “Replace”

4) Click on “Replace Fonts…”

From the box that appears, simply select the font you want to replace, with the new font, and click “Replace”

‘till next time!
TNP 😉

Have you ever built an awesome slide with lots of different objects?  Well then I am sure you will understand how frustrating it can be when you need to select an object that is behind 3 or 4 other ones!

Did you know there is a great tool you can use called the “Selection Pane”, recipe that will help you select those pesky, online
hard to get to objects?

Selection Pane simply lists all the objects that are on a slide, sovaldi sale in a simple to use task pane to the right hand side of your PowerPoint 2007 screen.  Using Selection pan you can quickly select any object, not matter how far to the back of the slide it is.

To turn on the selection pane:

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

2) Look for the “Editing” Group – you will find it on the far right hand side of the ribbon

3) Click on the little arrow beside the “Select” button

4) Click on “Selection Pane…”

 

‘till next time!
TNP 😉

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

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

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.

‘till next time!
TNP 😉

Are you sick of clicking your mouse, health hitting a key, mind or pressing next on your wireless presenter?

Well in PowerPoint 2007, no rx you can set up your presentation so that each slide automatically advances after so many seconds.

To make a slide automatically advance after a certain amount of time:

1) Make sure you are looking at the slide you want to apply the timing to

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

3) Look for the “Advance Slide” section at the far right hand side of the ribbon

4) Check the “Automatically After:” box, and then input the number of minutes and seconds you would like the slide to be visible before advancing to the next.

If you are unhappy with automatically advancing slides, don’t worry – you can still use the mouse click to move to the next one.  And if you really hate it, you can simply uncheck the “Automatically After:” check box to stop the timed slide advance from occurring.

‘till next time!
TNP 😉

Do you find it hard to prioritise emails when all you are looking at is a long list of who the email is from, prostate and what the email subject is?

Well using the “Auto Preview” feature in Outlook 2007, more about
you can now view the first couple of lines of an email – giving you all the information you need to triage and prioritise the long list of emails in your inbox.

To turn on (or off) Auto Preview in Outlook 2007:

1) Click on “View”

2) Click on “AutoPreview”

 

Simple as that!

‘till next time!
TNP 😉

Have you ever noticed whenever you reply to an email the font colour isn’t black, one Health
but a dark blue?

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

To do so:

1) Click on “Tools”

2) Click on “Options”

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. 

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

 

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

‘till next time!
TNP 😉

If you regularly use the quick search feature of Outlook 2007, prescription
you will be very familiar with the yellow highlight that is used to highlight search terms found in your inbox.

But did you know, medicine
if yellow isn’t your favourite colour, urologist
you can change the search highlight to any colour you want?

To change the search highlight color in Outlook 2007:

1) Click on “Tools”

2) Run your mouse over “Instant Search” to expand the menu

3) Click on “Search Options”

4) Look just over half way down the “Search Options” box, and click on “Change…”

5) Select your favourite colour from the “Color” box that appears

6) Click “OK”

Now you can highlight your search terms in pink, blue, red, orange or any other colour under the rainbow!

‘till next time!
TNP 😉

Are you sick of those extra long forwarded emails that seem to go on forever and ever?  Did you want to keep all that content for reference, ambulance
but make sure that what you have to add to the forward is clearly delivered?

One way to do that is to forward an email as an attachment.  Instead of a long email thread appearing below your message, it is neatly tucked away in an attachment so your message gets all the attention!

To forward an email as an attachment in Outlook 2007:

1) Select the email you want to forward

2) Click on “Actions”

3) Click on “ Forward as Attachment”

4) Compose your message, and hit Send

‘till next time!
TNP 😉

Does your Junk Mail folder in Outlook 2007 seem to continually build up with… well… junk mail?  If you are confident that no important mail ever ends up in your junk mail folder, epilepsy
you can set Outlook to automatically delete junk mail instead.

To automatically delete junk mail in Outlook 2007:

1) Click on “Tools”

2) Click on “Options”

3) Make sure you are on the “Preferences” tab”

4) In the “E-mail” section, click on the “Junk E-mail…” button

5) On the “Options” tab, look half way down for a checkbox that says “Permanently delete suspected junk e-mail instead of moving it to the Junk E-mail folder”.  Check that check box.

To stop the automatic deletion of junk mail, repeat the process, and just uncheck the checkbox in step 5

‘till next time!
TNP 😉

You know how that box always pops up whenever you have a reminder in Outlook 2007?  Well if you accidentally close it, site and want to review all the reminders you currently have, obesity
there is a quick way to make the reminders window appear again.

1) Click on “View”

2) Click on “Reminders Window”

 

Easy as that!

‘till next time!
TNP 😉

Do you want a great looking presentation, stuff
but without all the design elements you find in the themes that come out of the box in PowerPoint 2007?

Well the simple, Breast
and great looking option is to use a Slide Background.  A slide background is a simple gradient that will turn any standard barebones deck into one that looks very professional.

To add a simple background to your PowerPoint 2007 presentation:

1) Click on the “Design” tab of the ribbon

2) Look for the “Background” group – on the right hand side of the ribbon

3) Click on “Background Styles”

4) Select your preferred background

 

You will notice that not all the colours of the rainbow are available.  Background styles are linked to the current colour palette that you have selected in the document.  If you play around with the colors by clicking on the “Colors” button whilst you are still on the “Design” tab of the ribbon, you will notice the background colour change to match the new palette.

‘till next time!
TNP 😉

Do you want to do some hard core data manipulation in your PowerPoint presentation?

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

To insert an Excel table in PowerPoint 2007, no rx PowerPoint 2010 or PowerPoint 2013:

1) Make sure you are on the slide you want to include the table in

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

 

‘till next time!
TNP 😉

Do you want to copy one, this
two, prostate three or more slides and reuse them in your PowerPoint 2007 slide deck?

There are two ways you can go about it – the first is plain old copy and paste.  The other is to use the “Duplicate Slide” feature.

To duplicate slides in PowerPoint 2007:

1) Select the slide or slides you want to duplicate

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

3) Look for the “Slides” group

4) Click on the little arrow underneath “New Slide”

5) Click on “Duplicate Selected Slides”

 

‘till next time!
TNP 😉

Do you want to create a slide that is Portrait, symptoms
instead of the default Landscape slide orientation?

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, discount
just repeat the process above, but instead of clicking “Portrait” at step 4, click on “Landscape”.

 

‘till next time!
TNP 😉

Don’t you hate it when you accidently click on a text box on your slide and move it?  Before you know it, rx
your heading one one slide, or the body text on another is completely out of whack with the rest of your presentation.

The good news is that there is a way to reset the slide back to normal.  Funnily enough, it is called “Reset”.  The best of this feature is, that it only resets the layout of the slide – your text will remain intact!

To reset a slide in PowerPoint 2007:

1) Select the slide you want to reset

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

3) Look for the “Slides” group, close to the left hand side of the ribbon

4) Click on the “Reset” button – the button that looks like a slide with a blue arrow pointing to the left

 

‘till next time!
TNP 😉

Do you want to be able to always see the headings of your columns whilst you scroll through your Excel 2007 spreadsheet?

To do that, sale you need to “Freeze” the top row of your sheet.

To Freeze the top row in Excel 2007, Excel 2010 or Excel 2013:

1) Click on the “View” tab of the ribbon

2) Look for the “Window” group

3) Click on “Freeze Panes”

4) Click on “Freeze Top Row”

 

To unfreeze the top row, just repeat the process above, but instead of clicking “Freeze Top Row” in step 4), just click on “Unfreeze Panes”

‘till next time!
TNP 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from highest to lowest, urticaria
or biggest to smallest?

To sort from high to low in Excel 2007, Sildenafil
Excel 2010 or Excel 2013
:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon

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.

 

‘till next time!
TNP 😉
Do you have a column full of numbers in Excel 2007 that you would like to sort from lowest to highest, rx or smallest to biggest?

To sort from low to high in Excel 2007, Excel 2010 or Excel 2013:

1) Select the cells you want to sort

2) Click on the “Data” tab of the Ribbon

3) Look for the “Sort & Filter” group

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

 

‘till next time!
TNP 😉
Do you regularly resize the width of your columns and cells in Excel 2007?  Maybe you make them bigger?  Maybe you make them smaller.  Either way, information pills
there is a quick method to change the width of all the columns (and therefore cells) in your spreadsheet.

To change the default width in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Cells” group

3) Click on “Format”

4) Click on “Default Width…”

5) in the “Standard Width” box that appears, type in the desired width of your columns

6) Click “OK”

 

‘till next time!
TNP 😉
Do you regularly resize the width of your columns and cells in Excel 2007?  Maybe you make them bigger?  Maybe you make them smaller.  Either way, allergist
there is a quick method to change the width of all the columns (and therefore cells) in your spreadsheet.

To change the default width in Excel 2007, Excel 2010 or Excel 2013:

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

2) Look for the “Cells” group

3) Click on “Format”

4) Click on “Default Width…”

5) in the “Standard Width” box that appears, type in the desired width of your columns

6) Click “OK”

 

‘till next time!
TNP 😉
You might already know about a great feature in Excel 2007 called “Merge and Center”.  Basically it allows you to create a cell that spans across multiple columns – great for headings for example.

But sometimes you want to merge the cells – but not centre the text.  That is where “Merge Across” comes in handy.  “Merge Across” does exactly the same as “Merge and Center”, discount except it keeps the text left justified!

How good is that!  No more having to change the paragraph alignment!!!

To merge across a number of cells in Excel 2007, Excel 2010 or Excel 2013:

1) Select the cells you want to merge

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

3) Look for the “Alignment” group

4) Click on the small arrow beside “Merge & Center”

5) Click on “Merge Across”

 

To unmerge, all you need to do is select the cell, and click on the “Merge & Center” button.

 

‘till next time!
TNP 😉
You might already know about a great feature in Excel 2007 called “Merge and Center”.  Basically it allows you to create a cell that spans across multiple columns – great for headings for example.

But sometimes you want to merge the cells – but not centre the text.  That is where “Merge Across” comes in handy.  “Merge Across” does exactly the same as “Merge and Center”, prosthesis
except it keeps the text left justified!

How good is that!  No more having to change the paragraph alignment!!!

To merge across a number of cells in Excel 2007, Excel 2010 or Excel 2013:

1) Select the cells you want to merge

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

3) Look for the “Alignment” group

4) Click on the small arrow beside “Merge & Center”

5) Click on “Merge Across”

 

To unmerge, all you need to do is select the cell, and click on the “Merge & Center” button.

 

‘till next time!
TNP 😉
Do you prefer to use commas when you write long numbers?  Those commas are called “Thousands Separators”, anaemia
and you can quickly add them to the cells in your Excel 2007, buy
Excel 2010 or Excel 2013 spreadsheet.

To turn on the thousands separator:

1) Select the cells you want to apply the commas to

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

3) Look for the “Number” group – in the middle of the ribbon

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

 

‘till next time!
TNP 😉