Rabu, 30 April 2008

How to Mark as Final 2003 to 2007 in MS Word

Question:-How I can Mark 2003 to 2007 as Final in Ms Word?
Answer:-2003 to 2007 Mark as Final
To make a Microsoft Office Word 2003 document read-only, you need to close the file, right-click it
in Windows Explorer, click Properties, and then select the Read-only check box. If it's a Microsoft Office Word 2007 document, you can save yourself the trouble and change the document to read-only from within the program.
1. Click the Office button, and then point to Prepare.
2. Click Mark as Final. Not only is the document now read-only, but the editing commands on the Ribbon are unavailable. To enable editing again, follow the same steps to turn the Mark as Final feature off.

How to Fine-Tuning Objects in Presentations

Question:-How I can Fine-Tune Objects in Presentations?
Answe:-
Fine-Tuning Objects in Presentations
When working with text in Microsoft Office PowerPoint, you can use the F2 key to switch between selecting text in a placeholder and selecting the placeholder itself. So the next time you've edited some text and want to reposition it on the slide, instead of clicking the tiny edges of the box, just press F2. The entire text box will instantly be selected for you, ready for alignment.

How to Use Search to Find E-Mail Messages?

Question:-How I can Use Search to Find E-Mail Messages?
Answer:-
Question:-Use Search to Find E-Mail Messages
In Microsoft Office Outlook, e-mail search helps you locate messages by keyword or phrase. You can also use search folders to find mail by type of message.

To locate specific keywords or phrases within e-mail messages:
Type a word or phrase in the Search box at the top of your Outlook Inbox. The search starts automatically as soon as you stop typing. Search results will appear in the main window of your Inbox. To return to your normal Inbox, click Clear Search (the green ×) to the right of the Search box.

You can enable search folders from the mail pane on the left of your Inbox. To expand the folders tree, click Search Folders. Outlook comes with three default search folders: For Follow Up, Large Mail, and Unread Mail.

To add new search folders, click File, point to New, and then click Search Folder.

To build a custom search folder:
1. Click Search Folder, and then either click a predefined folder name, or scroll down and click Create a custom Search Folder.
2. Click Choose, give the new folder a name, and then click Criteria to fill in the search terms.

How to Customize My Quick Access Toolbar?

Question:-How I can Customize My Quick Access Toolbar?
Answer:-
Customize Your Quick Access Toolbar
In each 2007 Microsoft Office system program where you see the Ribbon (Word, Excel, PowerPoint, Access, and parts of Outlook), you also see a Quick Access Toolbar, which appears by default above the Ribbon, beside the Office button. To add the commands you use most to the Quick Access Toolbar in each program, right-click a command on the Ribbon, and then click Add to Quick Access Toolbar. You can also click the arrow that appears at the right edge of the Quick Access Toolbar, and then click More Commands to open the Customize tab of the Options dialog box for the program you are using. In this box you can add commands that don’t appear on the Ribbon, or create a custom Quick Access Toolbar for an individual document or template.

How to Change File Properties in Vista?

Question:-How I can Changing File Properties in Vista?
Answer:-Changing File Properties in Vista
File properties or metadata can be very useful in labeling, organizing, and subsequently finding your files. Most programs add their own properties when saved; however, with Windows Vista, you can augment these attributes.
1. Click Organize, click Layout, and then click Details Pane (if necessary; you should see the details pane by default at the bottom of the Explorer).
2. Expand the details pane (click and drag the separator above the pane to resize).
3. Select the attribute that you want to change, and enter any information that you want to add.

How to Convert Text to Tables?

Question:-How I can Convert Text to Tables?
Answer:-Convert Text to Tables?
Sometimes you may find different types of information within the same piece of text, where the only thing separating the information is a space. Microsoft Office Excel makes it easy to redistribute this data by using different columns, and to display the data in a more digestible format.

1. Choose delimiters and column separators.
a. Select the cells containing the data that you want to separate.
b. On the Data ribbon, in the Data Tools section, click the Text to Columns button.
c. Select your preferred data type (that is, Delimited or Fixed width) from the options in the first step presented by the wizard.
d. In the second step of the wizard, select your preferred delimiters from the Delimiters options, or the column separator position from the Fixed width options.

2. Define the data format of your new columns.
a. In the dialog box of the wizard’s third step, select one column at a time and define its data format by clicking your preferred option under Column data format.
b. Click the Finish button. The text chains will now be distributed into columns according to your chosen data format.

How to Use Conditional Formatting to Highlight Data Trends

