Christian Gude over at the ITExperience.NET blog has put together a great list of five tips you can use to maximise your performance whilst using Microsoft Word 2007:
1) Add frequently used command icons to your Quick Launch Toolbar
2) Adjust the spacing after a line
3) Customise the shortcut keys
4) Increase AutoRecover interval
5) Disable AutoCorrect options
To learn more about how to increase your performance with Word 2007 â check out his post here.
âtill next time!
TNP đ
So you have a really big spreadsheet⌠but you only want to print a little bit of it to show a colleague? You could print the whole worksheet and just take the page that you want and throw the rest of the paper out recycle the rest of the paper, unhealthy or there is a much more environmentally friendly, cure
and more productive way of doing it!
How to set the Print Area in Excel 2007
This is really easy. To start, simply select the data you want to print. Then:
1) In the Ribbon, go to the âPage Layoutâ tab
2) Look for the âPage Setupâ group
3) Click on âPrint Areaâ
4) Click on âSet Print Areaâ
Now when you go and print your worksheet, Excel 2007 will only print the section you just selected. Very cool! If you ever want to print the whole worksheet again, you need to clear the Print Area. Follow the process above, but at the last step, instead of clicking âSet Print Areaâ, click âClear Print Areaâ
âtill next time!
TNP đ
Are you looking to get the most out of PowerPoint? Do you know where to start?
Imagine if you had a resource where you could quickly see what was possible in PowerPoint 2007, treat and step by step instructions on how to achieve that outcome?
Our friends over at Microsoft have commissioned the development of 157 slides that do just that⌠show you all the different things you can do in PowerPoint 2007.
These presentations are a great resource if you want to get your hands dirty with PowerPoint.
You can find them by reading this article on the Inside Office Online blog â No more Death by PowerPoint: Free downloads by a savvy pro sharpen your presentations.
Are you writing a training document and need to capture a screenshot, ambulance or a snapshot of part of your screen? Maybe you want to keep a record of an image and text you found in a document or a web page? Or maybe you just want to keep something funny you saw on the internet? Well did you know you can quickly and easily take a screen grab with OneNote 2007.
It is really easy!
1) Open up OneNote 2007
2) Look at the toolbar along the top of the window and you will find a âClipâ button. Click on that.
3) Using the Black Cross that appears on the screen, find simply click and drag the section of the screen that you want to capture.
4) Your screen clipping will now appear in OneNote!
How easy is that!
âtill next time!
TNP đ
So you have been using OneNote for a while, order
and have an appreciation for what a fantastic productivity tool it is. Well are you ready to get even more out of OneNote 2007?
Did you know that OneNote 2007 is jam packed with templates that can make your life much easier. Now I will be the first to admit that some are there just to look pretty (like all the different coloured backgrounds you can have⌠âRed Chalkâ anyone?), but there are plenty that have real business (and students, academic) value and should be checked out. For example:
Academic Templates for OneNote 2007
- Simple Lecture Notes
- Detailed Lecture Notes
- Lecture Notes and Study Questions
- Math/Science Class Notes
- History Class Notes
Business Templates for OneNote 2007
- Project Overview
- Simple Meeting Notes 1 (and 2)
- Informal Meeting Notes
- Personal Meeting Notes
- Detailed Meeting Notes
- Formal Meeting Notes
Planning Templates for OneNote 2007
- Simple To Do List
- Prioritised To Do List
- Project To Do List
So how do you get your hands on these templates? Lucky for you they are already loaded in OneNote 2007 for you. To access them, simply:
1) Click âFileâ
2) Move your mouse over âNewâ
3) Click on âPage from TemplateâŚâ
4) Look to the right and select the page template you want.
Looking for more OneNote 2007 Templates?
The fantastic thing is that you can also get more page templates for OneNote 2007 from Office Online. So if you are after a calendar, more planning, reporting or meeting templates â even address books!, you can find them all there â simply click the link on the Templates Taskbar in OneNote 2007, or visit Office Online.
âtill next time!
TNP đ
Is there a task you want to schedule in Project 2007 that will occur regularly? Well did you know you can create that task so it recurs throughout your project plan?
Here is how to do it!
1) Click âInsertâ in the Project 2007 menu
2) Click âRecurring Taskâ
3) In the âRecurring Task Informationâ window that appears, troche add all the details about your task â including the Task Name and the Recurrence Pattern you want
4) Click âOkâ
Easy!
âtill next time!
TNP đ
In this weeks edition of TheNewPaperclip.comâs Office 2007 newsletter, drug
we focused on a few articles that could help you get a big productivity boost in 2009.
Here are a few to get you thinking about how you can be that 10% better in the new year!
Create your 2009 Calendar with Word 2007
So, malady
the new year is just a few hours away⌠time to crack open the calendars your relatives gave you for Christmas right!
But what if you didnât get any?
>> read more
Organise your Inbox with Outlook 2007
Is your inbox overflowing like mine? Want to know how you can you quickly focus on what you need to action? Well here is a nifty way to do it.
In Outlook 2007, what is ed
you can organise your emails using views. What is a view you say? Basically think of it of a different way to look at all the emails you have.
>> read more
Follow up Flags and the Default Reminder in Outlook 2007
There have been dozens of comments recently on my previous post about Changing the default reminder time in Outlook 2007. The comments are not about the default reminder time for appointments⌠but rather the default reminder time for follow up flags. The concern being that it is really strange that the default is 4pm and it seems there is no easy way to change that to something more acceptable (like 8am)
>> read more
How to find any Office 2007 Command you Want!
Is there a feature of Office that you KNOW exists⌠but canât for the life of you find it?
Maybe it was an old feature you remember from Word 2003, or Excel, or PowerPoint. They didnât cover it in the course that work sent you to, you canât find it in the help file, and Google hasnât returned any results!
Panic? Not quite yet!
>> read more
Do you have an Office 2007 Productivity Tip? Email office2007tips@thenewpaperclip.com and let me know â and you could share the limelight as I will share the best in the next edition of the newsletter!
âtill next time!
TNP đ
They have been closed for a while now, hospital
but today I am re-launching The New Paperclipâs Office 2007 Forums!
What does that mean? If you have any question at all about Office 2007, whether it is Word, Excel, PowerPoint, Outlook, Access or even SharePoint Designer⌠you now have a place where you can look for answers.
I will be there frequently, and we will be able to draw on the collective knowledge of the community to get your question answered!
Here are the links to each of the forums:
So there you have it â the quick and easy way to get your Office 2007 question answered! See you on the forums!
âtill next time!
TNP đ
So are you comfortable with the basics of Office 2007, sanitary
and want to go a little deeper? Maybe you want to build your knowledge around one particular product? Maybe you just want something interesting to read!
If you are into Office 2007, viagra
you might not know it, pulmonologist
but The New Paperclip is not your only option (if you thought it was, I am very flattered though!). There are plenty of quality resources out there that you can leverage to make you far more productive using Word, PowerPoint, Excel, Outlook or the rest of the suite.
Here are a few places you should lookâŚ
Number 1: Alltopâs Top Microsoft Office News – [http://microsoft-office.alltop.com/]
This is a great resource if you want to keep your finger on the pulse of everything happening with Microsoft Office. This one page displays all the news from 30 or so of the webâs leading Microsoft Office sites, which means you can quickly get up to speed on exactly what the âblogosphereâ is thinking about when it comes to Office.
You can also read the latest AllTop Microsoft Office news simply by watching out for the AllTop section to the right of this article â it gets updated every hour!
Number 2: Inside Office Online – [http://blogs.msdn.com/inside_office_online/]
This blog is run by the folks who run Microsoftâs own Office help site â Office Online. Great to get their perspective on what new and exciting things are happening in the world of Microsoft Office.
Number 3: The blogs of all the Office teams at Microsoft
There is nothing better than getting it from the horseâs mouth right! These blogs are run by the folk who actually build the products in Office, so they are filled with interesting stories, tips, and tricks that will help you become more productive with Office 2007
There are literally hundreds of other resources out there that you could find, and the ones I have listed in this article would be a great place to start⌠well, of course after you have read all the articles on The New Paperclip!
âtill next time!
TNP đ
Has this ever happened to you?
You morning starts off great. You beat all the traffic, here
get into the office precisely at the time you are supposed to start, ailment and enjoy the best cup of coffee you have had in months.
You open up Outlook, and put that appointment in your calendar that you had thought of on the way into office.
But then something horrific happens. When you go to check your email, there is a new meeting request in there â for the exact same time you just set the appointment in your calendar. What are you to do????
âŚ
Ok⌠I might be getting a little dramatic here, but this has happened to me a couple of times over the last few months â and today thanks to my friend Alistair Speirs (Australiaâs premier Microsoft Office Client Technology Specialist â try Googling/Live Searching that now Al!), I have found a way to avoid this exact situation in the future.
There is a command line switch for Outlook 2007 which will start Outlook, force detection of all the new meeting requests that people sneakily invited you too overnight, and push them straight into your calendar before you get a chance to look at it.
The outcome being that you have a clear and accurate picture of how your time will be used today â before you start digging into your email.
And the best part is, the switch has a cool name⌠/sniff
For those that donât know how to use switches, my advice would be to visit the Microsoft Office Online page that talks about Command-line switches for Microsoft Office Outlook 2007.
And if you want to take a look at some other switches that will make you more productive â check out the original post on Alistairâs blog.
âtill next time!
TNP đ
Are you a sweetheart who wants to create their own valentines day card for someone special but donât know where to start?
Well over at Office Online, refractionist
you can get Valentineâs Day card templates for Word 2007 which will give you the inspiration you need to show your other half that you really care!
And if you really want to show that you love her/him, internist
why not put together a Valentines Day PowerPoint Deck! There are a number of Valentineâs Day PowerPoint designs you can use to knock her/him off their feet!
âtill next time lovers!
TNP đ
So⌠you have spent hours collating your data in Excel 2007. You have finally got the information where you want it â with sub-totals and all. You collapse the outline to only show the sub-totals, pharmacist
because that is all you are interested in. But when you try to copy those subtotals into another spreadsheet, it copies EVERY row, not just the sub-totals.
So how on Earth are you supposed to copy all those sub-totals in Excel 2007 without copying all the âhiddenâ rows as well?
The problem is that when you select rows using the sub-total outline view, it is selecting every row, not just those sub-totals. The way to solve this is to only select the visible cells â which means we have to use a feature of Excel called âGo To Specialâ. Here is how to do it:
1) Select all your sub-totals that you want to copy
2) On the âHomeâ tab of the Ribbon, look for the âEditingâ group â usually it is the last one, all the way over at the right hand side of the Ribbon.
3) Click on âFind & Selectâ
4) On the little menu that appears, click âGo To Specialâ
5) In the box that appears, make sure you select âVisible Cells Onlyâ in the right hand column
6) Click OK
7) Copy using the menu (or ctrl+c) and then paste your sub-totals in your new spreadsheet
You can stop pulling your hair out now!
âtill next time!
TNP đ
Are you new, public health
or have just upgraded to Word 2007? Since starting The New Paperclip over two years ago, tadalafil
there have been a few questions that come up again and again that people ask â some of which I have listed below.
- How do I change my page orientation in Word 2007 from Portrait to Landscape or vice versa?
- How do I change my line spacing in Word 2007?
- How do I undo in Word 2007?
- How do I do an email merge in Word 2007?
- How do I add page numbers in Word 2007?
- How do I print in Word 2007?
- Where did the file menu go in Word 2007?
- How can I change my page layout in Word 2007?
- How do I superscript text in Word 2007?
- How do I email a document using Word 2007?
Remember that you can have more Word 2007 help, this site
tips, tricks and tutorials delivered to your inbox simply by subscribing to the Office 2007 newsletter.
Finally⌠if you have any more Word 2007 questions, check out The Ultimate Guide to Word 2007
âtill next time!
TNP đ
Hi everyone!
I am very proud to announce that today The New Paperclip was listed on Alltop.
Alltop is best described as an online magazine rack that helps you keep up to date with all the top news from around the world. The New Paperclip is now featured in the Top Microsoft Office News section!
It wouldnât have happened without all your support, pilule
so a big thank you to everyone in the âThe New Paperclipâ community!
In the spirit of community, here are a few links to a few of the top articles being featured right now in the Microsoft Office section of Alltop!
âtill next time!
TNP đ
Have you been working on a spreadsheet, sale but then suddenly realised that you need to add another column?
Well there are a couple of ways to add a column to your spreadsheet in Excel 2007.
The long way
1) Select the cell that is to the right of where you want the new column to appear
2) Look at the ribbon, see
and make sure you are on the âHomeâ tab
3) Look to the right, buy
and you will see the âCellsâ group
4) Click on âInsertâ, and then select âInsert Sheet Columnsâ
The short way
1) Right click on the top of the column (the letter) that is to the right of where you want the new column to appear
2) Click âInsertâ from the menu that appears
If you want to add two or more columns, you can use one of the methods above, and simply use the âRedoâ command to keep inserting new columns â either use the button in the top left hand corner (in the Quick Access Toolbar), or simply use the shortcut – CTRL+Y
âtill next time!
TNP đ
Are you writing a report, approved
an assignment, nurse
or just a plain old document and need to hyphenate you paragraphs?
By default, Word 2007 has hyphenation turned off, but it is really easy to turn it on, and there are a number of options to control how the hyphenation works.
To turn on hyphenation in Word 2007 to hyphenate your document, simply:
1) Go to the âPage Layoutâ tab on the Ribbon
2) Look for the âPage Setupâ group
3) Click on âHyphenationâ
4) Select âAutomaticâ
Now that your document is hyphenated, lets look at the settings you can change to control exactly how the hyphenation works!
5) Click on âHyphenationâ again
6) Click on âHyphenation OptionsâŚâ
In the box that appears, there are two key settings you can play with. The first is the âHyphenation zoneâ, and the second is âLimit consecutive hyphens toâ. Change these settings to adjust the hyphenation to meet your needs!
âtill next time!
TNP đ
Are you lazy like me and feel that clicking your mouse to change slides in PowerPoint 2007 is not a good use of your time?
Maybe not!
⌠but maybe you just want a series of slides to advance automatically whilst you talk to your PowerPoint deck. Well with PowerPoint 2007 it is easy.
1) Select the slides you want to have automatically advance
2) In the Ribbon, pathopsychology
make sure you are on the âAnimationsâ tab
3) Look to the far right hand side, find
and make sure you check âAutomatically Afterâ
4) Beside that checkbox, visit this site
enter the number of seconds you want to the slide wait before it automatically transitions to the next.
Simple as that! Whilst you are there, you can also change the transition â whether you want a fade, dissolve, wipe, push and cover, or stripes and bars â just choose your favourite from the transition gallery!
âtill next time!
TNP đ
Do you need to find a phone number of one of your colleagues? Well if you have Office Communicator 2007 you can quickly look up their digits.
1) Find the person in your contact list, approved
or using the Search feature
2) Look for the phone beside their name
3) Hover your mouse over the phone, and click on the little arrow that appears
4) You will find the phone number on the fly-out menu
âtill next time!
TNP đ
Search folders are one of the great new features of Outlook 2007 that can really help you be more productive. Essentially they are a view of your inbox based on certain criteria that you can pick yourself.
For example, tuberculosis
maybe you want a search folder that shows you all your emails from your boss? Or a folder that shows you all the emails you have over 200kb?
Outlook 2007 comes setup with a few default search folders, tadalafil
like âUnread Mailâ. That being said, it is really easy to set up your own.
1) Click on the little arrow beside the âNewâ button in the top left hand corner of your Outlook 2007 window
2) In the drop-down menu that appears, click on âSearch Folderâ (or just use the shortcut – CTRL+SHFT+P)
3) In the box that appears, start to select the criteria you want to use
4) Depending on what you just chose, fill in the box below â for example, if you want to show all the emails from your boss⌠put their email address in there
5) Click âOKâ
Now you can keep track of your email by looking at it in different ways⌠and make sure you know where your bossâs emails are just in case they come asking questions!
âtill next time!
TNP đ
Have you spent hours working on the perfect project plan, buy cialis with literally hundreds, no rx
if not thousands of tasks! Chances are you might have mistyped a few things.
Luckily Project 2007 has the same great spell checking ability you will find in other Microsoft Office products.
To spell check your Project in Project 2007
1) Click on âToolsâ
2) Click âSpellingâ
or⌠just use the âF7â key on your keyboard!
âtill next time!
TNP đ
Have you ever had a little bit too much text to fit into a cell in Excel 2007. Maybe it is a description of a product, bronchi
a company name, for sale or simply lots of information you need to see without having to resize your columns!
Well there is an easy way to ensure you can see all that information when you need to. You need to wrap your text!
What is wrapping text? Wrapping text simply breaks the text into multiple lines, find
instead of one long line, and it is really easy to do!
How do you do it?
1) Select the cell (or cells) in which you want to wrap the text
2) On the âHomeâ tab in the Ribbon, look for the âAlignmentâ group
3) Click on âWrap Textâ
âtill next time!
TNP đ
Donât you hate how you put lots of effort into a Word 2007 document, more about
and then you see one of your colleagues play around with the formatting, approved
or accidentally delete an important section.
Or maybe you want to force users of your document to only edit certain parts â for example if you have built a form that you want people to fill in.
Well in Word 2007 there is a great feature which can literally protect the important parts of your document, and restrict them from being changed, edited or deleted. Funnily enough, it is called âProtect Documentâ
So how do you protect a Word 2007 document?
1) Create your document
2) Make sure you can see the âDeveloperâ tab in the Ribbon. If you can, move to step three! If not, you need to click on the âOffice Orbâ in the top left hand corner, then click on âWord Optionsâ, and finally whilst in the âPopularâ section, make sure you check âShow Developer tab in the Ribbonâ
3) Click on the âDeveloperâ tab in the Ribbon
4) Look for the âProtectâ group, and click on âProtect Documentâ
5) Click on âRestrict Formatting and Editingâ
6) Look at the right hand side. You will now see a task pane which will talk you through all the different formatting and editing restrictions you can put in place. Select your favourite settings, and when you are readyâŚ
7) Click on âYes, Start Enforcing Protectionâ
Now if your employer has gone to the lengths of implementing an Information Rights Management system, there are a few other extra restrictions you can put in place, which you will find when you click on the âProtect Documentâ button in the Ribbon. They are out of the scope of this article and I am sure I will write about them in the future as more and more organisations implement IRM.
So there you have it â now you can sleep at night knowing that no one is messing with your document!
âtill next time!
TNP đ
Are you keeping your meeting minutes in OneNote 2007? Well it would be a great idea to put all the details of the meeting at the top of your OneNote 2007 page right?
Well you can stop opening up Outlook, capsule
double clicking on the meeting, see copying the details, eczema
opening up OneNote, finding the right Notebook and the right page⌠and then paste (what a relief!)
So how can you save all that pain?
1) Make sure you have Outlook 2007 open!
2) Open up OneNote 2007 and find the page you want to work on
3) Click on the âInsert Menuâ
4) Click on âInsert Outlook Meeting Detailsâ
5) Select the Meeting you want to insert
6) Click âInsert Detailsâ
This inserts a great summary of the meeting into your OneNote 2007 Notebook, including the name of the meeting, the Date and Location, the Attendees, and any of the details you included in the original meeting request.
What a great time saver!
âtill next time!
TNP đ
Do you want a little extra space before a paragraph? Or maybe you want a big break after one? Well lucky for you you can change the spacing before and after each of your paragraphs in Word 2007. And the best part is that you can be very granular in how much space you want there to be!
Here is how:
1) Select the paragraph or paragraphs you want to change the paragraph spacing of
2) In the âRibbonâ, ophthalmologist
make sure you are on the âPage Layoutâ tab
3) Look for the âParagraphâ group
4) Simply enter how much space you want before, or after your paragraph. You can use âptâ points (just like your font size), or you can use cm, mm, inches.
Now you can get your paragraphs to sit exactly where you want them to!
âtill next time!
TNP đ
So you have created your PowerPoint masterpiece! But now you want to make sure a couple of the slides you put in donât show up when you do your presentation. Or maybe you have a few slides that are âwork in progressâ? Either way there is a quick and easy way to make sure those slides do not show up on the big screen!
You can hide one, capsule
two, Hemophilia
three, otolaryngologist
four, five, ten, twenty, in fact as many slides as you want! Here is how
1) Select the slides you want to hide
2) Right click on the slides you have selected, and click âHide Slideâ
Simple as that!
There is another way using the âRibbonâ if you prefer to do it that way
1) Select the slides you want to hide
2) Make sure you are on the âSlide Showâ tab in the Ribbon
3) Look for the âSet Upâ group
4) Click on the âHide Slideâ button
There you go!
But now you want to make your slides appear again? Just do exactly the same! Select the hidden slides you want to unhide, then click âHide Slideâ again!
âtill next time!
TNP đ
Do you spend hours making your cells in Excel look pretty? Well maybe not pretty, health but do you use colors, healing font sizes, infertility
borders etc etc to make certain cells in your spreadsheet stick out?
Well instead of spending all your time trying to be one of those creative folk in Marketing, you can focus on doing what you do best⌠driving those formulas!
All you need to do is use Cell Styles in Excel 2007, Excel 2010 and Excel 2013!
1) Select the cell you want to highlight!
2) Make sure you are on the âHomeâ tab in the âRibbonâ
3) Look for the âStylesâ Group
4) Click on âCell Stylesâ
5) Select your favorite cell style!
It is as simple as that!
âtill next time!
TNP đ
So you have typed all your data into Excel. But your numbers donât have those commas that you had on paper? How do you add commas, capsule
or thousands separators to your numbers in Excel 2007?
1) Select the cells you want to have the commas (or thousands separators)
2) Make sure you are on the âHomeâ tab in the âRibbonâ
3) Look for the âNumberâ group
4) Click on the button that looks like a comma!
âtill next time!
TNP đ
Have you or a creative genius close to you built an unreal shockwave/flash animation and you want to show the world?
Did you know that you can show off that animation using PowerPoint 2007? Bet you didnât. That being said it isnât the simplest of things you can do â but it does work. Here is the step by step guide to doing it!
1) Open PowerPoint 2007 (obvious right!)
2) Make sure you can see the âDeveloperâ tab in the âRibbonâ. If you canât, more about
click on the Office menu (the circle button in the top left hand corner), visit this
then click on âPowerPoint Optionsâ, and make sure that you check the âShow Developer tab in the Ribbonâ box!
3) Go to the slide you want the .swf file to appear
4) Click on the âDeveloperâ tab in the Ribbon
5) Look for the âMore Controlsâ button in the controls group. It is the one with a spanner and a hammer with three dots underneath it. Once you find it â click on it
6) The âMore Controlsâ box will appear. Scroll down until you find âShockwave Flash Objectâ. Click on that, then click âOKâ
7) You will notice your cursor is now a cross, and no longer an arrow. That means you can now draw where you want your Shockwave/Flash file to appear on your slide. Simply draw with your mouse, and use the adjustment handles on the box to make sure it is just the right size and position on your slide. When you are done you should see a wireframe box with a big âXâ through the middle of it
8) Now we want to link your .swf file into your PowerPoint 2007 presentation. Click on the box you just drew, then right click, and select âPropertiesâ
9) In the properties box that appears, look for the âMovieâ property, and then add the location of your .swf file (for example c: emp est.swf)
10) Quickly run your presentation and watch in awe as your shockwave file hits the big screen in your PowerPoint 2007 presentation
So how did you go? Sure it is a little complicated to get there, but boy does it look good once you have that file playing through PowerPoint.
Just a word of warning though â this only LINKS to the .swf file, so if you email or share the presentation with others, chances are the link will break and you will need to go through the above process again to re-link the PowerPoint deck to the .swf
That being said⌠it is well worth the effort!
âtill next time!
TNP đ
So you have upgraded to Word 2007, nurse
but none of your friends, this
colleagues, this
co-workers, family, pets, neighbours, local government officials or industry tycoons have upgraded yet!
And even worse still, they are all too lazy to download the Office Compatibility pack! Can you believe it!
So what are you to do? Well if you are one of the many people out there in this situation, about all you can do is save your Word 2007 documents in the old Word 97-2003 .doc format. Only problem is every time you go to save, you need to use a few extra mouse clicks to make it happen. If only you could set Word 2007 to default to save as a .doc file?
Well guess what â you can! Here is how:
1) Open up Word 2007
2) Click on the Office Menu (the circle button in the top left hand corner of Word 2007)
3) Click on âWord Optionsâ
4) Click on the âSaveâ button in the left hand column
5) Look at the very first option on that screen â it lets you select the default save format. It will be currently set to âWord Document (*.docx)â. You want to change it to âWord 97-2003 Document (*.doc)â using the drop down menu.
6) Click âOKâ
There you have it! Now Word 2007 will automatically default to save your documents in the old Word 2003 format. And more importantly, all your friends, colleagues, workmates etc will now want to talk to you again!
âtill next time!
TNP đ
Are you an active user of Groove 2007, anabolics
and are constantly bombarded with alerts telling you manner of things have changed! Well there is an easy way to stop the insanity, the annoyance, and be more productive. All you need to do is âSuppressâ the alerts:
1) Look at the Groove 2007 Launchbar
2) In the âCommon Tasksâ section, simply click on âSuppress Alertsâ
If you get bored and want your alerts back, simply go back to the Launchbar, and click âShow Alertsâ
âtill next time!
TNP đ
Do you love using copy and paste in Word 2007? Well if you do, noun
you might know that your clipboard can keep up to the last 24 things you have copied, decease
just in case you want to use them again.
But how do you see what is still on your clipboard, click
and more importantly, how do you use those âclipsâ again?
1) Make sure you are on the âHomeâ tab in the Ribbon
2) Look for the âClipboardâ group â it should be the one on the left hand side
3) Click on the little square that looks like it has an arrow pointing out of it, in the bottom right hand corner of the âClipboardâ group
4) A box showing everything in the clipboard will appear
Now all you need to do if you want to use something on the clipboard is simply click on it in that clipboard box! How easy is that!
And if you know you wont use something in the clipboard again, you can delete it to make room for other things. Simply right click on the clip you want to get rid of, and click âDeleteâ
âtill next time!
TNP đ
Are you a hardcore spreadsheet king? The number cruncher? On the Accounting A-team?
Then chances are⌠your spelling is⌠well⌠not very good at all!
Luckily Excel 2007, misbirth
Excel 2010 and Excel 2013 all have a spell checking feature that will stop people from noticing your spelling mistakes!
1) Click on the âReviewâ tab in the Ribbon
2) Click on âSpellingâ
or alternatively just use the âF7â keyboard shortcut!
âtill next time!
TNP đ
Are you a traditionalist who hates Graphical Interfaces. Do you love WordPerfect classic mode, pharmacy
or run Vim at home, diabetes and Pregnancy
but have to use Word 2007 in the office?
Or do you just want to focus on writing, and none of that formatting stuff that an editor can deal with for you?
Well you might be surprised to know that you can very quickly set up Word 2007 to get rid of the Ribbon, get rid of the status bar, and change the colours to a classic monochrome green with a black background!
Bet you didnât know that!
Well our friends over at the Microsoft Office Word Team Blog have described exactly how to set up Word 2007 in a quasi-classic mode! You can read more about it in their post called Word Throwback âJust Writeâ Edition⌠which was coincidentally inspired by one of my favourite authors and bloggers, Tim Ferriss.
How cool is that! Takes me back to 1989!
âtill next time!
TNP đ
Are you building a gem of a spreadsheet, hospital
but feel that it would look much better if it didnât have those lines in between all the cells?
Well those lines are called âGridlinesâ and they are really easy to turn on and off
To hide gridlines in Excel 2007, buy
Excel 2010 or Excel 2013:
- Make sure you are on the âViewâ tab in the Ribbon
- Look for the âShow/Hideâ group
- Click on âGridlinesâ checkbox, which will make the tick (and the gridlines) disappear
To show gridlines in Excel 2007, Excel 2010 or Excel 2013:
- Do the same as above, but just make sure that you check the checkbox!
Simple as that!
âtill next time!
TNP đ
Do you HATE Tahoma? Would you prefer something that suits your style? Like a classy Georgia? Or a disturbed Comic Sans MS?
Well it is really simple to change the default font in Office Communicator 2007.
1) Click on the big âStatus Indicatorâ in the top left hand corner of your Office Communicator 2007 window
2) Click on âOptionsâ
3) Select the âGeneralâ tab in the options box that appears
4) In the âInstance message settings section, viagra 60mg
click on âChange FontâŚâ
5) Select your favourite font
6) Click OK twice to close all the dialog boxes
There you go⌠now your instant message conversations in Office Communicator 2007 will match your personal style⌠or as the marketing gurus say⌠your personal âbrandâ.
âtill next time!
TNP đ
For all those Visio lovers out there, find then you should already know about the Microsoft Visio Toolbox. If not, you seriously canât call yourself a Visio lover!
The Visio Toolbox is a collection of articles, case studies, and most importantly add-ins for Visio 2007.
So if you are looking for justification for your boss to upgrade to Visio 2007, articles on interesting topics such as âSilverlight and Visioâ, or add-ins such as the Rack Server Virtualization Add-In, the Disk Space Monitoring Add-in, or the Microsoft Exchange Server 2007 Visio Add-in⌠then you need to check out the Microsoft Visio Toolbox!
âtill next time!
TNP đ
Has this ever happened to you? You start working on your masterpiece in Word 2007, dosage
and then you send the document out to a number of people for their feedback.
They all add their two cents (some add twenty!) and then email the document back to you.
But now you are stuck in a dilemma⌠how do you quickly merge all those changes together into one document, viagra approved
without having to read each line and try to understand what they changed.
Well there is a great feature in Word 2007 called âCombineâ. You can use it to simply combine to documents, price
and see all the differences between the two documents. You can track what has been inserted, what has been deleted, what has been moved, any formatting changes, and see any comments they made.
But that isnât the best part. It also creates a new combined document without losing the original and revised document.
So how do you do it?
1) Make sure you are on the âReviewâ tab in the Ribbon
2) Look for the âCompareâ group
3) Click on the little arrow below the âCompareâ button
4) Click âCombineâ
5) Select your âOriginal Documentâ and your âRevised Documentâ
6) Click OK
7) Check out your brand new combined Word 2007 document!
How easy is that!
âtill next time!
TNP đ
Did you know that you can add a footer to each and every slide in your PowerPoint 2007 deck? It is easier than you think.
There are three areas at the bottom of each slide that the default master slide (think of it is the master layout for your PowerPoint slides) sets aside so you can add footer information to each of your slides. Information like, orthopedist
the date, mind
the slide number, and the title of your presentation
To add a footer to your PowerPoint presentation, simply:
1) Make sure you are on the âInsertâ tab in the Ribbon
2) Look for the âTextâ group
3) Click on âHeader & Footerâ
4) In the Header and Footer box that appears, select what you want to include on the slide.
5) Click âApplyâ, to apply to the current, single slide, or click âApply to Allâ to apply to every slide in your presentation
There you have it â PowerPoint footers the easy way!
âtill next time!
TNP đ
We all know how handy track changes is in Word 2007⌠but did you know you can track changes in Excel 2007 as well?
I bet you didnât!
It is just as easy to use as in Word⌠here is how!
1) Make sure you are on the âReviewâ tab on the Ribbon in Excel 2007, viagra Excel 2010 or Excel 2013
2) Look for the âChangesâ group (should be the one on the far right hand side)
3) Click on âTrack Changesâ
4) Click on âHighlight Changesâ
5) Check âTrack changes while editing. This also shares your workbook.â
6) Select what you want highlighted
7) Click OK
Once you have plenty of changes highlighted, click
just go back to the âTrack Changesâ button and click âAccept/Reject Changesâ
Now you can really keep track of things in Excel 2007!
âtill next time!
TNP đ
We all know how handy track changes is in Word 2007⌠but did you know you can track changes in Excel 2007 as well?
I bet you didnât!
It is just as easy to use as in Word⌠here is how!
1) Make sure you are on the âReviewâ tab on the Ribbon in Excel 2007, sale
Excel 2010 or Excel 2013
2) Look for the âChangesâ group (should be the one on the far right hand side)
3) Click on âTrack Changesâ
4) Click on âHighlight Changesâ
5) Check âTrack changes while editing. This also shares your workbook.â
6) Select what you want highlighted
7) Click OK
Once you have plenty of changes highlighted, implant
just go back to the âTrack Changesâ button and click âAccept/Reject Changesâ
Now you can really keep track of things in Excel 2007!
âtill next time!
TNP đ
I thought I would spend some time today checking out some of the other Office 2007 help/tutorial sites out there. There are quit a few good ones, more about
and in the interest of helping you get the most out of your Word 2007 experience, ampoule
I thought I will publish a list of my favorite ones!
Now of course, you will find the best Word 2007 tutorials (if I do say so myself) here at TheNewPaperclip.com⌠but if you want a bit of variety⌠check out a few of these guys!
Microsoft Office Online â Word 2007 Courses (Microsoft.com)
There are 27 courses here, each ranging from 20-50 minutes on a wide range of Word 2007 topics. And this is straight from the horses mouth at Microsoft!
Microsoft Word 2007 Tutorial â Free & Online (BayconGroup.com)
Full of practical exercises, this beginners tutorial is broken into five lessons so you can learn at your own pace!
Microsoft Word 2007 In Pictures (InPics.net)
This is a great visual tutorial that explains exactly how to get up to speed with the basics in Word 2007 â highly recommended!
Microsoft Word 2007 Tutorials (Word07.com)
Fairly comprehensive list of topics covering most of what you would want to know about Word 2007.
So there you have it â a quick selection of some of the best Word 2007 tutorials out there.
And remember, if you want Word 2007 tips delivered to your inbox regularly, make sure you subscribe to the Office 2007 newsletter!
âtill next time!
TNP đ
Hey do you remember how awfully slow searching for emails was in old versions of Outlook?
Well thank you to the folk at Microsoft who fixed this up and gave us a far superior search feature! But are you getting the most out of Outlook 2007 search?
Obviously you can do a standard basic search for keywords in your emails, healing and that works quite well. But did you know you can get quite granular with your search and find the email you are looking for much quicker?
For example, it is quite simple to search for emails that are from your boss that had the subject âPayriseâ in them â and get the results very quickly without having to scroll through dozens if not hundreds of results.
So with that in mind, I thought I would run through some of the different search criteria you can use to get the most out of search in Outlook 2007. I canât go through every single possible search query, but you will get the idea. Just remember that you can combine any of the searches below, and include keywords at the end to really target the email you are after.
Search for emails from an individual
Simply type âfrom:insert name or email address hereâ and that will return all the emails from that person.
For example â from:bill, or from:bill@abc.com, or from:"Bill Smith"
Search for emails sent to an individual
Simply type âto:insert name or email address hereâ and that will return all the emails sent to that person
For example â to:bill, or to:bill@abc.com, or to:"Bill Smith"
Search for emails received in the last x number of days
Simply type âreceived:timeframe" and that will return all the emails in that particular timeframe
For example â received:yesterday, or received:last week, or received:this year
Search for emails with a particular subject line
Simply type âsubject:subject lineâ and that will return all the emails with include that subject line
For example â subject:payrise, or subject:(leave application), or subject:(lunch on thursday)
Search for emails with particular words in the body
Simply type âbody:keywordâ and that will return all the emails that include that keyword in the body of the email
For example â body:payrise
There are plenty of other search criteria you can use⌠here is a list:
- If the email has been read
- If the email has an attachment
- Who was BCCâd on the email
- Who was CCâd on the email
- What categories the email was placed in
- The due date for any follow up on the email
- The importance of the email
- The flag status of the email
- What folder the email is in
- What size the email is
- When the email was last modified
- What sensitivity level the email has
- When it was sent
- When the start date of the email follow up is
So there you have it, a quick introduction to the possibilities with Outlook 2007 search. Now you can be confident that you will always be able to find emails when you need them!
âtill next time!
TNP đ
Did you ever notice that when you show your PowerPoint 2007 deck that it always shows it as a full screen?
Have you ever wondered if it was possible to show a PowerPoint presentation in a window that you can resize to meet the needs of your presentation? For example, public health
you might want to demonstrate a product, and have your presentation on the screen at the same time!
Well there is a well hidden command in PowerPoint 2007 which means you can show your deck in a window! Here is how to do it:
1) Beside the quick access toolbar (in the top left hand corner of the screen â it is the one what has the save, and undo buttons) you will see a little arrow that points down. Click on that
2) From the menu that appears, click âMore CommandsâŚâ
3) In the âChoose commands from:â dropdown box, select âAll Commandsâ
4) You will see literally hundreds of commands listed. Luckily they are all in alphabetical order! Scroll down until you find one that says âSlide Show in a Windowâ. Click on that.
5) Click on the âAdd > >â button to add that command to your quick access toolbar
6) Click âOKâ
You will notice that there is a brand new button in your quick access toolbar in PowerPoint 2007. It looks like a presentation screen, with a window in front of it.
Simply click on that button, and your presentation is now delivered through a window instead of full screen!
How easy is that!
âtill next time!
TNP đ
If you are anything like me, condom
your handwriting is very very bad! In fact, if you are really like me you need all the help you can get to ensure that your handwriting is legible!
Well if you are using your pen or stylus in OneNote 2007 to take notes, there is an option to help you at least write straight lines! They are called Rule Lines, and are really easy to add to pages in your OneNote 2007 Notebooks. Here is howâŚ
1) Open up your notebook, and go to the page you want to add Rule Lines to
2) Click on âFormatâ in the menu
3) Click on âRule Linesâ
4) Select your preferred rule line option
There are a number of different line rules you can use to ensure you can get the most out of your OneNote 2007 notebook. They are:
- Narrow Ruled
- College Ruled
- Standard Ruled
- Wide Ruled
- Small Grid
- Medium Grid
- Large Grid
- Very Large Grid
Thatâs right â you might have noticed that there is also a grid rule you can use, just like that graphing paper we had to use back in school! Ahh the memories!
âtill next time!
TNP đ
Recently I have been rummaging through the blogs over at MSDN and I just stumbled across what has to be one of the best Excel 2007 posts of the year!
âMicrosoft Excel and Twitter via Smart Tags in a VS 2008 Solutionâ
Basically, symptoms
John Durant (a Microsoftie) has built some code which enables him to use Smart Tags to tweet the contents of a cell with only a couple of clicks.
How cool is that! If you are interested in extending the functionality of Excel 2007, view
make sure you read more in Johnâs post here.
And if you are on Twitter, there
why not follow @thenewpaperclip for regular Office 2007 hints, tips, tricks and tutorials.
(and if you are really bored, you could follow the guy who is behind The New Paperclip – @paulwoods)
âtill next time!
TNP đ
Donât you hate when you print your spreadsheet, viagra 60mg
and one or two columns end up going over onto a second page? It happens to me ALL THE TIME!
But there is a way to save you from stressing, clinic
and save the environment at the same time đ
There is a page setup option in Excel 2007, pilule
Excel 2010 or Excel 2013 which you can use to fit your spreadsheet onto a single page (or onto a particular number of pages that you set!)
Here is how:
1) Click on the âPage Layoutâ tab in the Ribbon
2) Look for the âPage Setupâ group, and click on the little square with the arrow pointing out of it in the bottom right hand corner
3) In the âPage Setupâ box that appears, look in the âScalingâ section, and select âFit to:â
4) By default, it will be set to one page wide by one page tall. Select how many pages wide or tall you want your spreadsheet to be printed as.
5) Click âPrint Previewâ if you want to take a look at what the scaled or up version of your spreadsheet will look like, and if you are happy with it â click âPrintâ!
6) Click âOKâ to close the Page Setup box
âtill next time!
TNP đ
Donât you hate when you print your spreadsheet, steroids
and one or two columns end up going over onto a second page? It happens to me ALL THE TIME!
But there is a way to save you from stressing, unhealthy and save the environment at the same time đ
There is a page setup option in Excel 2007, sales
Excel 2010 or Excel 2013 which you can use to fit your spreadsheet onto a single page (or onto a particular number of pages that you set!)
Here is how:
1) Click on the âPage Layoutâ tab in the Ribbon
2) Look for the âPage Setupâ group, and click on the little square with the arrow pointing out of it in the bottom right hand corner
3) In the âPage Setupâ box that appears, look in the âScalingâ section, and select âFit to:â
4) By default, it will be set to one page wide by one page tall. Select how many pages wide or tall you want your spreadsheet to be printed as.
5) Click âPrint Previewâ if you want to take a look at what the scaled or up version of your spreadsheet will look like, and if you are happy with it â click âPrintâ!
6) Click âOKâ to close the Page Setup box
âtill next time!
TNP đ
Are you lazy like me and hate typing dates? Well did you know you can add one of those cool calendar style date pickers to your Word 2007 document?
It is pretty easy:
1) Make sure you can see the âDeveloperâ tab in the Ribbon. If you canât, this web
click on the Office menu (you know⌠the old file menu) in the top left hand corner of Word 2007, order
then click on âWord Optionsâ. Then simply check the third checkbox âShow Developer tab in the Ribbonâ
2) Click on the âDeveloperâ tab in the Ribbon
3) Look for the âControls Groupâ
4) Click on the icon that looks like a tiny calendar (should be the second icon on the second row)
5) Click on the control that now has been added to your document, and select your favourite date!
âtill next time!
TNP đ
Page up and page down are great tools to quickly move through your Word 2007 document. But they are not that precise. Wouldnât it be good if you could browse by things that matter in your document â like all the headings, medicine
or the tables, or the graphics?
Well you can!
In fact you can browse by all of the following:
- Fields
- Endnotes
- Footnotes
- Edits
- Headings
- Comments
- Sections
- Graphics
- Tables
- and of course, the default â Pages
⌠simply by using CTRL + PgUP (Page Up), and CTRL + PgDn (Page Down) â or the up and down arrows in the bottom right hand corner of your Word 2007 window
So how do you set which thing you want to browse by? There are two ways:
1) Click on the âdotâ in the bottom right hand corner of your Word 2007 window (the dot in between the two up and down arrows) â and then select what you want to browse by
orâŚ
2) Use the shortcut âALT + CTRL + HOMEâ and then select your preference
So for example, say you select âBrowse by Headingâ, every time you press CTRL + PgDn, the cursor will move to the next heading. Likewise if you selected âBrowse by Tableâ, every time you press CTRL + PgUp, the cursor will move to the previous table.
This can be a very powerful tool to use, especially if you are editing or reviewing your document!
âtill next time!
TNP đ
Are the normal line spacing (or âLeadingâ) options in Word 2007 just not enough? Not very many people know it, more about
but you can have some very fine grained control over the space between your lines.
In fact, pharmacy
you can say how many âPtsâ space there is â for example, tadalafil
12pts, or you can get really precise and give a spacing in cm, mm, or inches.
Here is how to do it!
1) Select the text you want to change the leading/line spacing of
2) Make sure you are on the âHomeâ tab in the Ribbon
3) Look for the âParagraphâ group, and click on the little square with an arrow pointing out of it in the bottom right hand corner of that group
4) Look down the box that appears until you get to the âSpacingâ options. In the right hand column you will see a âLine Spacing:â drop down box. Select âExactlyâ
5) Beside that dropdown box, there is a dropdown box called âAt:â. Type in your desired line spacing or leading in pts, cm, mm, or "
6) Click âOKâ
Now you have precise control over exactly how far apart your lines appear in Word 2007! How good is that!
âtill next time!
TNP đ
If you have been around the block a few times with Word 2007, pfizer
you will be more than familiar with codes. You know⌠amongst other things that backwards âPâ that you see at the end of the paragraph.
Well did you know you can have the same codes appear in your Publisher 2007 document as well?
It is really easy to turn on and off:
1) Look for the âbackwards Pâ icon in the menu, and click that!
or you can justâŚ
2) Press âCTRL + SHFT + Yâ
Now you have even more control over your Publisher 2007 design!
âtill next time!
TNP đ
Hey, sales
we all love our Gantt charts, search
but as project managers sometimes you donât want the Gantt chart to be the first thing you see in the morning (ainât that the truth!)
There are literally dozens of different views you can have in Project 2007⌠like:
- Bar Rollup
- Calendar
- Descriptive Network Diagram
- Detail Gantt
- Gant Chart
- Levelling Gantt
- Milestone Date Rollup
- Milestone Rollup
- Multiple Baselines Gantt
- Network Diagram
- Relationship Diagram
- Resource Allocation
- and many many more!
So how can you set one of these views as the default view in Project 2007?
1) Click on the âToolsâ menu
2) Select âOptionsâŚâ
3) On the âViewâ tab, the very first dropdown is âDefault view:â. Simply select your preferred default view
4) Click âOKâ
Now you donât have your Gantt chart popping up first thing in the morning, the flashbacks to all those bad projects should stop đ
âtill next time!
TNP đ
Do you receive those loooooooooooooong emails at work which have about 14 different message replies or forwards included in the body of the email?
Wouldnât it be good to start from scratch and have all that content in an attachment? Well in Outlook 2007 you can do just that â forward an email as an attachment. What does that mean? That the recipient of your message can focus on your message, decease
and not all the boring messages that came beforehand đ
So how do you forward an email as an attachment in Outlook 2007?
1) Select your message
2) Press CTRL + ALT + âFâ
3) Type your message and hit send!
Simple as that! If you want to forward multiple emails as attachments, just select all the messages first before typing CTRL + ALT + âFâ
âtill next time!
TNP đ
If you are a keen user of OneNote 2007, pharmacy
you by now will have 3, malady 4, visit web
5, 10, 20 or more workbooks. One way that you can differentiate between those different workbooks is the colour that each one has.
Thatâs right! Did you notice that each workbook icon is in fact a different colour?
Well like most things in Office 2007, it is really easy to change those workbook colours. Maybe you want to do it so one or two key workbooks stand out⌠maybe you just want to show some of your personality. Either way, this is how you go about it!
1) Right click on the OneNote 2007 Workbook
2) Select âPropertiesâŚâ
3) Select your favourite color from the colour palate.
4) Click âOKâ
âtill next time!
TNP đ
I am sure you are more than familiar with the default layouts that you regularly see in PowerPoint 2007. The first one you always see is the âTitle Slideâ layout, for sale
and whenever you add a new slide after that, you will see the âTitle and Contentâ layout.
But did you know that there are plenty of other layouts you can use, which might help you lay out the information on your slide a lot cleaner, nicer, better etc etc.
If you are on the âHomeâ tab of the Ribbon you will see the âSlidesâ group, and in that group, the âLayoutâ button. If you click on that, you will see all the different layout options at your disposal:
- Title Slide
- Title and Content
- Section Header
- Two Content
- Comparison
- Title Only
- Blank
- Content with Caption
- Picture with Caption
There are two simple ways you can use these layouts in your PowerPoint deck.
Create a new slide with a specific layout
1) Make sure you are on the âHomeâ tab in the Ribbon
2) In the âSlidesâ group, click on âNew Slideâ
3) Select your preferred layout from the gallery
⌠alternatively you can change the layout of specific slides in your presentation.
Change the layout of an existing slide
1) Select the slide or slides you want to change the layout of
2) Right click on the selected slide(s), and move your mouse over âLayoutâ
3) Select your preferred layout from the gallery
âtill next time!
TNP đ
(not only that⌠but how to change the colour of the tab as well!)
Hey if you have been using Excel 2007, cure
Excel 2010 or Excel 2013Â for more than five minutes, sale
you would have noticed the three tabs down the bottom. You know the ones âSheet1â, look âSheet2â, and you guessed it⌠âSheet3â.
But what if you donât like those names, and you want to rename them to something more meaningful? Like âExpensesâ, or âAssetsâ, or âTeam Sick Leave Trackingâ?
Well all you need to do is:
1) Right click on the tab that you want to rename
2) Click âRenameâ
3) Type in what you want the sheet to be renamed to
4) Hit enter
That was pretty easy⌠but what if you need to distinguish between the sheets in your workbook even more? Well did you know that you can change the color of each of the tabs in your workbook? It is really easy:
1) Right click on the tab that you want to recolour
2) Move your mouse over âTab Colorâ
3) Select your favourite colour!
4) Look in awe at your colourful worksheet tabs!
Simple as that! Now get back to tracking sick leave! đ
âtill next time!
TNP đ
(not only that⌠but how to change the colour of the tab as well!)
Hey if you have been using Excel 2007, ask Excel 2010 or Excel 2013Â for more than five minutes, pregnancy
you would have noticed the three tabs down the bottom. You know the ones âSheet1â, âSheet2â, and you guessed it⌠âSheet3â.
But what if you donât like those names, and you want to rename them to something more meaningful? Like âExpensesâ, or âAssetsâ, or âTeam Sick Leave Trackingâ?
Well all you need to do is:
1) Right click on the tab that you want to rename
2) Click âRenameâ
3) Type in what you want the sheet to be renamed to
4) Hit enter
That was pretty easy⌠but what if you need to distinguish between the sheets in your workbook even more? Well did you know that you can change the color of each of the tabs in your workbook? It is really easy:
1) Right click on the tab that you want to recolour
2) Move your mouse over âTab Colorâ
3) Select your favourite colour!
4) Look in awe at your colourful worksheet tabs!
Simple as that! Now get back to tracking sick leave! đ
âtill next time!
TNP đ
Are you always having to resize your columns in Excel 2007?
Wouldnât it be great if you could reset the default column width so whenever you open a spreadsheet you didnât have to resize those columns once you start filling them with data!
It is very simple to doâŚ
1) In Excel 2007, pill
on the âHomeâ tab look for the âCellsâ group
2) Click on the âFormatâ buttonâ
3) On the menu that appears Click on âDefault WidthâŚâ (about the fifth one down)
4) Type in your preferred default column width and click âOKâ
So there you have it â no more unnecessary column dragging!
âtill next time!
TNP đ
If you regularly collaborate with others creating Word documents, medicine
or Excel spreadsheets â I am sure that you are very familiar with the commenting feature.
Basically it allows you to add comments throughout the document or spreadsheet for others to see when they are reviewing the work.
Well you will be happy to know that you can also add comments to the slides in your PowerPoint 2007 presentations.
Here is how:
1) Go to the âReviewâ tab in PowerPoint 2007
2) Look for the âCommentsâ group
3) Click on âNew Commentâ
4) Write your comment
5) Click on the comment and drag it to where you want it to appear on your slide
⌠but how do I change the name associated with the comment?
Good question! PowerPoint takes that information from the information that has been entered in the PowerPoint options menu.
1) Click on the âOffice Orbâ â that is the old file menu in the top left hand corner of the screen
2) Click on âPowerPoint Optionsâ
3) Look for âPersonalize your copy of Microsoft Officeâ. You will find the User Name and Initials there. Simply change them to the right details and your comments will now be attributed to the right person.
âtill next time!
TNP đ
Do you use OneNote 2007 so much that you start to run out of space on the pages of your OneNote notebooks?
Well there is a neat little feature in OneNote 2007 which enables you to create more whitespace by pushing the content on your page out of the way.
To find it:
1) Click on âInsertâ
2) At the bottom of the menu, discount
click on âExtra Writing Spaceâ
3) Click on your page where you want the whitespace to start, cough
then drag to where you want it to end.
Simple as that!
âtill next time!
TNP đ
Do you want to add a classy touch to the publication that you are working on in Publisher 2007?
A drop cap is a great way to do that. For those that donât know what a Drop Cap is⌠it is one of those big letters you see at the start of a paragraph.
In Publisher 2007 it is easy to add a drop cap.
1) Click on the paragraph of text you want to add the drop cap to
2) Click on the âFormatâ menu
3) Click on âDrop Capâ
4) Select the drop cap style you want to use. If you want to make something really special, cost
click on âCustom Drop Capâ and select the letter position, size, font and colour
5) Click âOKâ
Too easy!
âtill next time!
TNP đ
So you have a heap of headings in your document. One way to make communicating with others about your document a whole lot easier is to add numbers to each of your headings.
You know what I mean⌠âJohn, prescription take a look at section 4.2 and let me know what you think!â
Well it is really easy to add numbers to your headings in Word 2007 â as long as you have used your heading styles properly!
All you need to do is:
1) Make sure you are on the âHomeâ tab in the Ribbon
2) Look for the âParagraphâ group
3) Look for the âMulti-Level Listâ button. You will find it beside the âNumberingâ button â chances are it is the third from the left in the top row. Click on that button
4) Select your preferred heading numbering style from the list library.
There you have it, internist
some awesome looking numbered headings, and a lot less headaches!
âtill next time!
TNP đ
Is your business going through a re-organisation? Maybe there is a new team, sildenafil
or an old team has suddenly disappeared? If so, ed
it is time to update your organization chart!
So how do you create an organisation chart using Visio 2007?
1) Click on the âFileâ menu
2) Move your mouse over âNewâ, then
3) Move your mouse over âBusinessâ, then
4) Click on âOrganization Chart Wizardâ (click on either Metric or US Imperial depending on where in the world you live
This starts the Visio 2007 Organization Chart Wizard. There are a few steps to go through before you will have a compete org chart though â lets take a look!
1) If this is the first org chart you have created in Visio â make sure you select âInformation that I enter using the wizardâ and click âNextâ
2) If you have Excel, select âExcelâ and then put in the file name for where you want to store the data behind your org chart. Click on Browse to find the folder you want to save the file in, type in the file name you want
3) Click âNextâ
4) Excel will open up a workbook with some dummy data. Using the format in the workbook, enter the data for your org chart
5) Save the excel workbook when you are done, and then close Excel.
6) On the next page of the Organization Chart Wizard, select how you would like the org chart to be formatted if you have too many people to fit on one page. The easiest option to start with is simply let the wizard to automatically break it across pages. Make sure that option is selected, and click âFinishâ
There you have it â your brand new org chart! The best part is that now that it is built of data stored in excel, all you need to do is update your spreadsheet, re-run the Visio 2007 Org Chart Wizard, and you will have a very fresh version of your organization chart.
âtill next time!
TNP đ

