Protect a Sheet in Excel


Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today



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 😉

Leave a Reply

Your email address will not be published. Required fields are marked *