Question:-How I can Use Conditional Formatting to Highlight Data Trends?
Answer:-Use Conditional Formatting to Highlight Data Trends
Conditional formatting can help you highlight trends in your data. First, either open a fully populated Microsoft Office Excel file, or start with an empty document and fill its cells with some values. To apply conditional formatting:
1. Click the Conditional Formatting button on the Home tab of the Ribbon.
2. On the menu that appears, try selecting Data Bars, Icon Sets, or Color Scales and pause over the options. Your data is partitioned according to the rules you set, and it instantly displays visual cues that will aid understanding of the data.
3. If you don't like the options available, you can create your own rules, use your own colors, and establish your own thresholds. Better still, you can reuse your rules each time for consistent and clear presentation. All of these options are available on the Conditional Formatting menu.

How to Insert Pictures in NoteOne

Question:-How I can Insert Pictures?
Answer:-Insert Pictures
To insert a picture in your notes, click Insert, click Pictures, and then click either From Files or From Scanner or Camera.

How to Quickly Switch to Inbox or Outbox

Question:-How I can Quickly Switch to Inbox or Outbox?
Answe:-Quickly Switching to Inbox or Outbox
To jump to your Inbox, press CTRL+SHIFT+I. To jump to your Outbox, press CTRL+SHIFT+O.

How to Generate an Efficient Frontier

Question:-How I can Generate an Efficient Frontier ?
Answer:-Generating an Efficient Frontier
You can assess your selected project portfolio against the Efficient Frontier. (Note: These steps assume you have already run an optimization scenario.) Here’s how:
1. Right-click an optimization scenario, and then click Insight Analysis from the Advanced Analysis commands.
2. Wait while the Efficient Frontier is generated.
3. Analyze the constraints (in the right panel) that are prohibiting the portfolio from reaching the Efficient Frontier.

How to use Lookups and Relationships

Question:-How I can Use Lookups and Relationships
Answer:-Lookups and Relationships
Often you need to add fields that look up data from other tables. For example, you may want to assign a task to someone in your Contacts table. To add such a field:
1. In datasheet view, on the Ribbon, in the Fields and Columns group, click Lookup Column.
2. If you want to type the lookup values instead of looking up a field from a different table, select I will type in the values; if not, click Next.
3. Select the table that you want to look up from, and then click Next.
4. Select the fields that you want to include in your lookup, and then click Next.
5. Select the sorting method you want, click Next, and then click Next again on the following screen.
6. Label the lookup column and check the box if you want to allow the selection of multiple values. Click Finish.

How to Overprint Watermarks on Documents

Question:-How I can Overprint Watermarks on Documents?
Answer:-Overprinting Watermarks on Documents
You can easily insert a watermark into your document in Microsoft Office Word 2007. Click Watermark from the Page Layout tab on the Ribbon.

How to Change the Color of Excel Comments

Question:-How I can Changing the Color of Excel Comments?
Answer:-Changing the Color of Excel Comments
In Microsoft Office Excel, comments appear in little yellow boxes by default. Here’s how you can change the color of a comment:
1. Right-click its border, and then click Format Comment from the shortcut menu.
2. On the Colors and Lines tab, choose a color from the Color list.

Changing the default color for comments is a little more involved; here’s how to do it:
1. Right-click any blank area of your Windows desktop, and then click Properties from the shortcut menu.
2. Click the Appearance tab, and then click the Advanced button.
3. Select ToolTip from the Item list.
4. Click the arrow next to the Color box, and then choose a color for your comments.
5. Click OK.

Senin, 28 April 2008

How to Search All Folders in a Mailbox

Question:-How I can Search All Folders in a Mailbox ?
Answer:-Search All Folders in a Mailbox
You can set Microsoft Office Outlook to automatically search across all your folders at once. Here’s how:
In Outlook, click Tools, click Options, and then click Search Options on the Preferences tab. In the Search Options dialog box, if you click All folders, you can search all folders instead of just the selected one.

How to Use Multiple Level Undo, Change Highlighting, and Task Drivers

Question:-How I can Use Multiple Level Undo, Change Highlighting, and Task Drivers?
Answer:-Multiple Level Undo, Change Highlighting, and Task Drivers
In Microsoft Office Project Professional, project managers can visualize the effects 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. By using this feature together with the Multiple Level Undo feature, project managers can do what-if analyses 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 Make 2003 to 2007 Quick Parts

