How to Initiate a Chat Session from Within Groove by Using Office Communicator

Initiate a Chat Session from Within Groove by Using Office Communicator
When you are running Microsoft Office Groove 2007 and Microsoft Office Communicator 2007 or 2005, you can view the awareness states (such as online, busy, or away) of your Communicator contacts directly from the Groove Launchbar or a Groove workspace. When a contact is available, you can right-click to initiate a Communicator real-time chat or phone call with that contact directly from the Groove interface.

How to Set the Print Area in Microsoft Office Excel

Setting the Print Area in Microsoft Office Excel
Have you ever wanted to print only certain rows or columns from a spreadsheet? Here’s how:
1. With a spreadsheet open, select all the rows or columns that you want to print.
2. On the Page Layout tab, in the Page Setup section, click Print Area, and then click Set Print Area.
3. Click the Print icon on the toolbar, or click the Office button, point to Print, and click Print. Only the required content gets printed.

How to Use the Status Bar to Show Range Data in MS Excel

Use the Status Bar to Show Range Data in MS Excel
In Microsoft Office Excel 2007, when you select a range of numbers, three data counts (Average, Count, and Sum) appear automatically on the status bar. By right-clicking the status bar, you can customize the parameters that the bar displays. There are plenty of parameters to choose from, including minimums and maximums

How to Take Notes in MS OneNote

Take Notes in MS OneNote
Getting started in Microsoft Office OneNote is easy—just click a page and start typing. Unlike in Microsoft Office Word, you can click anywhere on a page to create a new note "container." You can easily reorganize this container by clicking the outline of the note and dragging it elsewhere on the page, or merging it with other containers of notes.

How to Set Up the Calendar Quickly in MS Outlook

Set Up the Calendar Quickly in MS Outlook
You can customize your Microsoft Office Outlook calendar quickly. When viewing the calendar, press ALT and the number of days that you want to show (for example, ALT+3). Outlook will redraw the calendar to show the selected number of days.

How to Let Your Audience Drill Down to Excel Data in MS Office VIsio

Let Your Audience Drill Down to Excel Data in MS Office VIsio
1. Select the Microsoft Office Excel table that you want to import to your Microsoft Office Visio diagram. On the Ribbon, under Export, click Create Diagram.
2. In the Add Total area of the PivotDiagram panel, select the number of columns that you want to include in your Visio diagram.
3. Select the diagram in your Visio presentation for which you want to create a drill-down facility, and then select the category for your drill-down levels.
4. Add shapes to the categories.
a. Select your diagram, and then click the Apply Shape button in the PivotDiagram panel.
b. Select the shape you require, and then click OK.
5. Filter the data by clicking Configure Column on the Category menu, and then clicking the arrow next to the category name.

How to Modifying Data Types in MS Access

Modifying Data Types in MS Access
To view or change the data type:
1. Click a cell.
2. In the Datasheet contextual tab, the Data Type and Formatting section displays the data type.
3. To change the data type, in the Data Type box, click the arrow, and then select the type you want. (Note: You may need to retype the value in your cell or cells if the type is not compatible.)
4. In the Format box, click the arrow to format how the data is displayed.
5. Select Is Required if you need to make this field mandatory. To make table and field definitions easier, Microsoft Office Access has a set of predefined templates.

How to open or read a .daa file extension

.daa is a file extension  that is created by PowerISO Software. TO open these files you must download this software and install it on your PC. Get more information here about this extension or visit the site here .
This Supports
1. UIF file.
2. Windows Vista.
3. On-the-fly burning.
4. Apple DMG file.
5. Multiple languages.
6. Command-line parameters.

How to use Structured References in 2003 to 2007

2003 to 2007 Structured References
Working with formulas and functions has not always been the most intuitive process. In Microsoft Office Excel 2003, multiplying gross revenue by the profit margin might mean typing something like =B7*E14. In Microsoft Office Excel 2007, structured referencing enables you to use the column headers in table data to build your formulas. Instead of cryptic cell locations, you can simply multiply =[Gross Revenue]*[Margin].

To use structured referencing, you first need to format your data as a table.
1. Click Format as Table in the Styles section of the Home tab.
2. Select the My table has headers check box.
3. After you have a table, click the cell where you want to insert the formula, and then type the left bracket ([).
4. Select the column that you want to use from the list that appears, press the TAB key, and then close it with the right bracket (]).
5. Repeat as you build out your formula.

How to Create or Populate Lists on a SharePoint List

Quick Ways to Create or Populate Lists on a SharePoint List
1. Start Microsoft Office Access and open a database by clicking the New Database icon or selecting an existing database.
2. Create a new list.
a. Click Create, click SharePoint lists, and then select whichever list is appropriate.
b. Enter the site address of the Microsoft SharePoint site that you want to use, and then give the list a name.
3. Fill in the data on the data entry page, or populate it from another source by using the data import features of Access.
4. Save the content in Access.
5. Go to your SharePoint site, click Lists, select the list you just created, and it will already have been published.

How to Add Professional Charts in MS Power Point

Add Professional Charts in MS Power Point
You can quickly add impact to your slides by using the Microsoft Office PowerPoint 2007 charting tools. Use charts to better illustrate, compare, and communicate data to your audience.
1. Go to the Insert tab and click the Chart icon.
2. Select the type of chart that best suits your needs—for example, a line, bar, pie, area, or surface chart.
3. If you have Microsoft Office Excel 2007 installed, the program will open and enable you to change the data behind your chart.
4. Explore and use the options in the contextual tabs under Chart Tools to alter the design, format, and layout of your chart.

How to Save and Reuse Tables in MS WOrd

Save and Reuse Tables in MS WOrd
Do you frequently create the same type of complex table, such as a financial table or tables to use for custom page layouts? If so, you can easily save that table for easy insertion into any document. Just select a completed example of your table and save it to the Quick Tables gallery. Here’s how:

Select the table and press ALT+F3 to open the Create New Building Block dialog box. Type a name for your table, and then in the Gallery list, click Tables. You can set other options as well, such as choosing or creating a category for your table, which will affect where in the Quick Tables gallery it appears.

You can also choose an available template in which to store the table. But if you retain the default Save in location, Building Blocks.dotx, your table will be available for you to use in any document. To access your saved table, on the Insert tab, click Table, and then point to Quick Tables.

How to List Your Contact in the Groove Public Directory in Office Grove

List Your Contact in the Groove Public Directory in Office Grove
If management policies allow it, be sure to list your contact information in the Microsoft Office Groove Public Directory so that other Groove users can find you more easily.
1. From the Options menu, click Preferences.
2. From the Identities tab, select All Contact Information in the Public Groove Directory list.

How to Gain Greater Control over Your Out-of-Office Message in MS Outlook

Gain Greater Control over Your Out-of-Office Message in MS Outlook
If you use Microsoft Office Outlook 2007 with Microsoft Exchange Server 2007, you have the increased capability to set distinct out-of-office messages and to schedule the time period when you want your messages to be sent. You retain greater control over the type of information your contacts receive, helping to ensure that it’s relevant and appropriate to their needs.
1. To open Out of Office Assistant, click Tools, and then click Out of Office Assistant.
2. Explore the options. You can set the date range and time frame, and set one message for people inside your organization and a separate one for people outside your organization. Note: Your organization must be using Exchange Server 2007 for you to see these options.

How to Create a Project Proposal in Office Project

Create a Project Proposal in Office Project
By using proposals, you can define high-level project plans to provide key project information, milestones, and resource demands.
1. In Microsoft Office Project Web Access, click Proposals and Activity Plans in the left Action pane.
2. On the New menu, click Proposal.
3. In the New and Import section, click New.
4. Enter the name of the project, description, start date, finish date, and plan owner. You can also add details about tasks or resources with a resource plan or build team.
5. Click Publish. You have now created a complete Project proposal, pending approval.

