Wednesday, December 29, 2010
Friday, December 3, 2010
Sort Data in Excel
Sort your month and day names chronologically — not alphabetically (2000/2002/2003/2007)
If you sort data based on a column of month or weekday names, Excel sorts the data alphabetically. Chances are you'd rather sort the information in chronological order. Fortunately, it's easy to do so.
To change your sort to a chronological order:
- Select any cell in the column of month or weekday data.
- Choose Data | Sort from the menu bar to display the Sort window.
- Click the Options button. (In 2007, choose Custom List from the Order dropdown list.)
- Select the appropriate custom list using the First Key Sort Order dropdown list.
- Click OK twice to dismiss the open dialog boxes and apply the sort order.
Print a Blank Calendar
Print a blank calendar from Outlook (2000/2002/2003)
A blank Calendar is helpful in several situations. Perhaps you're attending a project planning meeting and need a Calendar to flush out important project milestones. You don't want to deface your own calendar with all the information, so print a blank Calendar from Outlook instead.
To do so, first create a blank calendar as follows: Click on the Calendar icon in the Navigation Pane (click on the Calendar folder in the Folder List in 2000 and 2002). Next, click the New button's arrow and select Folder. Give the folder a name, such as Blank Calendar, in the Name text box of the Create New Folder text box. Select the Calendar folder from the Select Where To Place The Folder list box, if necessary. Then, click OK.
Now we’ll print the calendar: In 2003, select the Blank Calendar check box from the My Calendars section of the Navigation Pane and deselect all others. In 2000/2002, click on the folder in the Folder List in 2000 and 2002. Choose File | Print from the Outlook menu bar. Select a style from the Print Style list box, and enter dates in the Start and End text boxes in the
