Office 2000 Tips

Office 2000 Tips

Have corrupted Office files, Word, Excel or Access? OfficeFIX can help you recover your files, so you don't have to start over, OfficeFIX is a Software Suite that recovers damaged Ms Excel (all versions), Ms Access (95, 97, and 2000), and Ms Word documents (all versions including Word for Macintosh). When an Office file shows an error while trying to open it chances are it is corrupt. OfficeFIX extracts the information from the file and creates a new one that is trouble free. Restore your files easily in only 15 minutes. Check it out today!

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 2

Microsoft 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 Appears

When 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
=257636,Version=2.60.0.0,,InstallMode=58982400,PerTick=32768,IsCompressed=0
,,VerifyMedia=1,,VitalPatches=15,PatchHeaders=Binary00
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 chart

If 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 Size

To 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 Day

Want more tips and tricks? You can get a tip of the day delivered to you by the Office Assistant.
To get your daily tips:
  1. Click the Office Assistant. If the Assistant isn't visible, click Show the Office Assistant on the Help menu.
  2. Click Options.
  3. On the Options tab, select the Show the Tip of the Day at startup check box.

Quickly Zoom In and Out of Your Office Documents

If 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 Toolbox

You 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:
  1. Open an Access form or report in the Design view.
  2. On the View menu, point to Toolbars and then click Toolbox.
  3. On the View menu, point to Toolbars, and then click Customize.
  4. Click the Commands tab.
  5. In the Categories box, click Form/Report Design.
  6. In the Commands box, scroll until you find Align Left. Then click the Align Left icon and drag it on the Toolbox toolbar. Repeat to add more commands.
Now you can keep all the tools you need to create forms in one place.
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 Outlook

Ever need to get that important Word document to your boss in a hurry? Here's how you can do it without even opening Outlook.
  1. On the File menu, point to Send To, and then click Mail Recipient (as Attachment).
  2. Fill in the Receipts, Subject, and message boxes and click Send.
Or if you have Word 2000:
  1. On the Standard toolbar, click E-mail.
  2. In the To and Cc boxes, enter the recipient names separated by semicolons.
  3. By default, the name of the document appears in the Subject box. If you want, you can type your own subject name.
  4. Click Send a Copy.
Using this tip is a lot easier than going into Outlook, creating a new message, and browsing for the attachment on your hard drive.
Note: This tip also works in Excel and PowerPoint.

Copy and Paste up to 12 Pieces of Information at Once

If 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.
Here's how:
  1. In any Office 2000 program, on the View menu, point to Toolbars and click Clipboard to display the Office Clipboard.
  2. Select an item you want to copy.
  3. Copy the item into the Office Clipboard by clicking Copy on the Edit menu or clicking the Copy button on the Clipboard toolbar.
  4. Repeat steps two through four until you have copied all the items (up to 12) you want. If the item you want to copy is in another program, switch to that program first.
  5. In an Office program, click where you want to paste the items.
  6. To paste all the items at once, click Paste All on the Clipboard toolbar. Or to paste the items one at a time, click the icon for the item you want to paste.

Fine-Tune Your Fonts in Word

When 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:
  1. Selecting Font from the Format menu.
  2. Then, on the Font tab, typing 7.5 in the Size box and clicking OK.
This tip works with any size true type font (think 250.5)—not only in Word but also in Excel.

Copy Formatting Using Format Painter

Format 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:
  1. Select the text or object that has the formatting you want to copy.
  2. On the Standard toolbar, click Format Painter. (In Access the Format Painter is found on the Database toolbar.)
  3. Select the text or object you want to apply the formatting to, and the formatting appears automatically.

Use Format Painter to Copy Formatting Multiple Times

This 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 ScreenTips

You 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:
  1. On the Tools menu, click Customize, and then click the Options tab.
  2. If it's not already selected, select the Show ScreenTips on toolbars check box.
  3. Select the Show shortcut keys in ScreenTips check box.
Editor's Note: When you select the Show shortcut keys in ScreenTips check box, the setting affects all Office programs except Microsoft Excel.

Show All Menu Commands in Office 2000

By 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:
  1. On the Tools menu, click Customize, and then click the Options tab.
  2. To show all the commands on the menus, clear the Menus show recently used commands first check box.
