May 05 2010

Converting Tabbed Text to a Table in Word 2007
Converting a Table to Tabbed Text in Word 2007
Reveal Formatting in Word 2007
A Format Painter Shortcut for Word
PowerPoint Tech Tip - Deliver a Presentation on Two Monitors
Using a Keystroke to Delete Cells in Excel
Use Excel’s AutoFill Feature

Converting Tabbed Text to a Table in Word 2007 Use SHIFT+ENTER to open the menu (new window).

Although you can use tabs to arrange text in columns and rows, you’ll have a wider range of formatting possibilities if you put your text in a table instead. If your text is already tabbed, you can easily convert it into a table by following these steps:

  1. Select the tabbed text you want to convert.
  2. From the "Insert" tab on the ribbon, select "Table," then "Insert Table."

Converting a Table to Tabbed Text in Word 2007Use SHIFT+ENTER to open the menu (new window).

If you want to reverse the process above, follow these steps:

  1. Select the table.
  2. A contextual "Table Tools" menu will appear at the right-hand side of the ribbon. From the "Layout" tab, click the "Convert to Text" button.
  3. Select "Tabs" (if necessary), and then click "OK."

Reveal Formatting in Word 2007 Use SHIFT+ENTER to open the menu (new window).

To see the paragraph, font, and section formatting of any text in your document, press "Shift+F1" and click the text. The "Reveal Formatting" pane will appear on the right-hand side of the screen with the formatting information for the paragraph, font, and section. Press "Shift+F1" again to close the pane.


A Format Painter Shortcut for WordUse SHIFT+ENTER to open the menu (new window).

You can use the following shortcut to copy the formatting of one selection to another in Word:

  1. Select the text with the formatting you want to copy.
  2. Press "Ctrl+Shift+C."
  3. Select the text you want to copy the formatting to.
  4. Press "Ctrl+Shift+V."

You can continue to use "Ctrl+Shift+V" to "paint" selections with the formatting you copied – Word will remember that formatting until you copy another.

PowerPoint Tech Tip - Deliver a Presentation on Two MonitorsUse SHIFT+ENTER to open the menu (new window).
When you are delivering a PowerPoint presentation, why not use two monitors instead of one? You can display your slides with notes on one monitor (your desktop/laptop computer), and project full-screen slides on a second monitor (e.g., a projection screen) by using "Presenter View."

Important: In order to use Presenter View, the computer you are using for the presentation must have multiple-monitor capability. Most desktop computers require two video cards for multiple-monitor capability, and many laptop computers have this capability built-in.

Click on the links below for details on using the Presenter View feature.

For PowerPoint 2007:
http://office.microsoft.com/en-us/powerpoint/HA100673831033.aspx?pid=CH100668261033

For PowerPoint 2003:
http://office.microsoft.com/en-us/powerpoint/HA010565471033.aspx


Using a Keystroke to Delete Cells in ExcelUse SHIFT+ENTER to open the menu (new window).

Press "Ctrl + -" (the hyphen key) to delete the current cell or selection. When the Delete Cells dialog box appears, you can choose to shift neighboring cells up or to the left, or delete the entire row or column. Click "OK."

To delete an entire column or row, select it and press "Ctrl + -" (hyphen key). The column or row is deleted immediately.


Use Excel’s AutoFill FeatureUse SHIFT+ENTER to open the menu (new window).

Excel’s "AutoFill" feature can complete a series of numbers or dates for you based on the starting values you supply. For example, suppose you want to fill some cells with the number series 1, 3, 5, 7, 9, and so on. Here’s how you’d do it:

  1. In any cell, type the number 1 and press "Enter."
  2. In the cell below or to the right, type the number 3 and press "Enter."
  3. Select both cells.
  4. Click on the AutoFill handle (small black square in the lower right-hand corner of the cell containing the number 3) and drag it down or to the right a few cells. Excel fills the cells with the series 1, 3, 5, 7, 9, and so on, following the example in the first two cells.


Suppose you want to list the dates of all of the Fridays from May to July. To do this, follow these steps:

  1. Type the date of the first Friday (5/7/2010) in any cell.
  2. In the cell below or to the right, type the date of the next Friday (5/14/2010).
  3. Select both cells.

Using the AutoFill handle, drag down or to the right until you've filled the next 11 cells.