Vishwini's

Copy the formatting (attributes) of one or more cells and apply them to another cell or range Once you learn to use the Format Painter tool (which looks like a little yellow paintbrush on the Standard toolbar), you’ll wonder how you ever got by without it. To format a cell (or cells), select a cell (or cells) that are formatted the way you like and click Format Painter. Then, click and drag to apply that formatting to another cell (or range of cells). Here’s an example to illustrate how Format Painter works. Start by manually formatting cell A1 as Times New Roman 9, bold, and underlined and then use the Fill Color tool to make the background of the cell yellow. With cell A1 selected, click Format Painter. You’ll notice that Excel displays a paintbrush next to the cursor. While that paintbrush is visible, all you have to do is click (and/or drag) to apply all of the attributes from cell A1 to any other cells. This shortcut saves time because you don’t have to manually reapply the font a

By default, the Work Week calendar view displays the five days of the traditional business week, Monday through Friday. To include Saturday and Sunday in that view, choose Options from the Tools menu. In the resulting Options dialog box, click Calendar Options in the Calendar section. In the Calendar Options dialog box, check Sat and Sun in the Calendar Work Week section. Then, click OK twice to return to the Calendar. You don't have to view a seven- or traditional five-day work week. Check the days of the week that apply to you for a custom work week view. For example, if you work Wednesday through Sunday, you can make those selections to build a view that reflects your schedule.

Quick Flags help you categorize your messages, usually by some level of importance or by task. For instance, you might use a red flag to mark messages that need a quick response and a blue flag to mark messages on which you've acted and are waiting for a response. The problem with Quick Flags is that there's no way to customize their descriptions. Outlook identifies them only by color. You can't change the name of Red Flag to Critical. Remembering what each color represents can become burdensome. An easy way to remember what each flag represents is to create a custom toolbar that displays each flag with text that means something to you. Fortunately, the process is easy: 1. From the Tools menu, choose Customize. 2. On the Toolbars tab, click New and name the new toolbar appropriately (for instance, you might name it "Flags") and click OK. 3. In the Customize dialog box, click the Commands tab. 4. Select Actions from the Categories list box. 5. Next, drag the approp

When you reply to an e-mail, Outlook stores a copy of that message in the Sent folder. If you're like me, your Sent folder has thousands of messages. If you need to find a specific message later, you must sort through all those messages, and that takes time. Instead, store your replies with the original message. For instance, suppose you automatically route all your messages from your boss into a folder named, appropriately enough, MyBoss. If you want Outlook to store your replies in MyBoss with the original messages, do the following: 1. From the Tools menu, choose Options. 2. On the Preferences tab (which should be selected by default), click E-mail Options in the E-mail section. 3. Click Advanced E-mail Options at the bottom of the Message Handling section. 4. In the Save Messages section, select the In Folders Other Than The Inbox, Save Replies With The Original Message check box and then click OK three times to return to Outlook. Outlook will apply this setting to all of your

For a variety of reasons, some of us end up printing e-mail messages. If you print most of your messages, or all of your messages from a specific source, opening each message to print it manually interrupts your work. Setting a rule to print the desired incoming mail might be more efficient. To do so: 1. From the Tools menu, choose Rules And Alerts. 2. Click New Rule on the E-mail Rules tab. 3. Click Start From A Blank Rule at the top of the resulting Rules Wizard dialog box. 4. In the Step 1 box, highlight the Check Messages When They Arrive option (it should be the default) and then click Next. 5. In the Step 1 box, select the Where My Name Is In The To Box check box (or whatever option applies, if you don't want to print all you messages) and click Next. 6. In the Step 1 box, click the Print It option and click Next. 7. At this point, you can identify exceptions to the rule, but we won't do that here. Just click Next, and then Finish, Apply, and OK to return to Outlook. Afte

If you use the Notes feature to jot down questions, ideas, or quick reminders, you might also want to print them occasionally. By default, Outlook prints each note on a separate page, which might or might not be what you want. You can force Outlook to fill each page, to save paper or to keep related notes together. Select the notes you want to print and then choose Print from the File menu. In the resulting Print dialog box, deselect the Start Each Item On A New Page check box in the Print Options and click OK. If the option is disabled, you're using HTML format. You must switch to plain or text format to enable this option. To do so, choose Options from the Tools menu. Click on the Mail Format tab and choose Plain Text from the Compose In This Message Format option's drop-down list. Then, click Apply and OK. Repeat the print instructions, and you'll find the Start Each Item On A New Page option is enabled. After printing the notes, just retrace your steps to reset your for

When entering the start and due dates for a new task, you don't have to type the entire date. If a date is in the current month, just enter the day and Outlook will enter the rest of the date for you. For instance, if the current month is March and you enter 14, Outlook assumes you mean March 14 of the current year and fills in that date. When a date isn't in the current month, you can still save a few keystrokes by entering the month and day. Outlook will fill in the year as follows: If the month and day haven't occurred in the current year, Outlook uses the current year. If the month and day have passed, Outlook uses the next year.

Go to Calender in Outlook and select print from the File menu. Select monthly style in the print style option When selecting a range of calendar months to print, you can use shorthand instead of entering a literal end date. For instance, if you want to print four calendar months, you can enter any date as the start month and then enter 4mo, instead of a literal date, for the end date. Outlook will interpret your shorthand and print accordingly. Most of us can type 4mo faster than we can count four months into the future.