You can do this from any Office 2000 program, and it applies to all of your other Office programs as well.

Change the Font or Size of Text Using Keyboard Shortcuts

You 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:
  1. Select the text you want to change.
  2. Press CTRL+SHIFT+F to access the Font box or CTRL+SHIFT+P to access the Font Size box.
  3. Press UP ARROW or DOWN ARROW to select the font name or size you want.
  4. Press ENTER to accept the font name or size.
Note: This tip works in the following Office 2000 programs: Microsoft Excel, Microsoft FrontPage®, PowerPoint, Microsoft Publisher, and Word.

Microsoft Word is the world's favorite word processing program If you don't have it on your computer, chances are you eventually will. And yet, like most software, its huge range of features and creative benefits remain hidden behind a wall of difficult and boring help files. But not any more! MS Word MAGIC! is the latest stunning ebooklet from The Newbie Club, and it's so full of screen captures, pictures, and Newbie-Speak exercises, you'll wonder how on earth they keep the price down to only $9.95! Read about it at TheNewbieClub. It's brilliant!
AD

Repeat Your Most Recent Action

For 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 Document

This a great way to include screen shots in your documents.
  1. If you are working with multiple windows, click the one you want to make an image of to make that window active.
  2. Press ALT+PRINT SCREEN to copy an image of the current window.
  3. To paste the image into a document, click the Edit menu in that document, and then click Paste.
You can also take a screen shot of your entire screen by pressing PRINT SCREEN.
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 Text

Here'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 Key

Did 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:
  1. On the Tools menu, click Options, and then click the Edit tab.
  2. Select the Use the INS key for paste check box to enable this feature.
  3. Click OK.
Now, each time you press the INSERT key, you will paste the contents of the Clipboard into your document.
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:
  1. On the Help menu, click What's This?.
  2. When the pointer becomes a question mark, click the text you want to check. Then a message will appear describing the formatting in that section.
  3. When you have finished checking your text, press ESC.

Don't Lose Sight of Your Column Headings in Word

When 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:
  1. Select the first row or rows of your table.
  2. On the Table menu, click Heading Rows Repeat.
Now Word automatically repeats the table headings at the top of subsequent pages.
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 Once

If you know the "secret" key, you can save or close all of your open documents in one step.
  1. Hold down SHIFT and click the File menu. When you hold down SHIFT, two new options appear on the File menu: Close All and Save All.
  2. To save all your open documents at once, click Save All. Or, to close all your open documents, click Close All; Word will prompt you to save your changes before closing any documents.

Type Out a Table in Word

You 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 Want

When 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:
  1. Double-click the image, and select the Layout tab.
  2. Under Wrapping style, choose any style except In line with the text.
  3. Then, click OK.

Quickly Replicate Text or Graphics in Word

Here's a quick way to make copies of text or graphics in Word:
  1. Select the item or text you want to copy.
  2. Press and hold down the CTRL key.
  3. Then use the mouse to drag the item to the desired position.
A copy of the original item is made right where you want it. This is helpful when you're creating a document that will include a lot of repeated text or images.

Find Your Place in Word Documents

If 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 Document

If 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 Word

To quickly change the line spacing of a paragraph in Microsoft Word:
  1. Select the text you want to change.
  2. Do one of the following:
    • To set line spacing to single-space lines, press CTRL+1.
    • To set line spacing to double-space lines, press CTRL+2.
    • To set line spacing to 1.5-line spacing, press CTRL+5.

Keep Words Together with a Nonbreaking Space

Have 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 Shortcut

Find 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 Word

If 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 Preview

Sometimes 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:
  1. Click Print Preview on the File menu.
  2. Click the text in the area you want to edit. Word zooms in on the area.
  3. Click Magnifier on the Print Preview toolbar. When the pointer changes from a magnifying glass to an I-beam, you can begin making your changes to the document.
  4. To exit Print Preview and return to the previous view of the document, click Close.

Change Your Default Folder in Word

Have 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:
  1. On the Tools menu, click Options, and then click the File Locations tab.
  2. In the File types list, click Documents.
  3. Click Modify.
  4. To select an existing folder to display as the default working folder, locate and click the folder you want in the folder list. To create a new folder to display as the default working folder, click Create New Folder, and then type a name for the new folder in the Name box.