Question:-How I can make 2003 to 2007 Quick Parts?
Answer:- Make 2003 to 2007 Quick Parts
In Microsoft Office Word 2003, you can use AutoText to automate the typing of oft-repeated text like names and addresses. But what if you want to reuse more than text? You can use Quick Parts in Microsoft Office Word 2007 to save any document content—text, pictures, Microsoft SmartArt graphics, headers and footers, and more—to an easily accessed Quick Part Gallery.
1. Click the Insert tab, and then select the document content that you want to reuse.
2. Click the Quick Parts button in the Text section, and then click Save Selection to Quick Part Gallery.
3. Enter a name and description, and then click OK.
4. To reuse the content, click the Quick Parts button, and then select the Quick Part that you want to use.

How to Enter the PowerPoint Slide Show Mode

Question:-How I can Enter the PowerPoint Slide Show Mode Beginning at Any Point?
Answer:-Enter the PowerPoint Slide Show Mode Beginning at Any Point
Pressing F5 in Microsoft Office PowerPoint starts the slide show, but by default, it will open with the first slide in the deck. To start your slide show with the current or selected slide, press SHIFT+F5 instead.

How to Set Permissions

Question How I can Set Permissions ?
Answer:- Set Permissions
Each person you invite to a workspace will have one of three roles: Manager, Participant, or Guest. Each role type is granted specific permissions within the workspace and within each tool. As the Manager, you can adjust tool permissions to help protect the content and control what others can do within the workspace.

1. Right-click the Tool tab, click Properties, and then click Permissions. Then select a role from the menu.
2. Adjust the permissions by selecting or clearing the check boxes, and then click Apply.

How to Know How Many Lines or Words You Have Typed

Question:-How I can Know How Many Lines or Words I Have Typed?
Answer:-Quickly Know How Many Lines or Words You Have Typed
Right-click the status bar, and then select a parameter. Microsoft Office Word can show you, for example, line details or the number of words typed. This information is useful when you are writing a document that must have a fixed length.

Minggu, 27 April 2008

How to Fill In the Blanks in Spreadsheets

Question:-How I can Fill In the Blanks in Spreadsheets?
Answer:-
How I can Fill In the Blanks in Spreadsheets
1. Select all the rows in your Microsoft Office Excel spreadsheet data set.
2. On the Home tab, in the Editing section, click Find & Select, click Go To, click Special, click Blanks, and then click OK.
3. Click the equal sign (=) on the toolbar, select the cell above, and then hold down the CTRL key while you press ENTER. Blanks in the spreadsheet will be filled automatically.
4. Copy all the data, click Paste Special, and then click Values. This will overwrite the formulas and enable you to sort the data by filling in each empty cell with the same information as the one above. This tip will work on any size of data set.

How to Display More on the Screen by Changing Your View

Question:-How I can Display More on the Screen by Changing Your View ?
Answer:-Display More on the Screen by Changing Your View
You can change the view settings to display more on your screen. In Microsoft Office Outlook, click View, click Navigation Pane, and then click Minimized.

How to Save Automatic in MS Office OneNote 2007

Quaestion:-How I can Save Automatic in MS Office OneNote 2007?
Answer:-
Automatic Save in MS Office OneNote 2007
Can’t find the Save button? There isn’t one. Microsoft Office OneNote 2007 automatically saves and backs up your notes as you type them. To customize backup options, click Tools, click Options, and then click Backup

How to Sort Documents in SharePoint Libraries

Quaestion:-How I can Sort Documents in SharePoint Libraries?
Answer:-
Sort Documents in SharePoint Libraries
You can change the default settings of your My SharePoint document libraries to sort by latest upload. You can then see at a glance what’s changed and what’s new.

1. Open your Microsoft SharePoint document library, and click Modify settings and columns under Actions in the task pane.
2. Under Views, click All Documents.
3. On the Edit View page, find the Sort section.
4. On the First sort by the column menu, click either Modified or Created, depending on whether documents will be uploaded once or changed and then uploaded again.
5. Select the Show items in descending order check box, and then click OK.

How to View All the Text in Your Columns

Question:-How I can View All the Text in Your Columns?
Answer:-View All the Text in Your Columns
In Microsoft Office Excel, you can resize multiple columns to different widths so that you can see all the text in your spreadsheet.

1. Select the columns where your text appears by clicking the column headings. Select multiple columns if necessary.
2. To resize the columns to fit, double-click in the column heading, exactly on top of the border that divides any of the two columns you selected.

