Find and Replace in Word 2013

If you need to replace a word that occurs once, twice, or a hundred times in your document with another word in Word 2013, you want to use the “Find and Replace” feature.

To do it there are two different options

  1. Use the shortcut key – “CTRL+H”.  This will open the Find and Replace dialog box, simply type in the word you want to replace in the “Find What” box, and the word you want to replace it with in the “Replace with” box.  Then click “Replace” or “Replace All”
  2. The other option is to use the ribbon menu.  Make sure you are on the “Home” tab, then look at the far right hand side of the menu.  Click on “Replace”, then follow the instructions above

Simple!

’till next time!
TNP 😉

How to undo in Word 2013

So… you have made a big mistake, and now you need to undo what you did in Word 2013? Here is how to do it:

  1. Look in the top left hand corner of the Word 2013 screen – above the File menu.  You will probably see a few small icons there.  Look for the arrow pointing backwards – that is the undo button.
  2. Click on it to undo what you just did
  3. If you want to undo a few steps, you can click on the little drop down arrow on the button, and you can undo the last 20 or so actions you have done

There you go – no need to panic!

’till next time!
TNP 😉

 

Sort text alphabetically in Word 2013

So you have a list of words in Word 2010 or Word 2013 and you want to sort them alphabetically… but don’t know how?  Well it is a lot simpler than you think!

  1. Select your list – it could be a whole heap of lines, paragraphs, or bullet points
  2. Make sure you are on the “Home” tab in the ribbon
  3. Look for the “Paragraph” group
  4. Click on the button which has an “A” on top of a “Z” with a arrow pointing down.  This will open the “Sort text” dialog box
  5. If you want it in alphabetical order, just click OK, otherwise… click on “Descending”, then OK

There you have it – an alphabetically sorted list in Word!

’till next time!
TNP 😉

Remove the space at the end of each paragraph in Word 2013

Don’t you just hate that annoying space that Word adds at the end (or beginning) of every paragraph in your document!  Well there is a quick and easy way to get rid of it!

  1. Select the paragraphs that you want to remove the space from
  2. Make sure you are on the “Home” tab in the ribbon
  3. Look for the “Paragraph” group
  4. On the second row of the “Paragraph” group there will be a drop down button that has an up and down arrow on it – this is the Line and Paragraph spacing options button.  Click on it.
  5. Click on “remove space after paragraph”

If you want to reverse what you just did, simply repeat the process, but instead of clicking on remove space after paragraph, click on “add space after paragraph”.

’till next time!
TNP 😉

Change line spacing in Word 2013

So you want to space out (or shrink) the amount of space between your lines in Word 2013 (or Word 2010, because it is the same!).  Well here is how:

  1. Make sure you select the text you want to change the line spacing of (if you want to change it for the whole document, press CTRL+A to select everything)
  2. Make sure you are on the “Home” tab in the ribbon menu
  3. Look for the “Paragraph” group (its the third one along)
  4. On the bottom row you will see a button which has an up and a down arrow beside what looks like a paragraph.  If you hover your mouse over it, a little pop up will appear that says the button is “Line and Paragraph Spacing”.  Click on that button
  5. You will have a number of different options to choose from – 1.0 (Single line spacing), 1.15 (the default line spacing), 1.5 (one and a half line spacing), 2.0 (double line spacing), 2.5, and 3.0.
  6. If those options don’t suit you, click on “Line Spacing Options” to access fine grained control over your line spacing

’till next time!
TNP 😉

 

Add a signature to your email in Outlook 2013

So you (or your IT people) have just installed Outlook 2013 at work and you need to set up your email signature?  Well it is pretty easy, just follow these steps…

  1. Click on “file”
  2. Click on “options”
  3. In the left hand column of the “Outlook options” dialog box, click on “Mail”
  4. Click on the “Signatures…” button which is the third one down on the right hand side – this will open the “Signatures and Stationery” dialog box
  5. Click “New” to create your new signature.  You can either copy and paste your old signature from a previous email you have sent, or create a new one from scratch.
  6. Once you are happy with your signature, click “Save”

Did you know that you can also tell outlook whether to include your signature or not on new messages, replies and forwards?  Just set your default signature from the drop down boxes on the right hand side of the “Signatures and Stationery” box.

’til next time!
TNP 😉

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, 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”, “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 😉

Turn off (or on) email notifications in Outlook 2013

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, click on “Mail” in the left hand column
  4. Look for the section called “Message Arrival”.  If you want to turn all notifications off, 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 😉

Add a Quick Print button to Word 2010

Do you want to quickly print your Word 2010 document without having to navigate your way through the menu every time?

Well did you know you can add a “Quick Print” button to the “Quick Access Toolbar” in Word 2010?

For those who don’t know, sovaldi the Quick Access Toolbar (or QAT) is the little icons which you can find in the top left hand corner of any Office 2010 application.

By default you will find Save, seek Undo and Redo – but you can add lots of other buttons, including Quick Print – which prints the current document with the default printer settings.

To add Quick Print to the Quick Access Toolbar in Word 2010

1) Click on the little downward pointing arrow above the Home or Insert tab in Word 2010

2) From the menu that pops up, click on “Quick Print”

Now you will see a little printer icon with a tick on it – that is your quick print button.  Any time you want to print using the default printer settings – all you need to do is press that button.

So fast and so simple!!!

‘till next time!
TNP 😉

Track Changes in Excel 2010

You might be used to turning on track changes in Word to see what others have done to your document – but did you know you can track changes in Excel as well?

To highlight the cells where changes have taken place, doctor do the following

1) Click on the “Review” tab in the ribbon in Excel 2010

2) Look towards the right hand side of the ribbon and click on the “Track Changes” button

3) Click “Highlight changes”

A new menu box appears in which you can select some options as to how Excel tracks the changes.  Make the selections as you like, then click ok.

To accept or reject the changes someone made, click on the “Track Changes” button again, then click “Accept/Reject Changes”

‘till next time!
TNP 😉