Use AutoFill to Quickly Copy Formulas and Formatting in Excel

Would 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:
  1. Select the cells that you would like to copy.
  2. Move the cursor to the bottom right corner of the highlighted cells. Your cursor will then turn into a black plus sign.
  3. Click and hold down the right mouse button and drag across the cells you want to fill.
  4. Release the mouse button, and when the shortcut menu appears, click Fill Series.
By following these steps, you will be able to save a lot of time creating your spreadsheets.

Show or Hide the Formulas in an Excel Spreadsheet

When 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 Mouse

If 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:
  1. Use the arrow keys to select the cell you want to edit.
  2. Then press F2 (or COMMAND-U, if you use a Macintosh computer) to edit the cell contents.
  3. When you're finished, just press ENTER (or RETURN on a Macintosh keyboard) to enter your changes. Or press ESC to cancel the changes.

Create an Excel Chart with the Push of a Button

This 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 2000

Have 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:
  1. On the Insert menu, click Component, and then click Hover Button.
  2. In the Link to box, enter the URL of the page or file you want to display when the button is clicked.
  3. In the Button text box, type the text label for the hover button. Leave this box blank if the graphic you created already contains a text label.
  4. Click Custom.
  5. In the Button box, enter the URL to the picture you want users to see when they first open the page.
  6. In the On hover box, enter the URL to the picture you want users to see when they put a mouse over the button. Then click OK.
  7. In the Width and Height boxes, type the width and height of the picture in pixels, and then click OK. The size of the hover button must match the size of the picture you use for the hover effect.
And if you don't have graphics already created, you can select one of the built-in hover effects in FrontPage 2000, such as Glow or Bevel, to quickly add interactivity to any page on your site.

Select an Entire Range of Cells in Excel

In 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 Safely

If 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:
  1. Select the cells you want to copy.
  2. On the Edit menu, click Copy.
  3. Select the area on the worksheet where you want to place the copied cells.
  4. Press Ctrl + SHIFT + Plus Sign (+).
  5. In the Insert dialog box, click the direction you want to shift the surrounding cells, and press OK.
Now, the copied cells are inserted right where you want them, and none of your existing information is lost.

Format Excel Cells Fast