How to Find the Correct Format for Excel Formulas in MS Excel

Find the Correct Format for Excel Formulas in MS Excel
You can use Microsoft IntelliSense technology in Microsoft Office Excel 2007 to create formulas. If you want to type a formula in Excel 2007, start by typing the first few characters of the formula (for example, an equal sign and then a letter) to view a list of available formulas. Excel 2007 makes it easy to see all the available types of formulas; the enhanced tooltips in the 2007 Office system provide a detailed explanation of each formula.

How to Use the Ribbon in MS Office System

Using the Ribbon in MS Office System
You can think of the Ribbon of tools and commands in the 2007 Microsoft Office system as your visual gallery to create professional and visually interesting documents.

In the 2007 Microsoft Office system, there are no dialog boxes for formatting text and images. The formatting tools that you are used to using still exist, but they are integrated into the Ribbon. You can use the new tabs to move across various sets of commands or Ribbons that make up the Microsoft Office Fluent user interface.

Additionally, while you are working on a document, the Ribbon automatically presents you with the right formatting tools at the right time and place. It reveals a visual gallery to help you quickly and easily format documents. For example, if you want to change the positioning of a picture you have imported into a Microsoft Office Word document:
1. Double-click the image. A Picture Tools tab opens a gallery that displays options to choose from.
2. Select the Position option from the gallery on the Picture Tools tab to easily define where the photo will sit within the text.

How to Create an Electronic Business Card for Your Signature in MS Outlook

Create an Electronic Business Card for Your Signature in MS Outlook
In Microsoft Office Outlook 2007, you can create and share customized electronic business cards, giving you a personalized way to communicate your information. You can customize your contact information by using electronic business cards that include logos and photos, making contacts more personally relevant and easier to locate.
1. Click the arrow next to New, and then click Contact.
2. Type your personal contact information, such as name, title, company, work phone, and work fax number. Note: As you type, a preview of your business card appears in the business card box in the upper-right corner.
3. Click the Business Card button on the Ribbon to open the Edit Business Card dialog box.
4. In the Card Design section, click the Change button next to Image to add your photograph, company logo, or other pictures. Click the Background Color button to change the background color of your business card. In the Edit section, you can change the size, justification, or color of your text.
5. To use your customized electronic business card as your signature, click the Business Card button on the Message tab of the Ribbon.

How to Send a OneNote Note via Outlook E-Mail

Sending a OneNote Note via Outlook E-Mail 
You can send a Microsoft Office OneNote 2007 note via Microsoft Office Outlook in one of two ways:
If the recipient has Office OneNote 2007, click File, and then click E-mail. Office OneNote 2007 will open your Outlook (2007 or 2003) e-mail client and attach your notes as a .one attachment.
If the recipient does not have Office OneNote 2007, you can paste OneNote notebook content as HTML into the body of an e-mail message in Outlook.

How to Publish Items to Excel Services in MS Excel

Publishing Items to Excel Services in MS Excel
To publish your Microsoft Office Excel spreadsheets (or single items) to Microsoft Office SharePoint Server 2007:
1. With your spreadsheet open, click the Office button, and then click Publish.
2. Click Excel Services.
3. In the dialog box, select a trusted document library location in Office SharePoint Server 2007, and then click Excel Services Options.
4. Select whether you want to publish the entire spreadsheet, individual worksheets, or only selected items (such as charts, tables, or Microsoft PivotTable dynamic views). Click OK.
Your spreadsheet will be saved to the document library, and only your published items will be visible through the Web browser interface

How to Publish Your Calendar to Microsoft Office Online in MS Outlook

Publish Your Calendar to Microsoft Office Online in MS Outlook
Sharing your calendar information is even easier through the new publishing capabilities that Microsoft Office Outlook 2007 provides. Through this free Microsoft Office Online service, you can create dynamic Web calendars that your coworkers, friends, or family can subscribe to and that remain up to date.
1. Click the calendar.
2. Right-click the name of the calendar that you want to publish.
3. From the list, select Publish to Internet, and then click Publish to Office Online.
4. Follow the steps in the wizard to register for the service by using your Windows Live ID credentials.
5. When you’ve registered for the service, you can simply choose the calendar, time frame, and other settings. Outlook creates a sharing invitation that you can use to invite people to subscribe to your calendar.

How to Create Organizational Charts in MS Office VIsio

Creating Organizational Charts in MS Office VIsio
1. Start Microsoft Office Visio.
2. From the Business template section, click Organization Chart.
3. Click Import Organization Data from the Organization Chart menu.
4. Select your data sources. Click Information that's already stored in a file or database, and then click A Microsoft Exchange Server directory.
5. From the list of available fields on the left, select the information that you want to appear on your chart, and then click Add.
6. Click Next. Anything you add on the next page will be added as shape data (that is, not displayed in the diagram, but forming the properties of each of the shapes that do appear).
7. Choose your organization layout. To have Visio automatically display your organization as pages, select the I want the wizard to automatically break my organization chart across pages check box.
8. Select Browse in the drop-down list.
9. From the address book, select the person you want to appear at the top of your organization chart, and then click Finish.

How to use Quick Search in MS Vista

Quick Search in MS Vista
If you need to find a file quickly, the Windows Vista indexed file system makes it easy.
1. Click Start.
2. Type as much information as you know about the file in the text box. As you type, the files that meet your criteria will appear.

How to Customize Your Pictures in MS Power Point

Customize Your Pictures in MS Power Point
You can apply style, shadow, and crop effects to the pictures that you add to your presentations. You can create great-looking effects with just a few clicks.
1. On the Insert tab, click the Picture icon to browse for a picture to add to your slide.
2. After selecting your picture, go to the Picture Tools Format tab to see the available formatting options.
3. Pause on the items in the Picture Styles gallery to preview each of the prebuilt options. If you find a style you like, click it to apply the formatting to your picture.
4. If you want to apply custom formatting, select options from the Picture Shape, Picture Border, and Picture Effects galleries.

How to Apply WordArt Text Effects in MS Power Point

Apply WordArt Text Effects in MS Power Point
You can easily liven up your slide titles and text by using WordArt and Text Effects.
1. Highlight the text to which you want to apply effects.
2. On the Format tab, locate the WordArt Quick Styles gallery.
3. Select a WordArt style if you want to apply a predefined style to your text.
4. Add custom effects like reflection, glow, 3-D rotation, and bevel by using the Text Effects gallery.

How to Create a New Table in MS Access

To Create a New Table in MS Access
Microsoft Office Access 2007 has made creating tables easy by providing a handful of common schemas.
1. On the Ribbon, on the Create tab, in the Tables section, click Table.
2. Type the first value in the cell, just as you would in a Microsoft Office Excel spreadsheet, and then press ENTER.
3. Double-click the column heading to rename the field.

Based on the value typed, Access automatically defines the data type, although it does so differently from a spreadsheet. In Access, each field—a column in your datasheet—is defined by a data type.

How to Use Voting Buttons in MS Outlook

Using Voting Buttons in MS Outlook
You can easily collect information from your coworkers. The redesigned Microsoft Office Fluent user interface makes it easier than ever to use voting buttons to collect information through e-mail. Here’s how:
1. Create a new message in Outlook, or reply to an existing message.
2. On the Options tab, in the Tracking section, click Use Voting Buttons.
3. Click the option you prefer. For additional message options, click Custom

How to Avoid PowerPoint Animations in Office Live Meeting

