How to print in Word 2013

So your masterpiece is complete and you want to print it to share with the world?  It is easy to print your document, poster or other Word 2013 creation.

  1. Click on the “File” menu
  2. Click on “Print”
  3. Take a look at the print preview and make sure it looks ok, and if it does…
  4. Click on the big “Print” button

’till next time!
TNP 😉

Add a page number in Word 2013

So you want to add a page number to the footer of your document in Word 2013?  Simple!

  1. Click on the “Insert” tab in the ribbon
  2. Look for the “Header & Footer” group (about 2/3 of the way across the menu)
  3. Click on “Page Number”
  4. From the drop down menu, select where you want the page number to appear – either the top of page, bottom of page, page margins, or in the current position
  5. Then select your page number style (there are plenty to choose from – including plain ones which you would be used to from previous versions of Word)

If you search through the styles, if you just want a simple Page X of Y, you will find it there too.

’till next time!
TNP 😉

 

How to Undo in Excel

So… you have been working on that spreadsheet for hours and all of a sudden you deleted the wrong thing.  Now you need to undo what you did in Excel 2013? Here is how to do it:

  1. Look in the top left hand corner of the Excel 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 – your formulas are still safe!

’till next time!
TNP 😉

Bullets in Word 2013

So you want to structure some text in Word 2013 in a nice easy way for your reader to… well… read.

Bullets are a great way of doing just that.  To use bullets simply

  1. Make sure you are on the “Home” tab
  2. Look for the “Paragraph” group
  3. Click on the top button on the left hand side, which looks like some bulleted text
  4. Start typing your bulleted list!

If you want to take some text and turn it into a bulleted list, simply select the text and then follow the process above!

’till next time!
TNP 😉

Create a look up list in Excel 2013

Ever wanted the users of your spreadsheets to fill in cells using only a certain number of options.  Wouldn’t it be fantastic, instead of making people remember the correct names (and spelling) of each… that we could just give them a nice little list of options to pick from to populate the cell?

Well in Excel 2013, that is really easy!  Here is how to go about it.

Using Data Validation to create look up lists in Excel 2013

1) Click on the cell you want the look up / drop down list to appear in

2) Go to the “Data” tab in the Excel 2013 ribbon

3) Look for the “Data Tools” group

4) Click on “Data Validation”… then click on “Data Validation” from the drop down menu

5) In the box that appears, on the “Settings” tab, set the Validation criteria to allow “List”

6) In the “Source” text box, type in the options you want to make available (and remember to separate them with a comma!)

7) Click “OK”

Easy as that!

’till next time!
TNP 😉

Get rid of the annoying backwards P in Word

Don’t you hate it when you can see all those “backwards Ps” all throughout your Word document.  There are probably lots of other marks in your document too… like arrows, dots and more.

These are what we call paragraph marks and formatting symbols – or what others sometimes call “codes”.  You can show or hide these marks, symbols and codes really quickly.  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. Click on the icon that looks like the “Backwards P”

Or next time you can use the shortcut key which is CTRL+SHIFT+8.

’till next time!
TNP 😉

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 😉