Paste Text using the INSERT key

You can use the INSERT key as a handy paste shortcut, do the following:

1. Click “Tools”, selecting “Options”.
2. When the “Options” multi-tabbed dialog box appears, click the “Edit” tab.
3. Check “Use the INS key for paste”.
4. Click “OK” to close the dialog box.

Creating summary slide with hyperlinks in Powerpoint

After finishing your Powerpoint presentation, you can create a slide that lists the main sections of your presentation. With an agenda slide, you can jump to a related section in your presentation and then automatically return to the agenda slide. Heres how:

Creating Summary slides
1. Open your presentation
2. Go to View / Slide Sorter
3. Select the slides to be included in your summary. (Use the Shift key for multiple slide selection)
4. Click the Summary Slide button (icon with 3 little slides with an arrow pointing to a bigger slide)
4. PowerPoint will then create a summary slide from all the “Titles” of the slides you selected. It will be placed in front of the first slide that you selected.

Creating Hyperlinks
To create a hyperlink from a bulleted item after creating the summary slide:

1. Switch to Slide View (View / Slide)
1. Select the bulleted item from your summary slide
2. Click Slide Show / Action Setting
3. Under the Action setting dialog box, choose Hyperlink To
4. Select Slide under the dropdown menu
5. Choose the slide title that you want to jump to

Splitting an Excel workbook among several printed pages

To split an Excel workbook among several printed pages:

1. Place your cursor in the first column of a row that you want moved to the next page.
2. Goto Insert / Page Break.
3. A dotted line will appear above the selected cell’s row, signifying that the row is now moved to the next printed page.

Displaying explanatory text on mouse-over in Powerpoint

To display an explanation of an item when mousing over it in Powerpoint:

1. Add your textbox and type the text.
2. Select the textbox.
3. Right click the textbox.
4. Goto Insert / Hyperlink and click on the Bookmark button.
5. Select your current slide in the current presentation.
6. Click on the Screen Tip button and type in your definition.

Portrait and landscape orientation in the same Word file

To employ both portrait or landscape orientation in the same Microsoft Word file:

1. Select the pages or paragraphs that you want to change to portrait or landscape orientation.
2. On the Page Layout tab, click Margins.
3. Click Custom Margins.
4. On the Margins tab, click Portrait or Landscape as orientation.
5. In the Apply to list, click Selected text. Click OK.

Placing multiple charts on an Excel chart sheet

To place several charts on an Excel chart sheet:

1. Click an empty cell, and press F11.
2. Change the default chart name to ChartSheet2.
3. Select the first chart you want to move to the chart sheet, and go to Chart / Location.
4. Select As Object In, and choose ; from the drop-down list.
5. Click OK.
6. Repeat Steps 3 through 5 for the other charts you want to move.