Hi there, this
Just thought I would share with you some fantastic news I received the other day. Paul Woods â the guy who created / is The New Paperclip was recognised by Microsoft for technical leadership with a Most Valuable Professional award.
Specifically it was an award in the Business Productivity / Word category
So what is a Microsoft Most Valuable Professional Award?
From the MVP website:
âMicrosoft is pleased to recognize and award its Most Valuable Professionals (MVPs). We present the MVP Award to thank individuals for their exceptional contributions to technical communities worldwide. When a community participant sees an MVP in a technical community, abortion
whether in a newsgroup, decease as a user group host, a conference speaker, or a respondent in forums, that community participant can be confident that the information shared by the MVP will be of the highest caliber and will help every user make the most of the technology.â
Pretty neat huh!
So what does it mean for The New Paperclip? More great tips and tricks for Office 2007, and soon Office 2010!
âtill next time!
TNP đ
So you might be unlucky enough to be looking for a new job, there or maybe you are just sick of your current job and need a change! Whatever your situation, there is one sure thing that you will need to think about â your resume/cv!
Creating your resume or curriculum vitae in Word 2007 is not as hard as you think. There are literally dozens of very good looking templates you can use which take all the hard work out of creating your latest and greatest resume.
So how do you access the Resume Templates in Word 2007?
- Click on the office Orb in the top left hand corner
- Click on "New"
- In the "New Document" window that appears, look to the left and you will see a big long list of templates to choose from. Scroll down and click "Resumes and CVs"
- Click on the type of resume you are after – Basic, Job Specific, or Situation Specific
- Select the one you want to use, and then click "Download"
And then start customising your resume with your own information!
Note, for this to work you will need to be connected to the internet as the templates are actually stored on Microsoft Office Online.
âtill next time!
TNP đ