All of your selected columns are resized based on the longest text string in each column. In this way, a large and confusing spreadsheet with lots of text that you can't see is converted into a legible spreadsheet with all text showing.

Jumat, 25 April 2008

How to Send Contact Information in Read-Only Format?

Question:-How I Can Send Contact Information in Read-Only Format?
Answer:-Send Contact Information in Read-Only Format
Sharing contact information is easy in Microsoft Office Outlook.
1. Find the contact whose business card details you want to send.
2. Right-click the business card, and then click Send as Business Card. Outlook opens an e-mail message with the card attached and also includes the card in the body of the message.
3. Address the message and click Send.

How to Use 2003 to 2007 Presenter View

Question:-How I can use 2003 to 2007 Presenter View?
Answer:- 2003 to 2007 Presenter View
Would you like to have access to your slide notes during a presentation—without printing? Microsoft Office PowerPoint 2003 features a multiple-monitor view that can display your presentation on one monitor and your notes on another monitor. But your computer must have two video cards, a requirement that only professional presentation computers are likely to possess.

With Presenter view in Microsoft Office PowerPoint 2007, you can use your notebook computer's dual monitor capability to display the presentation on an external monitor (like a projector) and display your notes, thumbnails of the upcoming slides, and a presentation timer on your local monitor.

To enable Presenter view:
1. On the Slide Show tab, in the Monitors section, click the Use Presenter View check box.
2. Select which monitor will display the external slide show.

How to Return to the Last Edit in a Microsoft Office Word

Question:-How I Can Return to the Last Edit in a Microsoft Office Word Document?
Answer:-Returning to the Last Edit in a Microsoft Office Word Document
If you want to return to where you last made a change in a Word document, press SHIFT+F5, and you will go straight back to the point of the last edit.

How to fill a selected range with the same data

Question:-How I can fill a selected range with the same data?
Answer:-Fill a selected range with the same data
Need to enter the same data in a range of cells? Here’s how:
1. Select a range of cells.
2. Type in some data.
3. Use the fill function in Microsoft Office Excel—press CTRL+ENTER, and the range selected will be filled with the same data.

How to View Emails by conversation

Question:-How I can arrange E mails by Conversation?
Answer:-Arrange Your E mails by conversation
Usually, you see e-mail messages in the order in which they arrive. But if you need to read the background of a message, switch to Conversation view to see the rest of the thread.
In Microsoft Office Outlook 2007, click View, click Arrange By, and then click Conversation.
In Microsoft Office Outlook 2003, click View, and then click Arrange By Conversation.

Rabu, 23 April 2008

How to use 2003 to 2007 Tri-Pane Review

Question:-How I can use 2003 to 2007 Tri-Pane Review in Microsoft Office?
Answer:-Use 2003 to 2007 Tri Pane Review
In Microsoft Office Word 2003, you can use the Compare Side-by-Side command to display two documents next to each other so that you can compare them. However, this is only a view and doesn't indicate actual changes to the document. The Compare and Merge command shows document changes but automatically merges the two together, regardless of whether or not you're ready.

In Microsoft Office Word 2007, a side-by-side view is still available if you want it, but the Compare feature now offers a tri-pane review: the original document in one pane, the revised document in another pane, and a combined version of the document with changes marked in a third pane. The tri-pane view shows document changes even if the other person forgot to turn on the Track Changes feature. If you want to keep the combined document, you can simply save it as a separate file.

To use tri-pane review:
1. Click the Review tab, and then click Compare in the Compare section.
2. Click Compare, and then select the original and revised documents that you want to view

What are the Different Steps Through Formulas

Question:-How I can perform different steps while using formulas?
Answer:- Perform different step through formulas

When you're writing complex formulas, a slight difference in brackets, for example, can entirely change the result of the calculation of a formula. Microsoft Office Excel adheres to the standard order of precedence for calculations, with percentages, exponents, multiplication, and division performed in that order before finally calculating addition and subtraction. For example, 7+5*3 = 22, because the 5*3 is calculated first. (7+5)*3 = 36, because the parentheses force the addition to be completed first.

If you're unsure how Excel is evaluating a formula:
1. Click the cell, click the Formulas ribbon, and then click Evaluate Formula in the Formula Auditing section.
2. Click the Evaluate button to watch as each part of the formula is successively calculated, ensuring that each step of the calculation is valid.

Senin, 21 April 2008

How to enter a fraction in a cell

