Office 2000 Tips
Office 2000 Tips
FREE Computer and Internet Technical problem solving, plus ...
Free Tutorials, Free eBooks, Free Courses, Free Guestbooks, Free Autoresponders, Free help and advice, Free Newsletter, Free Affiliate program and FREE MEMBERSHIP. Wow! Did I mention it was Free? Newbies and Oldbies alike are buzzing about the NEW Newbie Club. It's the most exciting Newbie Site ever to hit the Web. Join now - it's FREE! TheNewbieClubTake firm fontrol of your PC and totally transform your internet experience with the most unique and entertaining PC learning course on the web, no technical jargon, designed from the ground up specifically for newbies, my mom loves it. :) Hey I'm a Newbie, not a Dummy, just tell me how!
Access Your PC from Anywhere - Free Download
You’re invited to try a new remote-access telework solution that CNET says could “change your life.” Gain the freedom to work from anywhere using GoToMyPC. It’s the fast, easy and secure way to access and control your PC via any Web browser — anytime, anywhere. GoToMyPC is perfect for teleworkers, travelers and after-hours access. Installs in 2 minutes – Get Your Free Download Now!
Exclusive: Microsoft to Launch 2003 Edition of Office System Beta 2Microsoft says it will publicly launch the beta 2 release of various Microsoft Office 2003 applications--now collectively branded as Microsoft Office System--on March 20, as part of the Office team's most extensive marketing program ever. More than 500,000 worldwide customers will be able to test Office 2003 Beta 2, which includes the 2003 editions of Microsoft Word, Excel, PowerPoint, Outlook, Access, Publisher, and FrontPage and introduces two new programs--Microsoft InfoPath and Microsoft OneNote. Office 2003 Beta 2 also includes new releases of Windows SharePoint Services (formerly SharePoint Team Services) and various Microsoft-hosted services. Technical betas for other Office System products, including Microsoft Visio, Project, and Project Server, are in the planning stages. My review of Office 2003 Beta 2 will be available next week on the SuperSite for Windows .
Evidence of Microsoft's branding changes for Office were available in previous beta releases, but the Office System branding is new with beta 2. "The new Microsoft Office brand is a key element of our effort to shift perceptions of Office from a set of programs for document creation to a platform for information work that includes desktop programs, servers, and services," an internal Microsoft document reads. "This marks just the beginning of our ongoing effort to position the Office System as a strategic business asset and to communicate and deliver on a broader promise to the world." In addition, Microsoft has changed the names of all Office System products to reflect the new branding; Word is now called Office Word 2003 and so on.
Click here for more.
OFF2000: Controlling How and When the Office Assistant AppearsWhen you run any of the programs included with Microsoft Office 2000 and you use a lower screen resolution (640 x 480 for example), or if you have many windows open, or if your screen is very cluttered, you may find that the Office Assistant is too obtrusive. This article describes how to control how and when the Office Assistant appears.
All of the programs in Microsoft Office 2000 include the Office Assistant; it is available to help you with questions or problems with Office programs. To ask the Office Assistant a question, click its character and then type your question. If the Office Assistant is not visible, click Show the Office Assistant on the Help menu.
Click here for more.
OFF2000: "Error 1706" When You Switch CDs When Adding Office Features (Q254894)When you try to add a feature to your Office installation, you are prompted to insert your Office CD:
The feature you are trying to use is on a CD-ROM or other removable disk that is not available.
Insert the 'Microsoft Office 2000 edition ' disk and click OK.
NOTE : edition is the edition of Office that you have installed.
After you insert your CD and then click OK to the prompt, you receive the following message:
Error 1706. No valid source could be found for product Microsoft Office 2000 edition . The Windows installer cannot continue.
NOTE : This problem does not occur if you do not have a CD in your CD-ROM drive when you are prompted to insert your Office CD.
Click here for more.
OFF2000: Error 2932 Applying the SR-1 Update on Windows 2000 (Q254869)When you run the Microsoft Office 2000 Service Release 1 (SR-1) Update, you may receive the following error message:
Internal Error 2932: Please contact product support for assistance.
If you view the verbose log file text for the update, you see text similar to the following:
MSI (s) (A4:F8): Executing op: SetTargetFolder(Folder=E:\WINNT\Fonts\)
MSI (s) (A4:F8): Executing op: SetSourceFolder(Folder=F:\Windows\Fonts\)
MSI (s) (A4:F8): Executing op: FileCopy(SourceName=TAHOMA.TTF,DestName=TAHOMA.TTF,Attributes=8192,FileSize
Internal Error 2932: Please contact product support for assistance.
Action ended 8:14:53: InstallExecute. Return value 3.
Click here for more.
OFF2000: Error Message When You Run Office Setup: IE5WZD Caused an Invalid Page Fault in Module MSSIP32.DLL (Q254884)When you run Setup for Office, you may receive the following error message:
This program has performed an illegal operation and will be shut down.
If the problem persists, contact the program vendor.
When you click Details , you see text similar to the following:
IE5WZD caused an invalid page fault in module MSSIP32.DLL at 015f:7b4f2440
When you click Close , the error message goes away, and the Microsoft Office 2000 Setup dialog box (with CD key boxes) is displayed.
Click here for more.
OL2000: "Error 1919" Error Message If You Start Microsoft Outlook or Install Microsoft Office (Q320757)When you start Microsoft Outlook or install Microsoft Office, you may receive the following error message:
Error 1919. Error configuring ODBC data source: MS Access Database; ODBC Error. 6: Component not found in the registry. Verify that the file MS Access Database files exists and you can access it.
To resolve this behavior, export the ODBC registry key information from a computer that has Office installed and working to .reg files, import these files to the computer that is experiencing the behavior described in the "Symptoms" section of this article, and then reinstall Office.
Click here for more.
Quickly remove objects from an Excel chartIf you have a chart that contains data, value, or percent labels that you want removed, you don't have to go to the trouble of displaying the Chart Options or Format Data Series dialog boxes to get rid of them. Just click on one of the chart labels, which selects all of the labels for the data series, and press the [Delete] key. As an alternative, you can right-click on one of the labels and choose Clear from the shortcut menu.
Increase or Decrease Text SizeTo quickly increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint®, Microsoft FrontPage®, or Microsoft Publisher, first, select the text you want to resize. Then, to increase the font size, press CTRL+SHIFT+>. To decrease the font size, press CTRL+SHIFT+<.
Get an Office 2000 Tip a DayWant more tips and tricks? You can get a tip of the day delivered to you by the Office Assistant.
To get your daily tips:
Quickly Zoom In and Out of Your Office DocumentsIf you have a Microsoft IntelliMouse® pointing device, you can use the wheel button, the third (middle) button, to quickly zoom in and out of an Office document.
Simply hold down the CTRL key as you rotate the wheel button forward or back.
Note: This tip works in the latest versions of Microsoft Excel, Microsoft Word, Microsoft PowerPoint®, Microsoft Publisher, Microsoft PhotoDraw™, and Microsoft Project, as well as many other Microsoft Windows® programs. You can also use it in Internet Explorer to increase or decrease to size of text on the screen.
Add Custom Buttons to Your Access ToolboxYou can save yourself time when creating forms and reports in Microsoft Access if you add some extra buttons to your Toolbox toolbar—such as Align Left and Align Right. Then you don't have to always use the menu.
To add new buttons to the Toolbox toolbar in Access 2000:
Note: Although this tip uses Access as an example, you can use this technique to customize the toolbars in all Office 2000 programs (except Microsoft PhotoDraw).
Send an Office Document Without Opening OutlookEver need to get that important Word document to your boss in a hurry? Here's how you can do it without even opening Outlook.
Note: This tip also works in Excel and PowerPoint.
Copy and Paste up to 12 Pieces of Information at OnceIf you're constantly copying text and data between different Office programs, here's a way to save time by copying multiple items at once.
For example, you can copy a chart in Microsoft Excel, switch to Microsoft PowerPoint® and copy a bulleted list, switch to Microsoft Internet Explorer and copy a page of text, and then switch to Microsoft Word and paste the collection of copied items into your document.
Fine-Tune Your Fonts in WordWhen you're using a small font in a tight space, sometimes the 8-point font is too large to fit and the 7-point font is too small to read. Luckily, you can choose a font size that's halfway in between those two by:
Copy Formatting Using Format PainterFormat Painter copies the formatting (size, font style, color, borders, etc.) from a selected object or text and applies it to the next object or text you click.
To copy formatting in any Office 2000 program using the Format Painter:
Use Format Painter to Copy Formatting Multiple TimesThis is a tip that I share with everyone I know who uses Office. If you double-click Format Painter, you can copy the selected formatting to several locations. To turn off Format Painter, click the Format Painter button again or press ESC.
Show Shortcut Keys in ScreenTipsYou can teach yourself keyboard shortcuts for the most commonly used commands in Microsoft Word by turning on shortcut keys in ScreenTips. When you choose to show toolbar ScreenTips, you can specify that Word also display a shortcut key combination for the toolbar button.
To display shortcut keys in ScreenTips:
Show All Menu Commands in Office 2000By default, Office 2000 displays only the commands that you use most often on the new, personalized menus. Do you wish you could see all of the commands at once like you could in Office 97? Here's how.
To turn off personalized menus:
Change the Font or Size of Text Using Keyboard ShortcutsYou can use keyboard shortcuts to access the Font box and the Font Size box on the Formatting toolbar and then quickly change the font or size of selected text.
Here's how you do it:
Repeat Your Most Recent ActionFor repetitive formatting tasks, remember the F4 key. Whenever you press that key, you repeat your most recent action, whether it was adding borders, applying bold formatting to a selected word, or inserting a file or picture.
Format Painter is better for applying complex formatting, but if you just need to repeat a single action, then F4 is the key to use.
Note: This tip works in the following programs: Microsoft Excel, Microsoft PowerPoint®, Microsoft Visio®, and Microsoft Word.
Add a Screen Shot to an Office DocumentThis a great way to include screen shots in your documents.
Note: This tip works in the following Office 2000 programs: Excel, Microsoft FrontPage®, Outlook, PowerPoint, Microsoft Publisher, and Word.
Use Your Keyboard to Quickly Change the Case of TextHere's how you can use your keyboard to quickly change the case of text in Microsoft Word, select the text you want to change and press SHIFT+F3. Each time you press the F3 key, the text case switches between Title Case, UPPERCASE, and lowercase.
Paste Using the INSERT KeyDid you know that you can assign the Paste command to the INSERT key on your keyboard? That means you only have to use one key to paste the contents of your Clipboard into your document.
Here is how to set it up:
Note: Choosing this option disables the default function of the INSERT key in Microsoft Word that enables you to switch between insert typing mode to overtype mode.
What's This? Find Out What Formatting is Applied to Text in Word To find out what formatting (fonts, style, alignment, etc.) is applied to a paragraph in Word:
Don't Lose Sight of Your Column Headings in WordWhen you create a table in Microsoft Word, you can use column headings to describe what information is in each column. But if you have a table that spans multiple pages, you lose the headings after the first page, so it's hard to tell what each column topic is. Here's how to keep those headings visible:
Note: Word automatically repeats table headings on pages that result from automatic page breaks—but not if you manually insert a page break. Also, repeated table headings are only visible in Print Layout view or when you print the document.
Save All Your Word Documents at OnceIf you know the "secret" key, you can save or close all of your open documents in one step.
Type Out a Table in WordYou can create tables in Microsoft Word by simply typing out a string of PLUS SIGNS (+) and MINUS SIGNS (-).
Start the row with a PLUS SIGN (+) and then type MINUS SIGN (-) until you have the column width you want. To add a new column type PLUS SIGN (+) again. When you're done type a final PLUS SIGN (+) and press ENTER. Word turns your text into a table. To add more rows to your table, move to the last cell in the table and press TAB.
Note: If this tip doesn't work for you, then you need to turn on the AutoFormat feature in Word. To do this, on the Tools menu, click AutoCorrect. Then, click the AutoFormat As You Type tab and select the Tables check box.
Move Images in Word to the Exact Position You WantWhen you position an image in a Word document, it automatically aligns (or snaps) to an invisible grid, which helps keep everything lined up.
If you ever need exact control over the placement of your image, you can temporarily override the grid by pressing the ALT key as you drag the object into place. You'll notice that the image moves smoothly and not in increments along the grid.
Note: This tip works as long as the image is not set to be in line with the text. To make sure it works for you:
Quickly Replicate Text or Graphics in WordHere's a quick way to make copies of text or graphics in Word:
Find Your Place in Word DocumentsIf you are working on a long document, it's easy to lose your place. With Microsoft Word documents, you can pick up where you left off in your last editing session because Word keeps track of the last three locations where you typed or edited text. Just press SHIFT+F5 immediately after opening the document, and the cursor will appear at the exact point where you last made a change. To reach the previous two editing locations, press SHIFT+F5 until you reach the location you want.
Check Spelling in Only a Portion of Your Word DocumentIf you see a spelling mistake, you can correct it quickly without checking the entire document. Just right-click the misspelled word, and then select the spelling correction you want from the shortcut menu.
To find the next misspelled word in the document, press ALT+F7.
Increase or Decrease Line Spacing in WordTo quickly change the line spacing of a paragraph in Microsoft Word:
Keep Words Together with a Nonbreaking SpaceHave you ever been typing a paragraph in Microsoft Word and had a multiword phrase, such as a person's name, get separated onto two lines? You can keep that phrase or name together by inserting a nonbreaking space.
To create a nonbreaking space, select the space after each word in the phrase (except the last word), and press CTRL+SHIFT+SPACEBAR.
Take the Synonym ShortcutFind that word you're looking for fast. You can find a common synonym for a word without using the Thesaurus command. Just right-click the word and point to Synonyms on the shortcut menu. Then, click the synonym you want, and it automatically appears in place of your original word.
Word will sometimes supply antonyms for the selected word, for those times when you only know what you don't mean to say.
Get More-Precise Measurements in WordIf you use the horizontal ruler to specify the placement of tabs, margins, and page objects, this tip will help you lay out your pages with more precision. By default, ruler measurements are limited to one-tenth of an inch. For example, if you click on the ruler to set a margin or tab, you can set it at 1.5 inches, but not 1.48 inches.
To set more-precise measurements (to one-hundredths of an inch), hold down the ALT key and, while you click on the ruler or margin, make your adjustments to the tabs.
Edit Text in Print PreviewSometimes when you view a Microsoft Word document in Print Preview mode, you notice adjustments or edits you'd like to make to graphics and text. Did you know you can make those changes while you're still in Print Preview mode? Here's how you do it:
Change Your Default Folder in WordHave you noticed when you save a document for the first time, Word automatically opens the My Documents folder? If you don't use My Documents to store your work, you'll save time by setting up the folder you do use as your default working folder.
To change the default working folder for Word documents:
Use AutoFill to Quickly Copy Formulas and Formatting in ExcelWould you like an easy way to extend a series of numbers in Microsoft Excel without typing each one individually? With AutoFill, you can quickly copy data, formulas, or formatting to adjacent cells. This brief tutorial will show you how:
Show or Hide the Formulas in an Excel SpreadsheetWhen you're working in an Excel worksheet, you can alternate between viewing the values in the cells and displaying the formulas. To toggle between the different views, press CTRL+` (single left quotation mark).
Note: If you're having trouble finding the single left quotation mark, it's on the same key as the "~" symbol. On most keyboards, it's the key directly to the left of the "1" key.
Edit Cells Quickly in Excel—Without Using Your MouseIf you like to use your keyboard for everything, editing a lot of data quickly in an Excel spreadsheet can be difficult because you find yourself constantly reaching for the mouse when you want to make changes to a cell. But there's a shortcut you can use so that your hands never have to leave the keyboard—press F2. Here's how:
Create an Excel Chart with the Push of a ButtonThis is a very old Microsoft Excel trick. To quickly create a chart, using only your keyboard, select the data you want to plot and then press F11. Excel automatically creates the chart for you.
Build Your Own Hover Buttons in FrontPage 2000Have you ever wondered how to make the buttons on your Web pages change color, move, or light up when users point to them with a mouse? It's easy to do with Microsoft FrontPage 2000.
First, you'll need to create two versions of the button you want to put on your page. One version that appears when the page first loads and another slightly different version that users see when they point to the button with a mouse. You can create your graphics using Microsoft PhotoDraw™ 2000 or any drawing program you use to create graphics for the Web.
Once you've created your graphics, here's how you put them on your page:
Select an Entire Range of Cells in ExcelIn Excel, if you want to quickly select the entire range of cells you're working on, press CTRL+SHIFT+ ASTERISK (*).
For example, if you have a list of customers in Excel, this command will select the entire list and the column headings, but not the empty cells around the list—so you get only the cells you need.
This tip is different from the Select All command, which selects every cell in the worksheet—even the ones that you are not using.
Insert Copied Cells Between Existing Cells SafelyIf you want to insert a range of copied cells between other rows or columns—instead of pasting over them—there's an easy way to do it:
Format Excel Cells FastIf you want quick access to the Format Cells dialog box in Microsoft Excel to change things like type style, alignment, or borders, select the cell you want to format and press CTRL+1.
Quickly Move Between Multiple Excel Workbooks or Worksheets
When working with several Excel workbooks or worksheets (the individual pages in workbooks) at once, you can quickly move between them using shortcut keys.