Avoid PowerPoint Animations in Office Live Meeting
If you’re creating a Microsoft Office PowerPoint presentation that you plan to deliver in Microsoft Office Live Meeting, think twice before spending time on animations and slide transitions. Microsoft Office PowerPoint Viewer will display them, but they occupy a lot of bandwidth; and if you’re recording the meeting, they won’t be preserved.

How to Manage Rules in MS Excel

Managing Rules in MS Excel
To view conditional formatting rules or to perform changes:
1. On the Home tab, in the Styles group, click Conditional Formatting, and then click Manage Rules.
2. Select the rule that you want to view or modify, and then click Edit Rule.
3. Edit the rule in the dialog box, and then click OK.

How to Restore Previous Version of a Recent File in Microsoft Vista

Restore Previous Version of a Recent File in Microsoft Vista
On occasion you make a mistake, and you want to revert to a previous version of a file you have been working on. After System Protection is configured, you can do so with Windows Vista. Right-click the file, and then select the version you want.
Note: System Protection must be configured, and you must have sufficient disk space.

How to Send Information from Outlook to OneNote

Sending Information from Outlook to OneNote
Microsoft Office Outlook 2007 has a Send to OneNote button for inserting relevant content from an e-mail thread into your Microsoft Office OneNote notebook. Click the Send to OneNote button in your Inbox, and both the e-mail thread and metadata such as date, time, sender, and subject will be inserted into the Unfiled Notes section of your OneNote notebook.

How to Work on Large Documents in MS Word

Work on Large Documents in MS Word
In Microsoft Office Word and Microsoft Office Excel, you can split the screen to see two separate parts of a document at once.
On the View tab, in the Window section, click Split, and then click the screen where you want the split to appear. You can then navigate parts of the document separately in each window.

Excel adds both a horizontal and a vertical split to the screen. If you don't want one of them, drag the line up to the top or the left side and drop it at the edge of the screen, where it will disappear.

To return to the single-screen view of the document in either Word or Excel, go back to the Window section and click Remove Split.

How to use RSS Feeds in MS Out Look

RSS Feeds in MS Out Look
Really Simple Syndication (RSS) feeds are an easy way to subscribe to interesting information like world news, sport scores, or blogs. With Microsoft Office Outlook 2007, it’s easy to start adding and reading RSS subscriptions.
1. Click the mail folder called RSS Feeds.
2. Choose a feed that interests you from the RSS Feeds content directory.
3. Outlook prompts you to add this feed to your list. Click OK.
4. Outlook creates a specific RSS subscription folder for this feed below the main RSS Feeds folder.
Note: When using Office Outlook 2007 with Windows Internet Explorer 7, you can keep a synchronized list of subscriptions between the two programs.

How to Apply Conditional Formatting in MS Excel

Applying Conditional Formatting in MS Excel
Conditional formatting is a feature that enables users to apply formatting to cells automatically depending on the value of the cell or the value of a formula. By visualizing data in a graphical way, you can identify trends and exceptions more quickly.

To visualize the value of a cell relative to other cells in the same range:
1. Select a range of cells.
2. On the Home tab, in the Style group, click Conditional Formatting, click Data Bars, and then select a data bar icon.

To classify data into three to five categories separated by a threshold value, use icon sets:
1. Select a range of cells.
2. On the Home tab, in the Style group, click Conditional Formatting, click Icon Set, and then select an icon set.

How to Exchange Contact Information—Sending Your Contact to Others in MS Groove

Exchanging Contact Information—Sending Your Contact to Others in MS Groove
You can send your Microsoft Office Groove 2007 contact to others right from the Common Tasks pane on the Contacts tab in the Launchbar.
1. Click Send My Contact via E-mail.
2. Type the e-mail addresses of the people whom you want to receive your contact.
3. Recipients receive an e-mail message with a hyperlink that automatically adds your contact to their list in the Groove Launchbar.

How to Access Information in One Click by Using Attachment Preview in MS OutLook

Access Information in One Click by Using Attachment Preview in MS OutLook
Accessing mail attachments is often a multistep process that provides no easy way to gain quick insight to that content. With Attachment Preview, you can preview your attachments in one click directly from within Microsoft Office Outlook, saving you time and effort.
1. Click the attachment in the e-mail message or reading pane.
2. Scroll through the document or presentation by using the scroll bar on the right. To return to the e-mail message, click the message box to the left of the attachment.
Note: The presentation or document is a read-only copy. To make edits or comments, you need to save a local version on your computer.

How to Insert and Format Charts in MS Excel

Insert and Format Charts in MS Excel
In Microsoft Office Excel 2007, you will find many new professional-looking charts to help you visualize your data and communicate it more effectively. To insert a chart:
1. On the worksheet, arrange the data that you want to use in a chart.
2. Select the cells that contain the data that you want to use for the chart.
3. On the Insert tab, in the Charts group, click the chart type, and then click a chart subtype that you want to use.

To see all available chart types, click a chart type, and then click All Chart Types. Excel will select the default formatting layout, but you can quickly modify it:
1. On the contextual Design tab, select a chart layout from the gallery to display the legend, axis, and title the way you want.
2. Select a chart style to modify color and effects.

How to Share Charting in 2003 to 2007

2003 to 2007 Shared Charting
Copying and pasting a Microsoft Office Excel 2003 chart into Microsoft Office PowerPoint 2003 is easy. The real challenge is editing the chart after it's part of your presentation, because the charting tools are different between the applications. With the shared charting engine in the 2007 Microsoft Office system, you can use the same charting tools to create and customize your charts in Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, and Microsoft Office Word 2007.

To insert a chart in Excel 2007, click the Insert tab, and then select the type of chart you want from the Charts group. To customize an existing chart, click inside the chart, and then use the contextual Chart Tools command tabs that appear on the Ribbon

How to Use the Quick Access Toolbar in MS Office

Use the Quick Access Toolbar in MS Office
You can add your favorite—or most commonly used—commands to the Quick Access Toolbar in the 2007 Microsoft Office system, so that these tools are always easy to find. You’ll find the Quick Access Toolbar next to the Office button above the Ribbon.

The default commands on the Quick Access Toolbar are Save, Undo, and Repeat. You can add your most-used favorites by clicking the expandable arrow to the right of the Quick Access Toolbar to open the Customize Quick Access Toolbar menu. Here, you can select the set of commands that you want on the Quick Access Toolbar.

To add commands that aren't on the list, click More Commands. If you're adding a lot of new commands to the Quick Access Toolbar, use the Customize menu and click Show Below the Ribbon. This will move your Quick Access Toolbar to below the Ribbon to give it more room to expand.

How to Create SmartArt Diagrams in MS Power Point

Create SmartArt Diagrams in MS Power Point
Microsoft SmartArt graphics make it easy for you to create high-impact, professional diagrams. Instead of spending hours designing your own diagrams, you can use Microsoft Office PowerPoint 2007 to focus on the visual message that you want to communicate.
1. On the Insert tab, click the SmartArt button.
2. In the list of diagram categories, select the type of diagram that you want to add to your presentation.
3. Under Type your text here, type a list of the information that you want reflected in your diagram.
4. Click the Design tab, and then select colors and styles from the available galleries to make your diagram look great.

How to Organize Information with Color Categories in MS Outlook

Organize Information with Color Categories in MS Outlook
Color categories give you a simple, visual way to distinguish items from one another, making it easy to organize your data and search for information.
1. Right-click the box next to an e-mail message.
2. Click All Categories.
3. Assign titles to your color categories, such as personal, work, finance, family, or birthdays.
4. Click OK.
5. Right-click the category box next to an e-mail message and assign a color category to it.
6. Arrange your e-mail list, or search by color categories.

How to use Multiple Level Undo, Change Highlighting, and Task Drivers in MS Office Project

Multiple Level Undo, Change Highlighting, and Task Drivers in MS Office Project