If 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.
  • To move between open workbooks, press CTRL+TAB.
  • To move to the next sheet in a workbook, press CTRL+PAGE DOWN.
  • To move to the previous sheet in a workbook, press CTRL+PAGE UP.

    Completely Delete Cells in Excel Using This Shortcut

    Have you ever wanted a keyboard shortcut that completely deletes a cell from your worksheet, including the formatting and comments? Just select the cells you want to delete, and then press CTRL+MINUS SIGN (–). The surrounding cells will shift to fill the space.
    This is different from using the DELETE or BACKSPACE keys, which simply clears the contents of a cell without actually deleting it.

    Quickly View All Worksheet Formulas in Excel

    With a quick keystroke, you can display all the formulas in your worksheet, including the serial values Excel uses to store dates.
    To alternate between displaying cell values and displaying cell formulas, press CTRL+` (single left quotation mark, which usually can be found above the TAB key).

    Add a Calculator to the Excel Toolbar

    Did you know that you could add a calculator to your Microsoft Excel toolbar? Here's how:
    1. On the View menu, click Toolbars, and then click Customize.
    2. Click the Commands tab.
    3. In the Categories list, click Tools, and in the Commands list, click Custom (the one with the gray calculator graphic).
    4. Drag the selected command from the Commands list to a toolbar. (Lift your finger from the mouse when you see a plus sign next to your pointer.)
    5. Click Close.
    Now click the button you just added to run the calculator.

    Paste Information from Excel as a Picture

    Do you want to place an image of an Excel file into a Word document, image editing program, or other program? It's easy to do.
    1. On the Excel worksheet or chart sheet, select the cells or click the chart or object you want to copy.
    2. Hold down SHIFT and click Copy Picture on the Edit menu.
    3. For best picture quality, make sure As shown on screen and Picture are selected, and then click OK.
    4. Click the worksheet or other document where you want to paste the picture.
    5. Click Paste on the Edit menu.
    To make adjustments to the image after you've pasted it, use the Picture toolbar. (To open it, point to Toolbars on the View menu and click Picture.)

    Protect Cells Using Data Validation

    Here's a creative way to protect cells in an Excel worksheet so that other users can't make changes to them:
    1. Select the cells you want to protect. (It's a good idea to make a note of the cells you protect in case you need to remove that protection later.)
    2. On the Data menu, click Validation, and then click the Settings tab.
    3. Set the following restrictions: In the Allow box, click Text Length; in the Data box, click between; in the Minimum box, type 10000; and in the Maximum box, type 50000.
    4. Click the Error Alert tab.
    5. Make sure the Show error alert after invalid data is entered check box is selected. In the Style box, click Stop.
    6. If you want a title to appear in the title bar of the message or in the Office Assistant balloon if the Office Assistant is displayed, type the text in the Title box. If you leave the Title box blank, the title defaults to Microsoft Excel.
    7. If you want to display your own text for the message, type the text in the Error message box, up to 225 characters. Press ENTER to start a new line in the message. If you don't enter any text in the Error message box, the message displays the following: "The value you entered is not valid. A user has restricted values that can be entered into this cell." Excel displays the message only when a user types data in the cell.
    To remove data validation settings, select the protected cells, click Validation on the Data menu, and then click Clear All.

    Forward an Outlook Contact to Someone Else

    If you have contacts stored in Outlook that you'd like to send to other people, it couldn't be easier. Just go to your Contacts folder, right-click on the contact you want to send, and then click Forward. A brand-new e-mail message will be created with that contact included as an attachment. Just enter the e-mail address of the people you want to forward it to and click Send.
    When the recipients receive the contact, all they have to do is to drag the attachment onto either the Contacts icon in the Outlook Shortcuts bar or onto the Contacts folder in the folder list; it will be added automatically to their contacts list.

    Too Much Love? Outlook Can Automatically Delete Unwanted E-mail

    The Outlook Rules Wizard paid off for me during the recent influx of unwanted ILOVEYOU messages. With the Rules Wizard, I have been automatically deleting any e-mail messages I receive with the following keywords in the Subject box: "ILOVEYOU," "I LOVE YOU," and "FWD: JOKE." Now they don't clog up my Inbox, and I can't open them up accidentally.
    To use the Rules Wizard to automatically delete any e-mail with the subject "ILOVEYOU":
    1. Click Inbox. Then, on the Tools menu, click Rules Wizard.
    2. Click New.
    3. Click check messages when they arrive, and then click Next.
    4. Select the check box next to with specific word in the subject.
    5. In the text area below, click the blue, underlined phrase specific words.
    6. Here you can specify which words Outlook should look out for. For example, in the Add New text box, enter ILOVEYOU and then click Add. Repeat for any additional terms you want to check for. When you're done, click OK and then click Next.
    7. Select delete it.
    8. Click Finish.
    To apply the rule to e-mail already in your Inbox, click Run Now. In the Select rules to run list, select the check box next to the rule you just created, and click Run Now. This will delete all e-mail in your inbox with the subject "ILOVEYOU." When the process is complete, click OK.
    Now, anytime you get e-mail with the subject "ILOVEYOU," Outlook will automatically move it to your Deleted Items folder. The e-mail will still be available in your Deleted Items until you empty the folder.

    Add Contacts Quickly in Outlook 2000

    If you receive an e-mail message from a person whom you want to add to your Outlook contact list, here's a quick way to do it:
    1. Open the e-mail message that contains the name you want to add to your contact list.
    2. In the From box, right-click the name you want to make into a contact, and then click Add to Contacts on the Shortcut menu.
    This creates a new contact with that person's name and e-mail address already filled in. You can also fill in any additional information you have about that person, such as a phone or fax number, and then save it in your Contacts folder for easy access.

    Drag Addresses Between To, Cc, and Bcc Fields in Outlook

    When composing or replying to an e-mail message in Outlook, you can easily rearrange the names of the people receiving the message by dragging their e-mail addresses between the To, Cc, and Bcc address fields. Just select the name or names you want to move and drag them into the destination field.