127. How to Create Tables to Your Own Specifications
128. How to Upgrade Old Documents to 2007 Versions
129. How to Find Tooltips for Keyboard Shortcuts
127. Create Tables to Your Own Specifications
Want to add a table with specific dimensions to your Word document? Here’s how:
1. Position the cursor on the area of the document where you want to insert your table.
2. On the Insert tab of the Ribbon, click Table, and then click Draw Table.
3. Define the table size. Right-click to select the area where you want the table to appear.
4. Use the mouse to draw the internal table lines the way you want them. To erase any lines you've drawn by mistake, press the SHIFT key, and the pointer will change from a pencil to an eraser.
Note: The design tools in Microsoft Office Word 2007 give you plenty more features—for example, the ability to create other tables within those you've already designed.
128. Upgrade Old Documents to 2007 Versions
If you receive a document from a colleague who is not yet running the 2007 Microsoft Office system, the 2007 Office system will automatically open it in Compatibility Mode. However, not all the new features will be available to you. When you close the document, it will be saved in its original format, not in the format of the 2007 release.
If you want to upgrade the file to the 2007 Office system:
1. Click the Office button, and then click Convert.
2. In the Microsoft Office Word dialog box, click OK, and then click Save.
Note: You may want to make a backup copy of the file before you upgrade it. Also, to see when you are working in Compatibility Mode, look at the top of the screen. The phrase Compatibility Mode will appear in brackets to the right of the file name.
129. Find Tooltips for Keyboard Shortcuts
If you press and hold the ALT key, tooltips appear above the commands at the top of the page. You can then press the appropriate letter for a simple keyboard shortcut.
How to Upgrade Old Documents to 2007 Versions
How to Derive a Strategic Value Score for Projects
124. How To use Task Updates and Timesheet Submittal and Approval
125. How to Derive a Strategic Value Score for Projects
126. How to Create a Project Proposal
124. Task Updates and Timesheet Submittal and Approval
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, non-project work, and non-working 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.
125. Derive a Strategic Value Score for Projects
You can use the intuitive Prioritization Wizard in Portfolio Optimizer to derive a strategic value score for projects. Here’s how:
1. In the Builder Scorecard, select an organization, and then in the main navigation bar, click Optimizer.
2. Click the Analyze link to open the Open Dialog page in the Prioritization Wizard.
3. Select a completed pair-wise comparison matrix and impact matrix, and then start the Prioritization Wizard.
4. Click the button to automatically derive the business driver priorities.
5. Click the button to open the project to business driver impact matrix.
6. Click the button to automatically derive a strategic value score for each project.
126. Create a Project Proposal
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 with tasks or resources with a resource plan or build team.
5. Click Publish. You have now created a complete Project proposal, pending approval.
Labels: MS Office, MS Office Project
How to Move PowerPoint Pictures Around Quickly
121. How to Move PowerPoint Pictures Around Quickly
122. How to Add More Levels of Undo
123. How I can Turn Any 2-D Shape into a 3-D Object
121. Move PowerPoint Pictures Around Quickly
Microsoft Office PowerPoint 2007 removes the hassle normally involved in adjusting the size and position of overlapping images on slides. You can simply drag one picture over another. The top picture will become transparent, so that you can position it accurately over the other.
122. 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.
123. Turn Any 2-D Shape into a 3-D Object
Want to convert a flat shape in Microsoft Office PowerPoint 2007 into a 3-D object? Here’s how:
1. With a slide open, click the Insert tab, and then select any shape from the Shapes ribbon. Alternately, select a shape you have created yourself.
2. Click the slide's surface to add the shape to the slide.
3. Right-click the shape, and then click Format Shape.
4. Select a solid or gradient fill. This step is not required but will enhance the 3-D look of your object.
5. Transform your shape into a 3-D object. You can add depth, bevel, contour, and surface type via the 3-D Format tab.
6. Give perspective to your 3-D shape. Rotate the object via the 3-D Rotation tab.
Labels: MS Office, MS PowerPoint
How I can Attach Files to Pages of Notes in Notebook
118. How To Use Taking Mobile Notes
119. How To Attach Files to Pages of Notes in Your Notebook
120. How To Record Audio and Video Clips
118. Taking Mobile Notes
Microsoft Office OneNote 2007 provides two-way synchronization with Windows Mobile–powered Smartphones or Pocket PCs so that you can stay productive no matter where you are.
To synchronize Office OneNote 2007 with your mobile device:
1. Connect the device to your computer. Microsoft ActiveSync starts.
2. When prompted, download Microsoft Office OneNote Mobile to your device.
3. Take notes on your mobile device.
4. The next time you connect your mobile device to your computer and open OneNote, the notes you took will be copied to the OneNote Mobile Notes notebook in OneNote. Information you put in the Mobile Notes notebook will be viewable on your device.
119.Attach Files to Pages of Notes in Your Notebook
You can drag or insert files onto a page in your notebook. The file appears as an icon, as in Windows Explorer, and Microsoft Office OneNote keeps track of the location of the original file (even if you move it around), so you can easily open it at any time.
1. Drag the file that you want to attach from Windows Explorer onto a OneNote page.
2. When you release the mouse button, you’ll see a dialog box. Select the Insert a copy of the file onto the page check box.
3. To open the file, double-click the file icon.
120. Record Audio and Video Clips
With your computer’s internal microphone or an external microphone attached to your computer, or a webcam or its equivalent, you can record audio and video clips by using Microsoft Office OneNote. The audio will be linked to your typed or digitally handwritten notes, so you can easily jump to specific points in the recordings by clicking the relevant typed notes.
To record audio or video clips:
1. Attach the recording device to your computer (not necessary if you're using the internal microphone on your computer).
2. Click the page on which you want to create the recording.
3. On the Insert menu, click Audio Recording or Video Recording.
4. Start and stop the recording by using the Audio and Video Recording toolbar.
5. To play back the recording, double-click the Windows Media icon on the page where you made the recording. You can skip to certain points in the recording by clicking a word in your linked text notes, and then clicking Play in the margin.
Labels: MS Office, MS OneNote
How i can Use my Own Pictures in SmartArt
115. How to Reuse Slides from a Slide Library
116. How to Use Your Own Pictures in SmartArt
117. how to Save PowerPoint Picture to Picture Files
115. Reuse Slides from a Slide Library
When you create a presentation, you may want to reuse slides already created and published by someone else in your organization. Microsoft Office PowerPoint can optionally notify you when the original slide is updated by its creator and synchronize the updated slide.
1. On the Home tab, click the New Slide icon. (Note: You must click the lower half of the icon to choose the types of slide that you want to insert.)
2. Click Reuse Slides at the bottom of the New Slide gallery.
3. In the text box below Insert slide from, type the Web address of the Microsoft SharePoint slide library that contains the slides that you want to reuse. PowerPoint retrieves a list of slides available from this location. Notice that as you pause on each of the slides, you can get a more detailed look at its contents.
4. Click a slide that you want to add to your presentation. If you want to be notified if this slide changes, select the Tell me when this slide changes text box.
116. Use Your Own Pictures in SmartArt
You can insert your own pictures into Microsoft SmartArt graphics in your presentation.
1. Click the Insert tab on the Ribbon, click SmartArt, and then click the SmartArt graphic that you want to insert.
2. Select the picture that you want to add to your presentation.
3. Right-click an individual shape in SmartArt, and then click Paste to insert the picture you selected.
4. Repeat steps 2 and 3 for each shape.
5. Complete your presentation by applying your preferred background design.
117. Save PowerPoint Picture to Picture Files
To save a picture from a Microsoft Office PowerPoint 2007 presentation in any popular picture format:
Right-click the image, click Save as, and then click Picture.
Labels: MS Office, MS PowerPoint
How i can use Windows Mail
112. How to Navigation with the Address Bar
113. How to use Command Prompt
114. How to use Windows Mail
112. Navigation with the Address Bar
After you open a folder in Windows Vista, you will see the address bar at the top of the Explorer. Each folder is part of the hierarchical structure of your system. The top level is your computer, desktop, and so on. Under the top level is the user level, and user folders are under that level. The address bar shows this structure from left to right; with each level, you can use a flyout arrow to display and browse to the folder available on that level.
113. Command Prompt
You can run your programs via the command prompt as follows:
1. Click Start.
2. Type command in the Quick Search box.
3. Click Command prompt.
Alternately, you can simply type the program name in the Quick Search box, and use any parameters that may be required.
114. Windows Mail
Windows Vista includes a program that can provide you with communications and e-mail access. Although not as comprehensive as many e-mail and communication software packages, it does offer basic management capabilities.
Here’s how to access Windows Mail:
1. Click Start.
2. Click All Programs.
3. Click Windows Mail.
Labels: Microsoft Vista, Windows Vista
How I can Pre-define the Format for Pasting in Word 2007
109. How to use Line Breaks Without Bullets
110. How to use Pre-define the Format for Pasting in Word 2007
111. How to Reuse Tables in Word
109. Line Breaks Without Bullets
When you're creating a bulleted or numbered list in Microsoft Office Word or Microsoft Office PowerPoint, you might want an item to appear in the list without a bullet or without incrementing the number. You can start a new line without a bullet by pressing SHIFT+ENTER. The next time you press the ENTER key, the new line will continue the bulleted or numbered list.
110. 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.
111. Reuse Tables in Word
To save a table in Microsoft Office Word for reuse in the future:
1. Select the table that you want to save.
2. On the Insert tab of the Ribbon, click Table, point to Quick Tables, and then click Save Selection to Quick Tables Gallery.
3. In the Create New Building Block dialog box, give the table a name, classify it with some basic parameters, and then click OK.
To reuse a saved table:
1. Position your cursor where you want to insert a saved table.
2. On the Ribbon, click Insert, click Table, and then point to Quick Tables.
3. From the list, click the table you saved previously. This table will now be inserted into the document.
How I can Derive a Strategic Value Score for Projects
107. How to Derive a Strategic Value Score for Projects
108. How to Create a Resource Plan
106. Create a Project Proposal
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.
107. Derive a Strategic Value Score for Projects
You can use the intuitive prioritization wizard in Portfolio Optimizer to derive a strategic value score for projects.
1. Select an organization in the Builder Scorecard, and then click the Optimizer link on the main navigation bar.
2. Click the Analyze link to open the Open Dialog page in the wizard.
3. Select a completed pairwise comparison matrix and impact matrix, and then start the wizard.
4. Click Next Step to derive the business driver priorities.
5. Click Next Step to open the project to business driver impact matrix.
6. Click Next Step to derive a strategic value score for each project.
108. Create a Resource Plan
Resource managers and project managers can make resource assignments to projects that have not yet been fully developed, reducing the availability of the resource for project work. You can assign resources to projects by using the following steps:
1. In Microsoft Office Project Web Access, under the Projects section of the left Action pane, click Proposals and Activity Plans.
2. On the New menu, click Activity Plan.
3. Complete your new activity plan, and then click Save (or Publish).
4. After saving, click Resource Plan on the Activity Plan page.
5. Click Build Team, click Add, and then click Save to select resources for the project.
6. On the Resource Plan page, click View Options to define the date range, resource units, and utilization settings for the resource plan, and then click Apply.
7. Define the hours for each resource in the resource plan, and then click Save (or Publish).
Labels: MS Office, MS Office Project
How i can use Automatic Save
104. How to use Automatic Save
105. How to use Meeting Notes
103.Print Information into Office OneNote 2007
Use the Microsoft Office OneNote 2007 print driver to print any document as an image into your notebook. You can annotate printed documents in your notebook, similar to printing a document and taking notes on the paper printout. You can quickly find text within these documents printed to OneNote by performing a simple keyword search.
To print a document to OneNote:
1. Open the document, such as a Microsoft Office Word document or a Web page, that you want to print.
2. Click the Office button, point to Print, and click Print.
3. Select Send to Microsoft OneNote in the list of available printers.
4. Click Print.
5. Drag the resulting OneNote page to the relevant section of your notebook.
104. Automatic Save
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.
105. Meeting Notes
You can use a preformatted page template to easily collect meeting notes and more. To select a template, click the arrow next to the New Page tab.
Labels: MS Office, MS OneNote
How I can nsert a Predefined Table
101. How to Insert a Predefined Table
102. How to Attach Multiple E-Mail Attachments Quickly in Microsoft Office Outlook 2007
100. How to Use the Bcc Field in Outlook 2007
In Microsoft Office Outlook 2007, click New to open a new e-mail message, and then click Show Bcc on the Options tab.
101. Inserting a Predefined Table
To insert a predefined table:
1. On the Ribbon, on the Create tab, click Table Templates.
2. Click a table template (Assets, Contacts, Issues, Tasks, or Events).
102. Attach Multiple E-Mail Attachments Quickly in Microsoft Office Outlook 2007
Here’s a quick way to save multiple files attached to an e-mail message.
1. Open the message, and then click Other Actions on the Ribbon.
2. Click Save Attachments. Hold down the SHIFT key while using the arrow keys to select the attachments that you want to save. Alternately, hold down the CTRL key and use your mouse to select the attachments that you want to save. Click OK.
3. Browse to a folder on your hard disk drive or to a document library on a Microsoft SharePoint site, and then click OK. The attachments will be saved to the new location.
Labels: MS Office, MS Outlook
How I can Send Contact Information in Read-Only Format
98. How to Send Contact Information in Read-Only Format
99. How to View E mails by Conversation
97. 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.
98. 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.
99. View 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.
Labels: MS Office, MS Outlook
How I can Check Address Book Entries
94. Have Tasks Appear in Your Calendar on the Day You Want to Start Them
95. How to Check Address Book Entries
96. How to Find Related Messages
94. Have Tasks Appear in Your Calendar on the Day You Want to Start Them
By default, tasks appear in your calendar on the date when they are due. You might prefer to have them appear on the date when you should begin to work on them instead. To change when your tasks appear, click View, point to Daily Task List, point to Arrange By, and then click By Start Date.
95. Check Address Book Entries
Microsoft Office Outlook 2007 will try to check that e-mail names are correct by scanning the address book as you type your e-mail message. Other checks happen when you click Send. You can force Outlook to run its e-mail completeness check (and highlight any addresses that it doesn't recognize) simply by pressing ALT+K anytime.
96. Find Related Messages
Searching for related messages in Microsoft Office Outlook 2007 is easy. Open an e-mail message, and in the Find section of the Ribbon, click Related, and then click Related Messages. Outlook quickly displays a list of related messages.
Labels: MS Office, MS Outlook
How I can set Up a Shared Notebook in Office SharePoint Server
92. How to Set Up a Shared Notebook in Office SharePoint Server
93. How to Sort Documents in SharePoint Libraries
91. 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.
92. 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.
93. 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.
Labels: MS Office, Share Point
How I can Add or Remove Styles from the Quick Style Gallery
88. How to Add or Remove Styles from the Quick Style Gallery
89. How to Quickly Know that How Many Lines or Words I Have Typed
90. How to Return to the Last Edit in a Microsoft Office Word Document
88. Add or Remove Styles from the Quick Style Gallery
The Styles gallery on the Home tab in Microsoft Office Word 2007 includes several built-in paragraph and character styles by default, such as Normal style, Heading styles 1 and 2, and Title. However, you can customize that gallery for any document or template to include just the paragraph and character styles you need to access most quickly.
To display the Styles pane, click the dialog launch icon in the lower-right corner of the Styles section (or press CTRL+SHIFT+ALT+S). To remove a style from the Quick Style Gallery, right-click the style name where it appears in the gallery, and then click Remove from Quick Style Gallery.
To add a style in the Styles pane to the Quick Style Gallery, right-click the style name, and then click Add to Quick Style Gallery. (Note that, if the style is already in the gallery, the option to remove the style from the gallery also appears here.) You can also add or remove a style from the Quick Style Gallery through the Add to Quick Style Gallery check box in the Create New Style... or Modify Style dialog boxes.
89. 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.
90. 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 I can use Security Essentials with Windows Security Center
86. How to Use Security Essentials with Windows Security Center
87. How to Preview Files
85. Saving a Search
Whenever you perform a search in a Windows Vista folder, you can save it for reuse. Saving searches can speed up your efforts to find important information, especially as you save more and more files. Here’s how:
Click Save Search. The search file is saved in a separate folder under your user folder, titled Saved rches.
86. Security Essentials with Windows Security Center
Windows Security Center is located in Control Panel in the Security group, and it provides access to Windows Firewall, updating, and other security settings. You can check here to make sure you have some level of security on your systems. Windows Vista will even assist you in finding tools that help protect against viruses and malicious software, for an additional level of security.
87. Preview Files
Windows Vista offers a preview pane for certain files that have viewers available. Some files use default viewers; additional views are available or included with applications.
Here’s how to see a preview: In the Explorer, click Organize, click Layout, and then click Preview Pane. (Note: Rendering a preview uses system resources, so use appropriate consideration.)
Labels: Microsoft Vista, Windows Vista
How I can List my Contact in the Groove Public Directory
83. How to Setting Permissions
84. How to Add and Deleting Tools
82. List Your Contact in the Groove Public Directory
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.
83. Setting 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.
84. Adding and Deleting Tools
Most workspaces begin as a Standard Workspace, which includes a Files tool and a Discussion tool. You and your team members can add more tools at any time to meet your needs.
To add a tool to your workspace, click the plus sign (+) next to the tool tabs at the bottom of your workspace, and then select the tool that you want from the pop-up list. The tool appears quickly for every member who is online and for others when they come online.
To delete a tool, right-click its tool tab, and then click Delete. This will delete the tool and its data from all members’ copies of the workspace.
To rename a tool, right-click its tool tab, and then click Rename.
To reorder a tool within the workspace, drag its tool tab to the location where you want it.
How I can Inspect Presentation for Comments and Metadata
80. How to Create a Photo Album
81. How to Inspect Presentation for Comments and Metadata
79. Use Table Styles
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.
80. Create a Photo Album
Using the new Photo Album feature in Microsoft Office PowerPoint 2007, you can quickly create a photo album presentation with pictures consistently sized, placed, framed, and even captioned.
To create a photo album, on the Insert tab, click Photo Album. In the Photo Album dialog box, click File/Disk under Insert picture from to locate and select your pictures. You can edit pictures, add captions to pictures, and customize the picture layout and framing format, all from the dialog box. When finished, click Create to generate the presentation.
To enable captions, in the Picture layout box, select a layout other than the default Fit to slide layout. If you have enabled captions for all pictures, the default caption text is the picture file name.
Note that if you don’t select a theme in the Photo Album dialog box, your album uses the Office theme. You can apply a different theme at any time from the Design tab.
You can edit album slides directly as in any PowerPoint presentation. Or on the Insert tab, click the arrow at the bottom of the Photo Album icon, and then click Edit Photo Album.
81. Inspect Your Presentation for Comments and Metadata
If you need to publish your presentation outside your organization, you may want to remove comments, notes hidden in the text, or other personally identifiable information. Often this type of information is added to the document in the process of creating it.
1. Click the Office button, and then on the Prepare menu, click Inspect Document. (If you haven’t saved your document yet, you will be prompted to do so.)
2. Select the items that you want the Document Inspector to look for. Most of these items will be selected by default.
3. Click Inspect to begin the inspection process.
4. You’ll receive a list of inspection results. Click Remove All next to any items you want to have removed from the document.
5. Click Close to close this wizard. You may want to resave your document now that this information is removed.
Labels: MS Office, MS PowerPoint
How I can View All the Text in my Columns
76. How to use Fill In the Blanks in Spreadsheets the Easy Way
77. How to View All the Text in Your Columns
78. How to Fill a Selected Range with the Same Data
76. Fill In the Blanks in Spreadsheets the Easy Way
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.
77. 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.
78. 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 I can Set the Print Area in Microsoft Office Excel
74. How to Create a Linear Series of Values in Excel
75. How to Change Gridline Colors
73. 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.
74. Create a Linear Series of Values in Excel
Here’s how to use Auto Fill to create a series of values:
1. Create the initial series. In a Microsoft Office Excel workbook, type 1 in the A1 cell and 2 in the A2 cell.
2. Select cells A1 and A2.
3. Click the Auto Fill handle (the little black box in the lower-right corner of the selection) and drag to A15 to fill the cells with the numbers 1 through 15. You can create different series of numbers, odd and even numbers, or even dates.
75. Changing Gridline Colors
You can change the look of your worksheet.
1. With a Microsoft Office Excel worksheet open, click the Office button, click Excel Options, and then click Advanced.
2. Under Display options for this worksheet, select the gridline color of your choice.
3. Click OK.
How I can Work with Windows SharePoint Services in access
71. How to Insert Predefined Fields
72. How to Work with Windows SharePoint Services
70. Modifying Data Types
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.
71. Inserting Predefined Fields
To insert a predefined field:
1. In datasheet view, on the Ribbon, in the Fields and Columns section, click New Field.
2. In the Field Templates pane, select the field you want, and then drag it to your table.
72. Working with Windows SharePoint Services
Microsoft Office Access 2007 is deeply integrated with Windows SharePoint Services to offer a Web-based user interface, alerts, revision history, RSS feeds, a Recycle Bin, and central IT manageability. To take advantage of the capabilities offered by Windows SharePoint Services, you must move your data to the server and create a link between each Access table and the Windows SharePoint Services lists.
To move data to Windows SharePoint Services:
1. Close all open objects in Access.
2. On the External Data tab, click Move to SharePoint.
3. Type the URL of a site to which you have editing rights, and then click Next. If you want to save a copy of the Access data, click Browse, and then select a document library. Access creates a Windows SharePoint Services list for each Access table.
After your data moves to Windows SharePoint Services, you cannot change the table schema in Access. You must modify the Windows SharePoint Services list. For quick access to the list from Access, right-click the orange table icon, and then on the SharePoint List Options shortcut menu, click Open Default View.
How I can use Custom Slide Layout 2003 to 2007
68. How to use 2003 to 2007 Insert Chart
69. How to use 2003 to 2007 Workflow
67. 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.
68. 2003 to 2007 Insert Chart
Microsoft Office PowerPoint is a presentation program, not a data analysis tool. Why then does inserting a chart in a Microsoft Office PowerPoint 2003 presentation open a separate datasheet object for customizing chart data? Instead, you can work with chart data in a program that was designed to handle it—Microsoft Office Excel 2007.
1. In Microsoft Office PowerPoint 2007, click the Insert tab, and then click Chart in the Illustrations group.
2. Select the chart type you want, and then click OK. Notice the split-screen PowerPoint 2007/Excel 2007 view, in which you can edit your chart data in a familiar Excel environment.
3. To resize the chart data range, drag the lower-right corner of the range in Excel 2007 and watch the chart dynamically adjust on your PowerPoint 2007 slide.
69. 2003 to 2007 Workflow
Routing a Microsoft Office 2003 Editions document for approval or review often means sending it as an e-mail attachment. Unfortunately, doing so creates multiple copies of the same document and requires the document owner to manually merge all the returned documents together. Alternately, you can place the document on a centralized file share, but approvers and reviewers must have access to the share, and they may have trouble if more than one of them attempts to access the document at the same time.
With the 2007 Microsoft Office system and Microsoft Office SharePoint Server 2007, you can initiate and participate in automated document workflows from within the application. To initiate a workflow:
1. Save the document to a SharePoint document library.
2. Click the Office button, and then click Workflows.
3. Select the workflow you want, and then click Start.
4. Enter the workflow participants, type a personal message, select the number of days or weeks allowed for completion, and then click Start.
The document will be automatically routed to the first approver's Inbox, where he or she can review the document and then click Edit This Task in the Outlook 2007 Reading Pane to approve or reject the workflow task. If the task is approved, the document is routed to the next approver in line. There is one version of the file, and the process runs automatically until it is completed or rejected by an approver; in both cases, you are notified and can take further action if necessary.
Labels: 2003 vs 2007, MS Office
How I can find Correct Format for Excel Formulas
65. How I can Easily Insert Rows or Columns in Excel
66. How to Previewing Charts in Grayscale
64. Find the Correct Format for Excel Formulas
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.
65. Easily Insert Rows or Columns in Excel
With a Microsoft Office Excel document open, you can insert extra rows and columns by holding down the SHIFT key while you grab a cell by its handle and drag it. Excel will insert as many cells as needed
66. Previewing Charts in Grayscale
You can preview your charts in Microsoft Office Excel before you print.
1. Open the file that you want to print, click the Office button, point to Print, and then click Print
Preview.
2. On the Print Preview ribbon, click Page Setup, click Sheet, and then click Black and white. The
preview will be in grayscale so that you can evaluate whether the contrast is good enough to distinguish the lines, bars, and columns.
How I can Create an Electronic Business Card for my Signature
62. How to Create an Electronic Business Card for Your Signature
63. How to Setting Up Meetings in Outlook 2007
61. Gain Greater Control over Your Out-of-Office Message
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.
62.Create an Electronic Business Card for Your Signature
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.
63. Setting Up Meetings in Outlook 2007
If you're tired of making phone calls to set up meetings, you can use Microsoft Office Outlook 2007 to schedule a meeting.
1. On your calendar's sidebar, click Send a Calendar Request via E-mail.
2. Select the date. Your meeting request will then be sent directly to the recipient.
Labels: MS Office, MS Outlook
How I can Correct a Capitalization Error and Split the Screen
59. How to Use a Voice Command
60. How to Split the Screen
58. Correcting a Capitalization Error
Here’s a simple fix for a capitalization mistake in Microsoft Office Word:
Select the text you have mistakenly typed with CAPS LOCK on, and then press SHIFT+F3. The words will revert to either lowercase or uppercase, depending on what you typed.
59. Use a Voice Command
You can use sound in Microsoft Office Word.
1. In the Word document, place your cursor where you want your voice message to go.
2. Click Insert, and then in the Text section, click the Insert Object button.
3. In the Object dialog box, on the Create New tab, in the list of object types, select Wave Sound.
4. Click OK, and then record your own voice note.
60. Split the Screen
In Microsoft Office Word, on the View tab, in the Window section, click Split. This splits the screen and displays a dividing line in the current window. To switch between the screens, use the F6 key.
How I can Identify Duplicate Values in an Excel Table
56. How to See if a Query Is Progressing
57. How to Select Excel Ranges by Using the Name Box
55. Identify Duplicate Values in an Excel Table
In Microsoft Office Excel 2007, you can easily highlight duplicate values with conditional formatting.
1. Select the list in which you want to identify duplicates.
2. Click the Home tab on the Ribbon.
3. In the Styles section, click Conditional Formatting, point to Highlight Cells Rules, and then click Duplicate Values. Pairs of duplicates will then be highlighted, and you can choose which of each pair to delete
56. See How a Query Is Progressing
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.
57. Selecting Excel Ranges by Using the Name Box
In Microsoft Office Excel, you can select a range of cells by typing it in the Name box. This is particularly useful if the range is large and will therefore take time and a lot of scrolling to select by hand.
How I can Delete E-Mail Messages Permanently
53. How to Delete E-Mail Messages Permanently
54. How to Use Outlook Calendar to Schedule Work More Effectively
52. See More in the To-Do Bar
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.
53. Deleting E-Mail Messages Permanently
To delete e-mail messages from Microsoft Office Outlook:
1. Select the e-mail messages that you want to delete. You can select messages that appear in your mailbox consecutively by holding down the SHIFT key while clicking the first and last messages that you want to delete from the list. Alternately, hold down the CTRL key while you click the individual e-mail messages that you want to delete.
2. Hold down the SHIFT key and press DELETE to permanently delete your selected e-mail messages.
3. To complete the deletion, you must confirm it in the dialog box that appears when you close Outlook.
But be careful, because permanently deleted e-mail messages are eliminated immediately, not stored in the Deleted Items folder. In other words, they cannot be recovered if you find you've made a mistake.
54. Using Your Outlook Calendar to Schedule Work More Effectively
You can allocate time slots for work activities as if they were meetings. For example, after each contact with a customer, you can schedule any resulting tasks in your Microsoft Office Outlook calendar as if they were meetings. That way you'll be less likely to forget anything, and you can allocate sufficient time to complete your follow-ups more efficiently.
Labels: MS Office, MS Outlook
How I can Integrate All Types of Communication from Outlook
50. How to Up the Calendar Quickly
51. How to Integrate All Types of Communication from Outlook
49. Answering Routine E-Mail Quickly via IM
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.
50. Up the Calendar Quickly
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.
51. Integrate All Your Types of Communication from Outlook
Suppose you are working in Microsoft Office Outlook 2007 and want to call the person who sent you an e-mail message. Or perhaps you want to send the person an instant message but don’t know whether he or she is online. By using the integrated presence information provided by Microsoft Office Communicator 2007 and Microsoft Office Live Communications Server 2007, you can easily initiate a phone call or even an instant messaging conversation.
Labels: MS Office, MS Outlook
How I can Research Unfamiliar Words and Phrases in Word
46. How To Research Unfamiliar Words and Phrases in Word
47. How To Generate Random Text in Word 2007
48. How to Save and Reuse Tables
46. Research Unfamiliar Words and Phrases in Word
1. Open the Research pane:
a. To access the Research pane quickly, press ALT and click the word that you want to check.
b. To research a phrase, select the phrase, press ALT, and click the selection.
2. Customize your research options. At the bottom of the Research pane, click Research options, and then choose which services you want to use. For instance, you might want to switch to the U.K. English dictionary.
47. 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.
48. Save and Reuse Tables
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 I can Publish My Calendar to Microsoft Office Online
Tips For MS Outlook Using Calender
43. How To Publish Calendar to Microsoft Office Online
44. How To Subscribe to a Web Calendar and View in Overlay Mode
45. How To Send a Calendar Snapshot
43. Publish Your Calendar to Microsoft Office Online
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.
44. Subscribe to a Web Calendar and View in Overlay Mode
You can use Web calendars to add and subscribe to calendars that cover a wide array of topics, such as industry conferences, sports schedules, or movie releases.
1. Click the calendar.
2. Click the Browse Calendars Online link.
3. On the Web page that appears, click a calendar from the list.
4. Microsoft Office Outlook asks whether you want to add the calendar to the list. Click OK.
5. The calendar will appear in Outlook, and you can view this calendar in overlay mode. To enable this view, ensure that both calendars are checked and visible side by side. Then, click the arrow on the title tab of the calendar on the right.
45. Send a Calendar Snapshot
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.
Labels: MS Office, MS Outlook
How I can Publish Items to Excel Services, Sorting And Filtering, And Create Pivot Table View
Microsoft Excel Tips
40. How to Publish Items to Excel Services
41. How to use Sorting and Filtering
42. How to Create PivotTable View
40. Publishing Items to Excel Services
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.
41. Sorting and Filtering
New options for sorting and filtering make Microsoft Office Excel 2007 the ideal tool for working with large amounts of complex data. The sorting and filtering menu is sensitive to the type of data you’re working with. To sort and filter:
1. To enable filter and sort options, do one of the following:
a. Format your data range as a table.
b. Select the headings of the columns that you want to sort or filter.
c. On the Ribbon, on the Home tab, in the Editing group, click Sort and Filter.
2. To sort, click the AutoFilter arrow in the column heading, and then select the filter mode (in Office Excel 2007, you can also filter by cell color).
3. To filter, click the AutoFilter arrow in the column heading.
a. Select individual values, and then select the filter mode.
b. Select Number Filters, Text Filters, or Date Filters for more advanced filter options.
42. Creating a PivotTable View
Microsoft PivotTable dynamic views help you change the axis that your data is organized around. To create a PivotTable view:
1. Click anywhere inside the range of data.
2. On the Ribbon, on the Insert tab, click PivotTable.
3. In the PivotTable Field List pane, check the fields that you want to visualize.
4. Rearrange your fields by dragging the row labels, column labels, and values to where you want them.
5. To add a filter, check the desired field, and drag it to the Report Filter box.
Microsoft Office Excel will display the sum of the data in the value field, but you can quickly modify the field to track other totals types, such as average, minimum value, or maximum value:
1. In the Values box, click the arrow next to the value that you want to modify.
2. Select Value Field Settings.
3. Change the setting from Sum to the desired type of calculation.
Sending a OneNote Note via Outlook E-Mail
Tips For MS OneNote Using MS Outlook
37. How to Send a OneNote Note via Outlook E-Mail
38. How to Embedding Office Files and E-Mail Messages into OneNote
39. How to Create Pages, Sections, and Notebooks
37. 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.
38. Embedding Office Files and E-Mail Messages into OneNote
In addition to the ability to cut and paste between Microsoft Office system programs, you can use Microsoft Office OneNote 2007 to embed files into a OneNote notebook. You can drag any file from Windows Explorer onto a OneNote page, or you can insert the file into the page by using the File command on the Insert menu. If you are working on a project, you probably use different types of documents to track pieces of the project. Now you can keep these documents together with everything else in Office OneNote 2007.
39. Create Pages, Sections, and Notebooks
To create a new notebook:
1. On the File menu, click New. This opens the task pane from which you can create a new page, section, or notebook.
2. On the File menu, click Print.
3. Select Send to Microsoft OneNote in the list of available printers.
4. Click Print.
5. Drag the resulting Microsoft Office OneNote page to the relevant section of your notebook.
Labels: MS Office, MS OneNote
How to remove Internet Explorer Temporary Internet Files
34. How to remove Internet Explorer Temporary Internet Files
34. How to remove Internet Explorer Temporary Internet Files
Securely Erase Browsing Tracks MRU-Blaster also supports secure removal of Internet Explorer Temporary Internet Files (cache) and Cookies, with its built-in Plugins. The Internet Explorer cache alone can take up GB (gigabytes) of space on your hard drive.
MRU-Blaster is a program made to do one large task - detect and clean MRU (most recently used) lists on your computer.
These MRU lists contain information such as the names and/or locations of the last files you have accessed. They are located ALL OVER your registry, and for almost ANY file type.
By looking at these MRU lists, someone could determine what files you opened/saved/looked at, what their file names were, and much more! (And, in many cases, the lists are displayed in drop-down menus automatically.)
With additional plug-ins that allow you to clean out your Temporary Internet Files and Cookies, MRU-Blaster enhances the protection of your privacy!
Read More at [ JavaCool Software]
Get it Here
Labels: Cookies, Internet, MRU, Registery, Safe Browsing, Security, Sytem Tools
Advanced Internet Searching Tips -II
Link to Search Engine Tips I
31. How to Searching using Microsoft Internet Explorer
32. How to use Classic search
33. How to Find a Web site when a URL doesn't work
31. Searching using Microsoft Internet Explorer with Windows XP
Search the Internet with a search engine
1. On the toolbar, click the Search button. By default, the Search Companion will appear in a separate pane on the left side. Type your search question in the box underneath What are you looking for?. Top results will appear using the MSN search engine in the right pane.
2. Click any link to open the associated Web page in the right pane of your Internet Explorer 6 window.
3. To change the default search engine, click Change Preferences, then click Change Internet search behavior.
4. Highlight a different search engine to use from the list available, and click OK.
32. Classic search
1. To search in a more traditional way, without using the companion or natural questions, click Change Preferences, then click Change Internet search behavior, click the button next to With Classic Internet search, and click OK.
2. The next time you open Internet Explorer, your new settings for search will appear.
3. In the appropriate text box, type the word or phrase you're looking for, and then click Search, Submit, or Go Get It, depending on the search engine. The search results appear in the list within the Search bar.
4. Click any link to open the associated Web page in the right pane of your Internet Explorer 6 window.
5. Any time you want to pursue another link from the search results, click it. The new Web page will open in the right pane.
6. To hide the Search bar, click the Search button on the toolbar again.
Search the Internet from the Address bar
1. In the Address bar, type a word or phrase you want to find and click Go.
2. Internet Explorer 6 will automatically take you to the most likely site.
Note: This AutoSearch feature uses only one search service to find information.
Search for text on the current Web page
1. On the Edit menu, click Find (on this page).
2. Type the text you want to find.
3. Change any settings as needed.
4. Click Find Next.
33. Find a Web site when a URL doesn't work
If the uniform resource locator (URL), or Web address, that you type in the Address bar or click in a Web page doesn't work, try this to correct the address:
1. On the Tools menu, click Internet Options.
2. Click the Advanced tab.
3. Scroll to Search from the Address bar. Under When searching,
If you want Internet Explorer to show you results, click the radio button next to Display results and go to the most likely site or Just display the results in the main window. If you want Internet Explorer to choose the best match without asking first, click Just go to the most likely site. If you don't want Internet Explorer to search for a similar address, click Do not search from the Address bar.
4. Click Apply and click OK.
For More Details Go Here
Sites to Download Internet Browser
Download Google Chrome
Download Internet Explorer
Download Opera
Download Safari
Download Firefox
Link to Search Engine Tips I
Advanced Internet Searching Tips -1
Link to Search Tips II
28. How to Use Advance Internet search
29. How to Get targeted results
30. How to Define search using Boolean operators
28. Advanced Internet searching tips: Boolean searches
The Name "Search" is just a thing that everyone want to do, it may be for IT, for BIO, for School, For LAW, For Research or for anything in the World. For search whichever search engine you use, these tips will help you find what you're looking for-whether you're using Microsoft Internet Explorer or other Web browser software.
General searching
Use more than one search engine
No search engine indexes all Web sites and Web pages. So if your first search doesn't produce the results you want, try searching with at least one other search engine.
Read the About page
Many search engines have a link that leads to detailed information about how the search engine compiles and searches through information, and how to get the best results from it. Reading this page can save you a lot of time and headaches. Also, visit search engine home page links with names like How To, Search Help, and Advanced Search for searching tips.
29. Get targeted results by being specific
The more specific your search word, the more targeted your search results will be. If you search for the words Labrador retriever, for example, rather than the word dog, your search will yield fewer sites but they will be targeted to the type of dog that interests you.
Get more results by being general
If your search word is too specific, your search may yield few or no results. To get more results, try searching for a related word that is more general.
30. Define your search using Boolean operators
The major search engines let you select whether to search for the exact phrase you typed, all the words in the phrase but not necessarily together, any of the words in a phrase, and so on. A few search engines do not give you such options. In this case, you can define the search yourself by adding one or more words or symbols to your search topic.
1. AND To search for two or more terms on the same page: Type the word AND between the terms (example: sea AND kayak). Or put a plus sign right before the second term (example: sea +kayak).
2. OR To search for either of two (or more) terms on the same page: Type the word OR between the terms (example: kayak OR canoe).
3. AND NOT To search for pages that include the first term and not the second: Type the words AND NOT between the terms (example: kayak AND NOT whitewater). Or put a minus sign right before the second term (example: kayak -whitewater).
4. " " To search for an exact phrase: Enclose the phrase in quotation marks (example: "sea kayak rental").
5. () To group parts of your search: Enclose them in parentheses. For example, type kayak AND (gear OR equipment). This returns pages with both the words kayak and gear or both the words kayak and equipment.
6. * To search for various forms of a word: Add an asterisk to the end of the word (example: kayak*). This returns pages with the words kayak, kayaks, kayaked, kayaking, and so on.
Sites to visit
Boolean Searching on the Internet—a quick study from the University of Albany
Help for Searching Using Boolean Operators
Link to Search Tips II
How I Can Synchronize Office OneNote 2007 with Outlook
25. How to Synchronize Office OneNote 2007 with MS Outlook
26. How to Insert Outlook Meeting Details into OneNote
27. How to Take Notes
25. Synchronize Office OneNote 2007 with MS 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.
26. Insert Outlook Meeting Details into OneNote
When tasked with taking notes for a meeting, you can save time by first inserting details about the meeting, such as attendees, location, date/time, and agenda. Then select the meeting from your Microsoft Office Outlook calendar and paste it into your notebook.
27. Take Notes
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.
Labels: MS Office, MS OneNote
How I can Apply Formatting from Any 2007 Office Document to Any Other in Microsoft Office System
22. Apply Formatting from Any 2007 Office Document to Any Other in Microsoft Office System
23.How to Use the Floating Toolbar for Formatting
24. How to Use the Ribbon
22. Apply Formatting from Any 2007 Office Document to Any Other in Microsoft Office System
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.
23. 1. Use the Floating Toolbar for Formatting
You can use a floating toolbar to quickly change document formatting in Microsoft Office. When you use the mouse to select text that you want to change, a floating toolbar appears automatically, giving you easy access to basic formatting commands.
24. Using the Ribbon
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.
Labels: MS Office, MS Office System
How I can use 2003 to 2007 Compare Versions
19. How I can use 2003 to 2007 Compare Versions
20. How to use 2003 to 2007 Structured References
21. How I can use 2003 to 2007 Page Layout View
19. 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.
20. 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.
21. 2003 to 2007 Page Layout View
How many times have you walked to the printer and discovered that your Microsoft Office Excel 2003 worksheet didn't print as you expected? You can use the Page Break Preview view in Excel 2003 to scale your data to particular pages, but a more realistic preview of the printed page would be helpful. Page Layout view in Microsoft Office Excel 2007 presents an exact representation of the printer output of your worksheet. Page Layout view also makes it easy for you to add headers and footers to your worksheet by simply typing the text where you want it to appear. To use Page Layout view, click the View tab, and then click Page Layout in the Workbook Views section.
Labels: 2003 vs 2007, MS Office
How I can Enter the Same Value into Multiple Cells Simultaneously in Microsoft Excel
16. How to Add Rows and Columns to Spreadsheets
17. How To Enter the Same Value into Multiple Cells Simultaneously in Microsoft Excel
18. How to Avoid the Unnecessary Use of Menus in Excel and Word
16. To Enter the Same Value into Multiple Cells Simultaneously in Microsoft 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.
17. Add Rows and Columns to Spreadsheets
To add a row or column: Select any row or column, and then press the CTRL key at the same time as the PLUS SIGN (+) key on the numeric keypad.
To delete a row or column: Select the row or column, and then press the CTRL key at the same time as the MINUS SIGN (–) key on the numeric keypad.
18. Avoid the Unnecessary Use of Menus in Excel and Word
1. In your Microsoft Office Excel and Microsoft Office Word programs, place the mouse over the status bar at the foot of the program window.
2. Right-click to reveal the Customize Status Bar menu, and then select which options you want to appear on the bar.
How I can Customize Where Building Blocks Are Inserted in Your Document (Such as Cover Pages) in Ms Word
13. How to Customize Where Building Blocks Are Inserted in Your Document (Such as Cover Pages) in Microsoft Word
14. How to use Switching Cases in Word
15. How to Draw Lines in Word
13. Customize Where Building Blocks Are Inserted in Your Document (Such as Cover Pages) in Microsoft 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.
14. Switching Cases in Word
Microsoft Office Word offers several case options: lowercase (hello), title case (Hello), and uppercase (HELLO). You can switch between them very easily. Select a piece of text, and then press SHIFT+F3
15. Drawing Lines in Word
You can create a line across the page of your Microsoft Office Word document or Microsoft Office Outlook e-mail message by using just a few keystrokes.
• To create a normal line, type three consecutive hyphens, and then press ENTER.
• To create a bold line, type three underscores, and then press ENTER.
• To create a double line, type three equal signs, and then press ENTER.
Posts