In Microsoft Office Project Professional 2007, project managers can visualize the impact of changes and trace back their steps. To turn the Change Highlighting feature on or off, click the View menu, and then click Hide Change Highlighting or Show Change Highlighting. While the feature is enabled, all levels of tasks affected as a result of a change are highlighted with a color as a visual indicator. Using this feature together with the Multiple Level Undo feature, project managers can do "what-if analysis" by trying a set of changes and then reversing unwanted changes. If further analysis of a task's schedule is needed, the project manager can use Task Drivers on the Project menu to determine the factors (such as task dependency, calendar constraints, schedule date, or vacation time) that are driving a task's start date.

How to Chang Table Styles in MS Excel

Changing Table Styles in MS Excel
To change table style:
1. Click inside the table you’d like to change.
2. On the contextual Design tab, pause on any table style for a live preview, and click when you want to confirm the change (click the arrows in the gallery to view more styles).
3. Make selections in the Table Style Options group to change formatting of the first and last column, to add a Totals Row, or to have banded rows or columns.

How to Keep Organizational Charts Updated in MS Office Visio

Keeping Organizational Charts Updated in MS Office Visio
You can add new people quickly to an organizational chart.
1. Start Microsoft Office Visio, and then click OrgChart Assistant.
2. Click Information Stored, and then click Microsoft Exchange Server.
3. Click Next in the subsequent two dialog boxes.
4. Click Automatically Break Organization Chart, enter the details for the person you want to add to the chart, and then click Finish. Repeat this process for each individual you want to add to your chart.

How to Access Programs Quickly in Vista Explorer

Access Programs Quickly in Vista Explorer
As you settle in to using Windows Vista, you will want to access your most important programs quickly from the Quick Launch bar.
1. Click the Start button.
2. Click All Programs.
3. Find and right-click your program.
4. Click Add to Quick Launch.

How to Edit Lengthy Documents More Efficiently in MS Word

Edit Lengthy Documents More Efficiently in MS Word
To save time scrolling back and forth when you're editing a long document, you can use the keyboard shortcut SHIFT+F5. This shortcut switches back to the area of the document on which you were working previously. For example, if you were working on the tactics part of your plan and moved to edit something in the budget, by pressing SHIFT+F5, you immediately return to the tactics section.

How to use To-Do Bar in MS OutLook

To-Do Bar in MS OutLook
You can check your priorities for the day by looking at the To-Do Bar, where your flagged mail messages and tasks are clearly laid out. To customize the view of your To-Do Bar:
1. Click View, click To-Do Bar, and then click Options.
2. In the To-Do Bar Options dialog box, you can customize how many months are shown and how many upcoming appointments are displayed.

How to Link Office OneNote 2007 and Outlook Contacts in Office OneNote

Linking Office OneNote 2007 and Outlook Contacts in Office OneNote
You can link meeting notes or other content from your Microsoft Office OneNote 2007 notebook to your calendar or contacts in Microsoft Office Outlook 2007. Later, if you need to find information about the meeting or the contact details associated with that person, you can either click the link in Office OneNote 2007 or click the link in your calendar or contacts list in Office Outlook 2007 to access the information saved in OneNote.

How to Remove Comments and Changes from a Document in MS Word

Removing Comments and Changes from a Document in MS Word
Have you ever sent a Microsoft Office Word document that contained comments or tracked changes that you didn’t want visible? Document Inspector eliminates this worry.
1. Click the Office icon, point to Prepare, and then click Inspect Document.
2. By default, all check boxes are selected in Document Inspector. Clear the check box next to any items that you don't want Document Inspector to look for, and then click Inspect.
3. Remove items not for publication. Document Inspector indicates what it finds in your document, so you can choose what you want to remove, and then confidently publish your document.

Some Links

Computer And Technology


1. How To - Computer :- Learn Some tricks for your computer,
know how to change settings,how to use it in a better way

2. Computer Universe:- Everything related to computer happening in this world

3. Download Softwares and Updates :-Want to download any Software

just find here,need any update go and search, Some interesting

Softwares that you like ForEver

4. How To Web Programming :-Any Problem in Web programming ,

or want to learn Programming, Visit Here

5. Code Is God :- Some Coding Tips

6. How To Blogger :-If you want to Start Your own Blog, Or any blog

related help, go and learn 

7. What IS and How To :- Check here for anyhting that you want

to know that “How To Do That” Just Go here and Learn

Entertainment Movies And Songs

1. Download Free Movies :- Download Some movies for Free,

so just go and see if there is any for you


2. Download Hindi Movie Songs :-Here you can Download All
hindi movie songs by movies, Old and New movie songs,
singes, Music Directors and so on

3. Download Old Hindi Songs :-This is for Oldies Lovers,
just check for any old song that you like but you ave don’t


4. Songs By Lata Mangeshkar :-Some Old and good songs in

Melody Queen’s Sound, Download some and enjoy

5. Songs By Mohammad Rafi :- Some songs in Legends voice,

Free downloads, go and GET

6. Free SMS And Pics :- Some Friendship SMS, Love SMS,
Jokes, Funny SMS, And some Pics


Health


1. My Helath: - Know health related Tips

2. Beauty Tips :- Know sone tips for your body

3. Love Tips :- Some Love Tips


Regional


1. Whats New in Himachal :-Something About Himachal Pradesh,
Know about Hilly State, whats going on there and so on


2. Whats New in Chandigarh :-Check for news update in Chandigarh

Money Making Tips

1. Money Making Tips :-Want to earn some good income using Internet
or with your PC, Check here and Start Your Earning NOW

The Nature

1. Prakriti The Nature :- Go and see the Nature, the Prakriti

How to Flag E-Mail as a Task in MS Out Look

Flag E-Mail as a Task in MS Out Look
Flagging mail messages as tasks automatically adds them to your To-Do Bar so that you can easily track and complete them.
1. Right-click the flag icon next to an e-mail message.
2. Designate a date by which you want to follow up on this message.
3. View the message on your To-Do Bar.

How to Work with Prebuilt Templates in MS Access

Working with Prebuilt Templates in MS Access
The new Getting Started window includes a variety of prebuilt database solutions. You can use these solutions right out of the box, or you can enhance and refine them to accommodate the kind of information you want to track or the way in which you want to track it. To open a template:
1. Start Microsoft Office Access 2007.
2. Browse the categories to find the template you want, and then click it.
3. Browse for a folder, and then click Download

How to Increase 2003 to 2007 Worksheet Capacity in MS Excel

2003 to 2007 Increased Worksheet Capacity in MS Excel
Do you regularly work with data sets larger than the capacity of 65,536 rows by 256 columns in Microsoft Office Excel 2003? Microsoft Office Excel 2007 supports up to 1,048,576 rows by 16,384 columns, so you no longer have to use many different worksheets to support your data. You can use the zoom slider at the lower right of the Office Excel 2007 window to zoom out for a bird's-eye view of how much data your worksheet can hold.
To support a bigger grid, Office Excel 2007 uses several other increased limits. For example, the number of rows allowed in a Microsoft PivotTable chart has increased from 64,000 to more than 1 million, and the amount of memory that Excel can use has increased from 1 gigabyte (GB) to the maximum allowed by the Windows operating system. The limit on the number of rows in a column or columns that can be referred to in an array formula has been completely eliminated.

How to use Instant Search in MS Out Look

Instant Search in MS Out Look
You can rapidly search for keywords or other criteria to locate items in your e-mail, calendar, contacts, or tasks, saving you valuable time.
1. Type a keyword in the Instant Search box above your e-mail list.
2. Expand the search box by using the arrow on the right to add more search criteria.
3. Expand your search results to your desktop or all mail items by using the arrow to the right of the magnifying glass

How to Use PowerPoint Themes

