Create PowerPoint slides designed specifically for A4 or Letter printing

Usually PowerPoint presentations are built to be delivered on-screen.  Using the print options you can create handouts and notes pages that you can then print out and hand to your audience. 

But did you know that you can use PowerPoint to design presentations built specifically to be delivered in the print format.  One slide per A4 or Letter page (and not a cropped or zoomed version of an onscreen slide)

To do so, story all you need to do is change the page size of the PowerPoint slides in your deck.

1) Click on the “Design” tab

2) Click on “Page Setup” in the “Page Setup” group on the left hand side of the ribbon

3) In the “Page Setup” window, remedy in the drop down box “Slides sized for:” select your preferred paper size

This is a great way to design slides specifically for transparencies or over-head projectors as well.

‘till next time!
TNP 😉

Freeze the Top Row in Excel

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 😉

View Gridlines in Word 2007

Gridlines are a great tool to use if you have a number of objects in your Word document, pills and want to ensure proper alignment between them all.

To turn on gridlines (which appear in the background of your document, drug and do not get printed):

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

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

3) Click on “Align”

4) Click on “View Gridlines”

 

To turn gridlines off again, just repeat the process above.  You will notice that this is another option when you click on “Align”, called “Grid Settings”  Using this feature you can customise how the grid appears and impacts in your document.  For example, you can ensure that objects snap to each other, the spacing of the grid, and whether the grid uses your margins or not.  Very good if you want fine control over the placement of objects in your document.

‘till next time!
TNP 😉

Change Slide Orientation in PowerPoint 2007

Do you want to create a slide that is Portrait, order 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, order just repeat the process above, but instead of clicking “Portrait” at step 4, click on “Landscape”.

 

‘till next time!
TNP 😉

Widow/Orphan control in Word 2007

Those of you who have been desktop publishing for a while will know what Widow/Orphan control is. 

For those that don’t… imagine that you are writing a paragraph, buy and the last line of the paragraph doesn’t quite fit on one page, so it jumps to the next page.  That would look pretty silly right? 

Well Widow/Orphan control is the way that Word makes sure that the exact situation described above does not happen.  By default Widow/Orphan control in Word 2007 will be turned on, but like everything in Word, you can toggle it to meet your needs.

To toggle Widow/Orphan control in Word 2007:

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

2) Look for the “Paragraph” group

3) Click on the little square and arrow icon in the bottom right hand border of the “Paragraph” group

4) Click on the “Line and Page Breaks” tab of the box that appears

5) In the “Pagination” group, uncheck (or check) the “Widow/Orphan control” checkbox

 

‘till next time!
TNP 😉

Change the default width of cells in Excel

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, pill 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 😉

Reset a slide in PowerPoint 2007

Don’t you hate it when you accidently click on a text box on your slide and move it?  Before you know it, order 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 😉

Insert a new blank page in Word 2007

Do you want to quickly insert a blank page into your Word 2007 document?  Instead of hitting enter 40 times, pilule why don’t you use the Insert Blank Page button?

All you have to do is:

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

2) Look for the pages group – on the left hand side

3) Click on “Blank Page”

 

Now you will see a blank page appear in your document where your cursor was.  To add multiple blank pages, just keep clicking that “Blank Page” button!

‘till next time!
TNP 😉