Archive for the ‘MS Office’ Category

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.

Continue reading »

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 [...]

Continue reading »

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.

Continue reading »

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 [...]

Continue reading »

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 [...]

Continue reading »

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 [...]

Continue reading »