Using PowerPoint Themes
With Microsoft Office PowerPoint 2007, you can easily change the look of your entire presentation with just one click. By applying a theme, you can be confident that your entire presentation has a professional look.
1. Go to the Design tab.
2. Pause on different themes in the Themes gallery to see a preview of how the presentation looks with the theme applied.
3. Click the theme that you want to apply to your presentation.

How to Use InfoPath Forms in Groove

Using InfoPath Forms in Groove
You can use Microsoft Office Groove 2007 to share Microsoft Office InfoPath forms within a Groove workspace. Sharing forms enables a team to gather, view, and track structured data, even if team members are offline or cannot access the corporate network.

When you have built your form in Office InfoPath 2007, you can use the new Groove InfoPath Forms tool to import the form into the workspace. After the form is imported, members of the workspace can fill it out at any time, whether they are online or offline. Completed copies of the form—called "records"—are collected and displayed in the tool and can be viewed and tracked in different ways.

The InfoPath Forms tool also takes advantage of the automatic alerts and unread marks in Office Groove 2007, which help team members stay up to date as new forms are filled out.

How to Create a Hyperlink in MS Excel

To Create a Hyperlink in MS Excel
In Microsoft Office Excel 2007, you will find a style gallery in the Ribbon. A cell style combines a preset font format, a cell background, and borders. To apply a cell style to a cell:
1. Click the Insert tab on the Ribbon.
2. In the Links section, click Hyperlink.
3. In the Address box, type the URL of the Web page to which you want to link.
NOTE: You can also use the controls in the Insert Hyperlink dialog box to create hyperlinks to locations within the current workbook or to other documents, and links that can be used to send an e-mail message.

How to Automatically Update Data (Such as User Information) Throughout Your Document

Automatically Update Data (Such as User Information) Throughout Your Document
Content controls, a new feature in Microsoft Office Word 2007, provide the ability to structure content in a document—similar to, but with more flexibility than, traditional form controls. Among other uses, content controls enable you to bind text in your document to data sources, such as file properties or Windows SharePoint Services properties. In fact, some built-in content controls called Document Property Quick Parts are set to automatically bind to your information. As a result, if you insert a Document Property Quick Part—such as the author name or the document title—into your document, that information will automatically update in the document when it changes in file properties.

To insert a Document Property Quick Part into your document, on the Insert tab, in the Text group, click Quick Parts, point to Document Property, and then click to insert the type of property you need from the options listed.

Note that if you insert several of the same type of control (such as Title) in the same document, the text in all of those controls will update to match if any one of them is changed. Also note that some types of document building blocks (such as a cover page or a header that you can insert from applicable galleries on the Insert tab) contain Document Property Quick Parts.

How to Change Classic Start Menu in MS Vista

Classic Start Menu in MS Vista
As you transition your skills and knowledge from previous versions of Windows, you might want to fall back on the classic Start menu configuration.
1. Right-click the Windows Vista Start button.
2. Click Properties.
3. Click the Classic Start menu option.
4. Click OK.

How to Create Multiple Calendars for Different Purposes in MS Out Look

Create Multiple Calendars for Different Purposes in MS Out Look
In addition to the default Microsoft Office Outlook calendar, you can create other Outlook calendars. You might want a separate calendar for your personal appointments, for example.

