Friday, July 25, 2008

Flag Email for Follow-up in Outlook

Assign flags to your email messages in Outlook to remind yourself to follow up on an issue. You can also use flags to categorize messages in your inbox. There are six colors - red, blue, yellow, green, orange, and purple - that can be used to mean different things. Message flags are displayed in the last column of the Inbox view.

Flag icons are displayed on the right side of each message.
The flag drop-down menu appears when icon is right-clicked.

You can use message flags to do the following:

  • To flag a message with a particular color, right-click the flag that corresponds to the message and then select the flag color.
  • To flag a message as complete, right-click the message, and then click Flag Complete.
  • To sort your messages by color, click the flag column heading.
  • To clear a flag from a message, right-click the mesage, and then click Clear Flag.

Tuesday, July 8, 2008

Switch Excel Columns to Rows

Have you ever wanted to change a column of data into a row in Excel?
Here's how you do it:

1. Open the spreadsheet you need to change.
2. Click the first cell of your data range such as D1 (Third Quarter in figure 1).
3. Shift-click the last cell of the range. Your selection should highlight.
4. Right click and select Copy from the right-click context menu (figure 1). Or go to the Edit menu and select Copy.

figure 1

5. Click on the Cell you want to paste the range of data. We will use A7.
6. Right click cell A7. From the Right-click context menu, select Paste Special... (figure 2).

figure 2

7. The Paste Special dialog should appear (figure 3).
8. Click the checkbox for Transpose.

figure 3

9. ..Click OK.
10. Your data from D1:D5 is now displayed in Row(A7:E7) (figure 4).

figure 4

You can go from columns to rows, or rows to columns using the same procedure.