Question :- How I can Enter a Fraction in a Cell
Answer :- Enter a Fraction in a Cell
Microsoft Office Excel can display, and take data entry as, fractions as well as decimal numbers. To enter a fraction, simply prefix it with a zero and a space. So to display the fraction one-third, type 0 1/3. This will display 1/3 but will have an underlying value of 0.33333333

How to set the Format for Pasting in Word 2007

Question :-How I can Set Pre-define the Format for Pasting in Word 2007
Answer :-Pre-define the Format for Pasting in Word 2007
In a Microsoft Office Word 2003 document, each time you paste some text or an image, you can select the format (source formatting, destination formatting, or text only) by clicking the clipboard icon. In Microsoft Office Word 2007 and Microsoft Office Outlook 2007, you can still do this manually or, more conveniently, set the default paste formatting mode.
Here’s how: Go to Advanced Options or click the Set Default Paste option when the clipboard icon appears, and then set your preferences. The pasted text and images will now be formatted automatically according to your settings.

Jumat, 18 April 2008

How to generate a pivot diagram from excel data

Question:-How I can Generate a Pivot Diagram from Excel Data?
Answer:- Generate a Pivot Diagram from Excel Data
In Microsoft Office Visio Professional 2007, you can now generate a PivotDiagram from data such as a Microsoft Office Excel worksheet. A PivotDiagram has very similar functionality to an Excel PivotTable, but it displays your data graphically.

To generate a Visio 2007 PivotDiagram, on the File menu, point to New, then point to Business, and then click PivotDiagram. Follow the wizard steps to select your data and generate your PivotDiagram page.

If your source data is in an Excel 2007 table, you can generate the page even more quickly from Excel. To do this, click in the Excel 2007 table and then, on the Table Tools Format tab, click Export, and then click Export Table to Visio PivotDiagram. After the diagram page is set up, click in the PivotDiagram pane to add categories or values to your diagram, and Visio automatically generates the shapes with applicable data.

How to add more level's of UNDO

Question:- How I can Add More Levels of Undo?
Answer:-Add more levels of undo
You can go back farther in Microsoft Office PowerPoint to undo actions.
1. With PowerPoint open, click the Office button, and then click PowerPoint Options.
2. On the Advanced tab, change the Maximum number of undos from the default 20 to any number from 3 to 150.

Senin, 14 April 2008

How to Get the Right People in Meetings

Question:-How I can Get the Right People in a Meeting from the Start?
Answer:-Get the Right People in a Meeting
You can clearly indicate in a meeting request who is required for a meeting and who is only optional.
1. In the meeting request, click Invite Attendees and add all relevant names (including the conference room if applicable).
2. After the names have been resolved, click Scheduling.
3. For each name, determine Required or Optional status by clicking the small red arrow next to each name.
4. Indicate the conference room as a resource (and it will be automatically added as the meeting location).
Also be sure to include the meeting agenda in the invitation, rather than in a separate e-mail message.

How to Tell Your Friends Whether You're Busy or Free

Question:-How I can Tell My Friends Whether I am Busy or Free in Communicator?
Answer:-Tell your friends whether You are free or not
Microsoft Office Communicator 2005 has an automatic setting to display your availability. You can configure this by clicking Rules on the Options menu. By default, your status changes to Away when your computer is idle for five minutes. On the Options menu, you can also set this to a longer or shorter time.

One more tip: Communicator connects to Microsoft Office Outlook to get your calendar and out-of-office appointments, so you have to enter your appointment details only once. Mostly, this automation is helpful—but sometimes you definitely don't want to be interrupted, and other times you are free despite having an appointment on your calendar. To indicate such a situation, you can submit an additional note for others to read. To do this, click your name in Communicator, click Set Note, and then type your note. However, don't forget to reset your note when it is no longer applicable.

Sabtu, 12 April 2008

How to Turn Off E-Mail Notifications

Because an e-mail notification icon appears whenever you receive new e-mail, it's tempting to stop work and open new messages immediately. But you can turn off the notification and then check your e-mail when it's convenient for you. Here’s how:
1. In Microsoft Office Outlook 2007, click Tools, click Options, click E-mail Options, and then click Advanced E-mail Options.
2. In the middle of the dialog box, clear the Display a New Mail Desktop Alert check box

How to Preview Type and Color Formatting in MS Word

How to Preview Type and Color Formatting in MS Word 
You can see how formatting will look in Live Preview before applying it to the Microsoft Office Word document you're working on. Select a formatting option (for example, click Page Layout, click Page Color, and then point to a color), and Live Preview will temporarily apply it. To keep the result, just click the color, or keep browsing for alternatives.