To open a new calendar:
1. On the File menu, point to New, and then click Folder. (There's a keyboard shortcut for this too: CTRL+SHIFT+E.)
2. In the Create New Folder dialog box that appears, type a name for the folder in the Name box.
3. In the Folder contains list, click Calendar Items.
4. In the Select where to place the folder list, select Calendar, and then click OK.

How to Excel Services in 2003 to 2007

2003 to 2007 Excel Services
Microsoft Office Excel 2003 lists are called tables in Microsoft Office Excel 2007. Just as you can convert a data range to a list in Excel 2003, you can format a data range as a table in Excel 2007 by using the Format as Table command in the Styles section of the Home tab. Excel 2003 lists can be published to Windows SharePoint Services 2.0 sites and viewed in Windows Internet Explorer, so that you can share your data with others without having to share your entire worksheet.

With Excel 2007 and Microsoft Office SharePoint Server 2007, you can publish Excel tables to Excel Services, so that you can share Excel information through the browser by using Microsoft Office Excel Web Access. Excel Web Access presents the information in an Excel-like view rather than the list view of Windows SharePoint Services 2.0. This view enables the people you are sharing with to work in a familiar environment, even manipulating certain sets of data in the browser, without having access to any proprietary information contained in other parts of the worksheet.

To publish an Excel 2007 table to Excel Services, you must first save the worksheet to a Windows SharePoint Services 3.0 document library. Here’s how:
1. Open the online file, click the Office button, and point to Publish.
2. Click Excel Services, and then click Excel Services Options.
3. On the Show tab, click the drop-down arrow, click Sheets, and then select the individual sheets that you want to publish.
4. Click OK, and then save the file.

How to Manage Resources in Office Project

Managing Resources in Office Project
When you start assigning resources to tasks in Microsoft Office Project, the durations of the tasks automatically change. To understand why, you need to understand how Project allocates resources.

Project follows one formula for all internal resourcing calculations: Work = Duration × Resources. In other words, if two men take two hours to mow a lawn, one man will take four hours, or four men will take one hour, to mow the same lawn. Now you know why task durations constantly change if you add or remove the resources allocated to those tasks.

You can stop Project from recalculating time schedules in this way by configuring it to keep one parameter fixed and calculate just the others.
1. Open the task's properties.
2. On the Advanced tab, configure the task type as being Fixed Duration, Fixed Work, or Fixed Units (that is, resources). By changing this setting, you can tell Project what parameters in the equation should remain the same, no matter what changes you make to the task.

How to Use Follow-ups on Sent E-Mail Messages in MS Out Look

Use Follow-ups on Sent E-Mail Messages in MS Out Look
You're probably used to setting follow-up flags on e-mail messages in your Inbox. Until now, though, there wasn't much point setting follow-up flags on sent e-mail messages, because you rarely view your Sent Items folder. Yet it's often useful to set a follow-up flag on a sent e-mail message; for example, a sales e-mail message might warrant following up after a couple of days. It's now worth setting follow-up flags on sent e-mail messages, because they will appear on the To-Do Bar.

To do this:
1. Click the Follow Up flag on the Message tab of the Ribbon when writing your message.
2. Click the follow-up flag you want to use, or set a reminder for the e-mail's recipients.

You can customize the follow-up flag. When you set your flag, some basic options like Today and Tomorrow are instantly available, but if you click Custom, plenty more follow-up options appear. These include start and end times for the follow-up and required activities. All this information will appear on your To-Do Bar

How to Enter a Series of Data Using Fill Series in MS Excel

To Enter a Series of Data Using Fill Series in MS Excel
1. Type the first value in the series into a cell.
2. Type the second value into a cell below or to the right of the first cell.
3. Select the cells.
4. Drag the Fill Handle (a black square that appears at the bottom right corner of the last selected cell) over the cells into which you want to extend the series.

How to Use Messaging in MS Office Grove

Using Messaging in MS Office Grove
Microsoft Office Groove 2007 includes a basic messaging feature that you can use to send quick text or voice messages to one or more contacts outside a workspace.
1. Double-click any contact name in any workspace or from the Launchbar.
2. Optionally, add additional contacts by clicking Add More. Type your message, and then click Send.

Messages appear as pop-up windows above the Office Groove 2007 icon on the Windows taskbar, and are delivered rapidly if recipients are online. Offline recipients receive messages when they go online.

Note: After you’ve closed a message, you can access it again in your Message History. Click the icon in the lower-left corner of the Launchbar or any workspace.

How to Synchronize with Outlook

Synchronize with Outlook
Two-way synchronization with Microsoft Office Outlook 2003 and Microsoft Office Outlook 2007 enables you to link information between Microsoft Office OneNote 2007 and Outlook so that you can more easily manage your tasks and contacts, and keep track of meeting details.

To create a task in Office OneNote 2007 that will synchronize with Office Outlook 2007:
1. Click the note that you want to make into a task.
2. On the standard toolbar, click the Notes About This Item button.
3. Switch to the Unfiled Notes section of OneNote. You will find the contact or calendar information on a page, on which you can take further notes, with a link back to the contact or calendar item in Outlook. Even if you move this page in your notebook, OneNote will maintain the link with the Outlook contact.

How to Safe Senders and Junk E-Mail in MS Out Look

Safe Senders and Junk E-Mail in MS Out Look
In Microsoft Office Outlook 2007, you can add e-mail addresses to a safe recipients list. Messages received from safe recipients, and messages you send to them, will then never be treated as junk e-mail. Here’s how:
1. In an Outlook 2007 mail folder, right-click a message sent to you by the person you want to identify as a safe recipient.
2. Point to Junk E-mail, and then click Add Recipient to Safe Recipients List.

How to Apply Formatting from Any 2007 Office Release Document to Any Other in Office

Apply Formatting from Any 2007 Office Release Document to Any Other in Office
You may already know that you can use Document Themes to apply consistent fonts, colors, and graphic effects all at once throughout your 2007 Microsoft Office release Word, Excel, or PowerPoint document. But did you know that you can apply the theme formatting from any 2007 release Word, Excel, or PowerPoint file to any other?

To do this, on the Page Layout tab (in Word or Excel) or the Design tab (in PowerPoint), click to expand the Themes gallery, and then click Browse for Themes. You can then choose any 2007 release Word, Excel, or PowerPoint file (or any theme file) and apply its theme formatting to your active document.

How to Change the Desktop Appearance in MS Vista

Changing the Desktop Appearance in MS Vista
The easiest way to change the look of the Windows Vista desktop is through personalization. Here’s how:
1. Right-click the desktop.
2. Click Personalize, and then begin customizing to fit your style.

How to Select Shapes Using the SmartArt Text Pane in MS Power Point

Select Shapes Using the SmartArt Text Pane in MS Power Point
When editing a SmartArt graphic, you can edit the text directly in the diagram shapes or in the SmartArt text pane. You can also select shapes just by selecting their associated text in the text pane.

To do this, click into your SmartArt graphic. If the text pane does not automatically appear, click the arrow icons that appear on the left edge of the diagram selection frame. Then either click into a bulleted paragraph in the text pane to select the related shape, or drag your insertion point to select text in several bulleted paragraphs in order to select multiple shapes. You can also hold the CTRL key while dragging to select non-contiguous paragraphs.

Note that you can use the text pane to select shapes whether your SmartArt graphic is in the 2007 release of Microsoft Office PowerPoint, Word, or Excel.

How To Enter the Same Value into Multiple Cells Simultaneously in MS Excel

To Enter the Same Value into Multiple Cells Simultaneously in MS Excel
1. Select the cells into which you want to enter the value.
2. Type the value in the active cell.
3. Press CTRL+ENTER.

How to Customize Where Building Blocks Are Inserted in Your Document (Such as Cover Pages) in MS Word

Customize Where Building Blocks Are Inserted in Your Document (Such as Cover Pages) in MS Word
You may have already used the document building blocks functionality in Microsoft Office Word 2007 to insert complete, formatted document components, such as a cover page or table of contents, with just a click. You may also have noticed that when you click to insert some types of building blocks, your selection is automatically added to a specific place in the document, such as the first page, in the case of a cover page.

But what if you want more than one of the same type of building block in the document, perhaps at a different position? Many types of building blocks provide the option to insert additional entries at specified points in the document. Instead of clicking to insert your selection, right-click for a set of options. For example, right-click an entry in the Cover Page gallery (on the Insert tab) for the options to insert the selected cover page at the beginning or end of the document or section, or at your current position in the document.

How to Look Up People Mentioned in E-Mail Messages in Ms OutLook

Look Up People Mentioned in E-Mail Messages in Ms OutLook
Here is a common situation: You are reading a long mail thread in the Microsoft Office Outlook preview pane. Because it is a long thread, people have been added and removed from the thread as the e-mail conversation has been passed along. You see the name of a person whom you want to send e-mail to, call, or chat with. But the name is not on the active To or Cc line of the e-mail message, so you have no hyperlinked contact information.

In that case, you can select the full name, right-click, and then click Who Is. If the name appears in your address book, the Outlook Properties window for that person will appear. From there, you can easily find an e-mail address or phone number, or add the person to your instant messaging contacts by clicking Actions.

How to Compare Versions 2003 to 2007

2003 to 2007 Compare Versions
In Windows SharePoint Services 2.0 and Windows SharePoint Services 3.0, document libraries have the ability to track document versions. However, versioning must first be enabled in the document library settings. After you enable versioning, you can click the document menu, and then click Version History to open each version of a particular document.

With Microsoft Office Word 2007, you can use the Compare feature to compare online document versions and see exactly what changes were made.
1. Click the Review tab, and then click the Compare button.
2. Click Compare, click Compare again, and choose the original document and the revised version that you want to compare. Depending on the type of versioning enabled in the document library, you can compare the open version against the last version, the last major version, or any specific version saved to the server.

How to Create a Workspace in Office Groove

Creating a Workspace in Office Groove
Each Microsoft Office Groove workspace is a separate window, opened from the Launchbar, which contains people's names, tools, and information. The number and variety of tools in each workspace depend on the tasks you are trying to accomplish with your team members.

You can create workspaces from the Launchbar or from the File menu.
1. From the Launchbar Workspaces tab, click New Workspace. Or from the File menu, point to New, and then click Workspace.
2. Type a descriptive name for your workspace.
3. Select the type of workspace that you want. There are three different types to choose from depending on your team’s needs.

How to See that How a Query Is Progressing

See How a Query Is Progressing in MS office Excel
Because Microsoft Office Excel 2007 can now display more than 1 million rows in a spreadsheet, you can run queries that return a lot of data and therefore take a long time. By setting a query to refresh in the background, you can still work in Excel while data is being retrieved.

On the left side of the status bar is a little spinning globe, which lets you know that the query is still running. Clicking the globe opens a dialog box where you can see the queries that are being executed in the background, how long they have been running, and how many records have been returned so far. You can even stop the query if you want to.

How to See More in the To-Do Bar in MS Outlook

See More in the To-Do Bar in MS Outlook
The To-Do Bar is extremely flexible; you can customize it to your needs. Click View, click To-Do Bar, and then click Options. From here you can turn elements of the To-Do Bar on or off, and also select how many appointments you want to see. This is useful on busy days with multiple appointments, because you can see them all at a glance.

How to use 2003 to 2007 Custom Slide Layout

2003 to 2007 Custom Slide Layout
The Slide Layout task pane in Microsoft Office PowerPoint 2003 provides a number of different options for structuring your slide layout. But what if you need something a little more customized? You can create a blank slide and manually insert text boxes, charts, and pictures, but there's no easy way to reuse the same layout later in the presentation.

In Microsoft Office PowerPoint 2007, you can add custom layouts to the slide master, making your new layout available to you any time you need it.
1. Click the View tab, and then click Slide Master in the Presentation Views section.
2. Click Insert Layout, and then use the Insert Placeholder button to add content placeholders to your layout.
3. Right-click the layout and rename it to something easy to remember.
4. Click Close Master View to return to your presentation.
5. To apply your new layout, click the Layout list in the Slides section of the Home tab, and then click your layout.

How to To Change the Color of a Sheet Tab in MS excel

To Change the Color of a Sheet Tab in MS excel
1. Right-click the sheet tab.
2. Click Tab Color.
3. Click the color from the palette that appears.

How to Collect Data via E-Mail in MS Access

Collecting Data via E-Mail in MS Access
Microsoft Office Access 2007 simplifies the process of collecting information from others. It builds the data collection form automatically by using Microsoft Office InfoPath 2007 or HTML in the body of an e-mail message. Microsoft Office Outlook 2007 processes the incoming forms and helps you save the data in your Office Access 2007 data store—effectively updating the database without retyping.

To collect new information via e-mail:
1. Open or select the table containing the fields that you want to collect.
2. On the External Data tab, click Create E-mail.
3. Follow the wizard to create an e-mail form.
a. Select HTML or InfoPath form (if you select the latter, the recipients must have Office InfoPath 2007 and Office Outlook 2007 deployed).
b. Select Automatically process replies and add data to Table if you don’t have to approve each entry before it is saved in the database.

Returned forms will go to a newly created folder named Access Data Collections in your Inbox in Office Outlook 2007. Each time you receive a filled form, it will be flagged as a task for you to review.

To export collected data to Access:
1. If you have not selected automatic processing, right-click the returned e-mail message, and then click Export to Access. Or you can open the message and click the same command from the Ribbon.
2. Green or red icons will flag whether the export was successful or not.

After sending a data collection e-mail message, you can use the Manage Replies command on the External Data tab of the Ribbon to change some of the message options and resend the message.

How to Generate Random Text in Word 2007

Generate Random Text in Word 2007
On a blank line in a Microsoft Office Word document, type =rand followed by (PC,SC)—where PC stands for paragraph count and SC stands for sentence count—and then press ENTER. For example, =rand(2,3) will create two paragraphs of three sentences each.

Word inserts some random text based on your specification. You can use this new text for testing form controls such as text boxes or paragraph alignments.

How to Send a Calendar Snapshot in MS Office Outlook

Send a Calendar Snapshot in MS Office Outlook
With a calendar snapshot, you can communicate your calendar information to anyone, anytime. To send a calendar snapshot:
1. Click the calendar.
2. Click the Send a Calendar via E-mail link in the left navigation pane.
3. In the dialog box, choose which calendar you want to send information from, the date range, and the level of details that you want to share. Microsoft Office Outlook creates a visual representation of your calendar information in the body of the e-mail message and also attaches the information as an .ics file.

How to Answer Routine E-Mail Quickly via IM in Ms Outlook

Answering Routine E-Mail Quickly via IM in Ms Outlook
Instant messaging is the quick way of replying to non-essential e-mail. You can save valuable time by answering routine messages with instant messages instead of e-mail. Click Reply on the toolbar, and then select Reply with Instant Message from the drop-down menu. This will start Microsoft Office Communicator, which you can then use to send an instant message in less time than a conventional e-mail message.

How to Prioritize with Note Tags in Office OneNote

Prioritize with Note Tags in Office OneNote
Note tags help you to know and find what’s important in your notes (such as ideas or actions), to indicate what level priority or type each item is, and to recall these items easily. Names and icons associated with note tags can be customized to meet your needs.

To add a note tag:
1. Click the content that you want to tag.
2. On the Insert menu, click Note Tags.
3. Choose from the list of note tags.

How to Schedule Meetings for a Whole Team of People in MS Office Outlook

Schedule Meetings for a Whole Team of People in MS Office Outlook
If you frequently schedule meetings with the same team members, finding a free slot in everyone’s calendar can be challenging. It can also be irritating to keep adding all of your team members to the To line of your meeting request.

Defining and using a group schedule makes this task easier. Here’s what to do:
1. Define a group schedule.
a. In your Microsoft Office Outlook Calendar view, click Actions, and then click View Group Schedules.
b. Click the New button, assign a name to the new group schedule, and then click OK.
c. Add your teammates in the Group Members column (just as you would in a meeting request).
d. Click Save and Close.

2. Use your group schedule to create a meeting request.
a. From your Outlook Calendar view, click Actions, and then click View Group Schedules from the menu bar.
b. Click the group schedule that you defined from the list, and then click Open. Now you can see the free/busy information from all your teammates without having to select them individually in a meeting request.
c. Find a free slot and select it.
d. Click Make Meeting, and then click New Meeting with All. A new meeting request opens, prefilled with all your teammates on the To line.

How to To Find Text Formatted Using a Specific Format in MS office Excel

To Find Text Formatted Using a Specific Format in MS office Excel
1. Click the Home tab on the Ribbon.
2. In the Editing section, click Find & Select.
3. Click Find.
4. In the Find and Replace dialog box, click Options.
5. Click Format.
6. In the Find Format dialog box, specify the format for which you want to search.
7. Click OK.

Note: You can also define the format you want to find by clicking Choose Format From Cell in the Find Format dialog box, and then clicking a cell with the desired format.

How to Display a Second Time Zone in Your Outlook Calendar in Microsoft Outlook

Display a Second Time Zone in Your Outlook Calendar in Microsoft Outlook
To make setting up and attending meetings across time zones easy, you can add a second time zone to your Microsoft Office Outlook calendar view.

1. In Outlook, click Tools, click Options, click Calendar Options, and then click Time Zone.
2. Enter a label for your current time zone (for example, DE for Germany), select the Show an additional time zone check box, and then select the appropriate time zone from the list displayed.

How to Convert a Bulleted List to a SmartArt Diagram in MS Power Point

Convert a Bulleted List to a SmartArt Diagram in MS Power Point
Right-click anywhere in the bulleted list, point to Convert to SmartArt, and then click the diagram layout that you want to use. If you don’t see your preferred diagram layout, click More SmartArt Graphics to choose a layout from the Choose a SmartArt Graphic dialog box. After your list converts to a diagram, the SmartArt Tools Design and Format tabs appear when the diagram is active. Use those tabs to apply formatting or even change the diagram layout.

How to Print Page Backgrounds with Your Document in MS Word

Print Page Backgrounds with Your Document in MS Word
By default, page backgrounds created with the Page Color option in the Page Background section on the Page Layout tab in Microsoft Office Word 2007 do not print. However, you can print them with the document if needed.

To include the page background when printing, click the Office button and then click Word Options. On the Display tab of the Word Options dialog box, select the printing option Print background colors and images, and then click OK. (Note that this setting is not document-specific and will apply to all documents that you print from Word 2007 while the setting is active.)

How to To Fit a Printout onto a Set Number of Worksheet Pages in MS Excel

To Fit a Printout onto a Set Number of Worksheet Pages in MS Excel
1. Click the Page Layout tab on the Ribbon.
2. In the Scale to Fit section, in the Width box, type the number of pages you want the printout to span horizontally.
3. In the Height box in the same section, type the number of pages you want the printout to span vertically.

How to Add New Users to Vista

Adding New Users to Vista
Rather than putting everyone's files in one location, Windows Vista allocates folder structures for each user, keeping your information more private and less cluttered. User Accounts are configured through User Accounts and Family Safety in Control Panel.

Note: You must be an administrator, and your organization might limit the use of administrator rights.

How to Use Table Styles in MS Power Point

Use Table Styles in MS Power Point
You can easily improve the look of your tables in seconds by using table styles in Microsoft Office PowerPoint 2007.
1. Select the table that you want to format.
2. A set of Table Tools contextual tabs appears on the user interface. Click the Design tab to reach the Table Styles gallery.
3. Browse through the available prebuilt styles by pausing on each table. You’ll see a preview of your table’s appearance with that style.
4. Click the table format that you like, and apply the changes to your presentation. You can use the other features and galleries on the Design and Layout tabs to further customize your table.

How to Building on Existing Searches in Microsoft Vista

Building on Existing Searches in Microsoft Vista
The more you search, the more searches you save, and the more likely you have saved most of the search you want, but you may want to narrow the criteria. To build from an existing search:
1. Browse to your Searches folder.
2. Double-click the existing search.
3. Click Search Tools, and then click Search Pane.
4. Click the Advanced Search expansion arrow.
5. Modify the criteria (use wildcard characters).
6. Click Search. You can even save this new search for reuse.

How to Set Up a Shared Notebook in Office SharePoint Server

Set Up a Shared Notebook in Office SharePoint Server
You can easily create a shared Microsoft Office OneNote notebook by following these steps:
1. On the File menu, click Share.
2. Click Create Shared Notebook. A wizard opens to prompt you through the remaining steps. Note that you’ll need the URL of the Microsoft SharePoint document library where you plan to store the notebook.

How to Set the Order of Your Tasks and To-Dos in MS Out Look

Set the Order of Your Tasks and To-Dos in MS Out Look
You can prioritize your Microsoft Office Outlook tasks and to-dos. To create a task or to-do from an Outlook item, either flag it or simply drag it to the task list or To-Do Bar. Then set the order in which you want items to appear by dragging them up and down the list.

How to make Hyperlink my Notes Together in Microsoft Office OneNote

Hyperlink Your Notes Together in Microsoft Office OneNote
In Microsoft Office OneNote 2007, you can create hyperlinks to other OneNote pages so that you can easily jump between your notes or point other users to a page in a shared notebook.
1. Right-click the page tab of the OneNote page that you want to link to.
2. Click Create Hyperlink to This Page.
3. Paste the address of the page where you want to create the link. This might be on another page in your notebook, or in an e-mail message inviting others to view a shared notebook, for example

How to Change Default Document Formatting in MS Word

Change Default Document Formatting in MS Word
When you created your first new document in Microsoft Office Word 2007, you may have noticed that default text formatting (the formatting of the Normal paragraph style) had changed from the previous version. For example, the new default font is Calibri, line spacing is a bit expanded, and space is automatically added after each paragraph.

To change font and paragraph formatting defaults for the active document or all new documents based on the active template, do the following:
1. Press CTRL+SHIFT+ALT+S to open the Styles pane (or click the dialog box launch icon in the Styles section on the Home tab).
2. Click the Manage Styles icon at the bottom of the pane to open the Manage Styles dialog box.
3. On the Set Defaults tab of the dialog box, change font and paragraph formatting as needed. Then, at the bottom of the dialog box, click the option to apply settings either only to this document or to new documents based on the active template.

How to Fix the OSD Problem After Reinstalling Outlook 2007

Fix the OSD Problem After Reinstalling Outlook 2007
When you try to access Microsoft Office Outlook 2007 after reinstalling the 2007 Microsoft Office system, you will receive an error message recommending that you access your Microsoft Exchange server to reinstate the Open Software Description (OSD) file. This can be fixed.
1. In Control Panel, click User Accounts, double-click Mail, and then click E-mail Accounts.
2. Double-click your account, and then change your user name to an alias.
3. Click Next, and then exit.

How to use Task Updates and Timesheet Submittal and Approval in Office Project

Task Updates and Timesheet Submittal and Approval in Office Project
Team members update project work in the Tasks, My Work section of Microsoft Office Project Web Access. After they submit their task updates, the project manager approves or rejects their time on tasks in the Approvals, Task Updates section of Project Web Access.

At the end of each timesheet period, team members use Import Task Progress to show progress on their timesheets along with any other administrative time spent during the period.

Resource managers can review, approve, and reconcile timesheets against reported project work, nonproject work, and nonworking time.

Use the following steps to review and approve timesheets:
1. In Project Web Access, click the Action pane.
2. In the Approvals section, click Timesheet.
3. In Review My Timesheet Summary, click My Timesheet.
4. Click the Review Timesheet Detail page.
5. Click Approve to complete the approval process.
6. In the Approvals section, click Admin Time.
7. Click the Review Admin Time Detail page.
8. Click Approve to complete the approval process.

How to Print an Entire Worksheet Even If You Defined a Print Area in Ms Excel

Print an Entire Worksheet Even If You Defined a Print Area in Ms Excel
1. Click the Office button.
2. Click Print.
3. In the Print what section, select the Ignore print areas check box.

How to Apply Formatting That Updates Automatically When You Change the Document Theme

Apply Formatting That Updates Automatically When You Change the Document Theme
You may already know that the new Document Themes feature in the 2007 Microsoft Office system programs Word, Excel, and PowerPoint enables you to apply a set of fonts, colors, and graphic effects throughout the document at once. Document Themes also help you apply that same formatting automatically to new content as you add it. However, if you’ve tried to use the Themes gallery (available from the Page Layout tab in Word and Excel or the Design tab in PowerPoint) and some document elements didn’t update, here’s the reason.

Theme elements such as fonts or colors correspond to specific formatting options. When you use those options to format document content, that content will automatically update when you change the theme (this is often referred to as theme-ready formatting). To apply colors that are theme-ready, choose colors from the Theme Colors portion of the color palette; to apply fonts that are theme-ready, use the fonts under the heading Theme Fonts.

Note: You must choose formatting from Theme Colors or Theme Fonts for that formatting to be theme-ready. Even the identical formatting selected from a different location—such as by typing in RGB color values that match a color in the Theme Colors palette—will not be theme-ready.

How to Move Things Around Quickly in MS Outlook

Move Things Around Quickly in MS Outlook
You can move items from one place to another in Microsoft Office Outlook. The keyboard shortcut SHIFT+CTRL+V opens the Move Items window. For example, to convert an e-mail message into a task, press SHIFT+CTRL+V followed by T. This shortcut will save a lot of time scrolling through your folder list. If you have more than one folder that begins with the letter T, just keep pressing T until the Tasks folder is selected, and then press ENTER.

How to use 2003 to 2007 Shared Tasks

2003 to 2007 Shared Tasks
Tasks created in Windows SharePoint Services 2.0 and Microsoft Office Outlook 2003 are separate entities. Although you can connect Windows SharePoint Services 2.0 calendars and contact lists to Outlook 2003, using tasks in both programs means managing these tasks in different locations.

With Windows SharePoint Services 3.0 and Microsoft Office Outlook 2007, you can connect Windows SharePoint Services 3.0 task lists to Outlook 2007 by clicking the Actions button on the SharePoint task list, and then clicking Connect to Outlook. After you're connected, you can manage your shared tasks alongside your other Outlook tasks. Shared tasks also appear in the new Outlook To-Do Bar, providing a summary view of the day's upcoming appointments and tasks.

How to Use Workspace Chat in MS Groove

Using Workspace Chat in MS Groove
Workspace Chat in Microsoft Office Groove 2007 enables people to communicate inside a workspace of which they are all members. When you use Workspace Chat, other online members of the workspace will be alerted and can join the chat with a click of the mouse.

Click the Expand Chat arrow at the bottom of the Workspace Members pane. Type your message, and then press ENTER or click the Send chat entry arrow.

If you have a Tablet PC and prefer to use ink, click the arrow icon in the Chat pane, and then click Switch to Ink Mode.

How to Change the Default File Location in MS Excel

Change the Default File Location in MS Excel
Many users find that they tend to open workbooks from the same folder on their computer. If that Windows Vista folder isn't Documents (My Documents in Windows XP), you can change the folder that Microsoft Office Excel 2007 displays when you want to open or save a workbook. Here’s how:
1. Click the Office button.
2. Click Excel Options.
3. In the left column, click Save.
4. Type the desired location in the Default file location box.