Excel 2000 Articles
Add the File Path to Excel 97/2000 Worksheet Headers and Footers
You can add the path and file name to the header or footer of an Excel worksheet by using a Visual Basic for Applications macro.
Adding Office Documents to a FrontPage 2000-Based Web
Microsoft Office 2000 makes it easy to incorporate your Office documents into your FrontPage-based web. Simply by saving a document to the Web folder where your FrontPage-based web is stored, you can add the document to your web.
Change How Separators Are Displayed When Importing Text Files
The Advanced Settings feature in the Text Import Wizard allows Excel to recognize numerical data even when you open text files that contain numbers that use different decimal and thousands separators than those specified in Windows Control Panel.
Choosing the Default Format for Saving New Files in Office 2000
Microsoft Office 2000 saves new files by default in the Office 97-2000 file format. There are situations, however, when you may want to use another format as the default for saving new files in Word 2000, Excel 2000, and PowerPoint 2000.
Create a Map with Microsoft MapPoint 2000 and Excel 2000
Create a map of your Excel 2000 data using Micosoft MapPoint, and then paste the map back into Excel.
Create PivotChart Reports to View Data in Microsoft Excel 2000
New in Microsoft Excel 2000 is the ability to create charts which you can pivot to show different views of data.
Distributing an Office 2000 Document to Your Team
There are several ways you can distribute a Microsoft Office 2000 document, worksheet, or presentation to your team or organization. Here are some guidelines you can use when selecting a distribution method.
E-mail a Microsoft Excel 2000 Worksheet
By using Excel 2000 and either Outlook 2000 or Outlook Express 5.0, you can e-mail a worksheet that almost anyone can view. Excel sends the worksheet as an HTML message. Recipients can view the worksheet by using any e-mail program that reads HTML format.
Enable a Different Language for Editing in Office 2000
Before working with a different language in Microsoft Office 2000 (Word 2000, Excel 2000, FrontPage 2000, Outlook 2000, Access 2000, or PowerPoint 2000), you must enable the language for editing (turn on features and options specific to that language).
Find Answers to Frequently Asked Questions in Excel Help
Answers to some of the most frequently asked questions about Microsoft Excel can be found in Excel Help. This article shows you how to find those answers!
Get and Analyze Data from the Web in Excel 2000
Do you want to analyze data from the Web in Excel 2000? Would you like to be able to update the worksheet with the latest information when you want with the click of a button? You can do this with the help of a Web query in Excel 2000.
How to Count the Unique Entries in a Column of Excel 2000 Data
If you work with long lists of data in which some columns have entries that are repeated, Excel 2000 can quickly provide information about the entries, including how many different entries there are and what the unique values are.
How to Create a Euro Conversion Table in Excel 2000
If you work with euro currencies, you can use Excel 2000 to set up a conversion table that lets you type amounts in one currency and then shows you the converted amount in euros alongside. It's quick and easy with the EUROCONVERT worksheet function.
How to Create and Maintain Excel 2000 Templates
A template is a workbook used as a model to create other workbooks. You set options and enter data in a template, and then base new workbooks on the template. This article explains how to create, store, and use Microsoft Excel 2000 templates.
How to Customize Excel Menus and Toolbars
Do you wish the Microsoft Excel 2000 menus and toolbars were organized differently, to better suit the way you work? Excel makes it easy for you to personalize and customize the menus and toolbars to suit your individual way of working.
How to Register Your Copy of Office 2000
This article explains several ways to register Office 2000, including an option for those who choose not to register during setup.
How to Use Date Migration Tools 2.0 for Excel 97/2000
The Date Migration Tools add-in program for Excel 97 and 2000 provides three wizards to help you prepare dates in Excel workbooks for the transition to the year 2000.
How to Use Your Own Labels in Excel 2000 Formulas
Cell references can make formulas hard to understand, especially when a worksheet has complex formulas. Fortunately Microsoft Excel 2000 provides an easier way: you can use row and column labels to refer to ranges of cells.
Importing Text Files of 257 or More Columns into Excel 2000
Do you have data in large text files that won't fit into an Excel worksheet? Here are some shortcuts for loading data that exceeds 256 columns into Excel 2000. You can also refresh data with the click of a button—no need to repeat steps to re-import.
Improve the Readability of an Excel 2000 PivotTable Report
Want an easy-to-scan format for a long PivotTable® report or a report you plan to print? In Excel 2000 you can quickly switch to an indented format and fine-tune the report's on-screen or printed appearance.
Install and Use Microsoft Map in Excel 2000
Microsoft Map allows you to display and analyze information by geographical region. To use this feature in Microsoft Excel 2000, you must first install the software and then add the Map command to a menu or toolbar.
Link Excel 2000 to Word 2000 to Store Data More Efficiently
Instead of manually copying and pasting information from Excel 2000 to Word 2000 every time that you change your worksheet/spreadsheet, you can just insert a link to Excel from Word and update your data automatically.
Make Excel 2000 Charts More Compelling by Adding Images to Them
In Microsoft Excel 2000, you can make your charts even more compelling and viewer-friendly by adding pictures to chart data markers, the plot area, the chart area, and more. This article tells you how.
Microsoft Office 2000 Accessibility
Learn about the Accessibility improvements in Office 2000.
Opening Microsoft Works Files in Excel 2000
Microsoft Excel 2000 can open Microsoft Works files saved in the Microsoft Works 2.0 (or earlier) format. To open Microsoft Works 3.0 or 4.0 files in Microsoft Excel, you must first save them in a different format.
Opening Quattro Pro Files in Excel 2000
In Microsoft Excel 2000, you can work with files from different versions of Quattro Pro.
Protecting Office 2000 Documents from Macro Viruses
To protect documents from macro viruses, you need to select an appropriate security level in Microsoft Office 2000.
Publish Interactive Data to the Web by Using Excel and FrontPage
Use Microsoft Excel to publish interactive worksheets and charts on a Web page. Then, open the document in Microsoft FrontPage 2000 and customize the page.
Restoring Your Default-Language Spelling Checker in Excel 2000
In Microsoft Excel 2000 you can check spelling in multiple languages. When you check spelling in another language and then return to your default language, Excel might not be able to initialize the spelling checker.
Set Up Office 2000 and Your Computer to Work in Another Language
Read this article to learn how to set up your computer and Microsoft Office 2000 (Word 2000, Outlook 2000, Excel 2000, Access 2000, PowerPoint 2000, FrontPage 2000, or Publisher 2000) to work in a different language.
Set Up Your Keyboard to Work in Another Language in Office 2000
Learn to use the right keyboard layout for the language you want to type in Microsoft Office 2000 (Word 2000, Outlook 2000, Excel 2000, FrontPage 2000, Access 2000, Publisher 2000, or PowerPoint 2000). Also learn about Microsoft Visual Keyboard.
The Euro Currency Symbol in Excel 2000 File Conversions
If you plan to convert Microsoft Excel 2000 data that includes the euro currency symbol for use in another program, you'll want to know in advance whether the format you're converting to supports the symbol.
The One Excel 2000 Keyboard Shortcut Everyone Should Know
List of the most common keyboard shortcuts for Microsoft Excel 2000.
Use the Group Command in Excel 2000 to Show and Hide Data
With the Group command in Excel 2000, you can maintain one worksheet, then show or hide certain details for different audiences.
Use Workbooks in Different Versions of Microsoft Excel
If you work with different versions of Microsoft Excel, you will want to know how to open and save workbooks and worksheets from each version.
Using Office HTML Filter at the Command Prompt
Describes how to use Office HTML Filter from the MS-DOS command prompt. The filter reduces HTML file size of Web pages created in Word 2000 and Excel 2000.
Using Office HTML Filter to Remove Office-specific Markup
Provides information about the HTML, XML, VML, styles, attributes, and other markup that is removed by using Office HTML Filter and what Office features are affected when you use the filter on Web pages created by using Word 2000 and Excel 2000.
Using Office HTML Filter to Save Space on Web Servers
Describes how to use Microsoft Office HMTL Filter to reduce HTML file size of Web pages created in Word 2000 and Excel 2000.
Ways to Publish Excel 2000 External Data Ranges to the Web
An external data range is data from a separate database that you've brought into Microsoft Excel 2000. You can publish external data to a Web page in several ways, depending on what capabilities you want to make available to users of your Web page.
Ways to Select and Hide Items in PivotTable Fields in Excel 2000
When a field in a Microsoft Excel 2000 PivotTable report has hundreds of items, you need a quick way to select and hide the ones you want. This article shows you some tips for using the drop-down list in a field to quickly display the items you want.
Working with Document Windows in Microsoft Office 2000
If you are upgrading from another version of Microsoft Office, you may have noticed changes in the way documents, workbooks, and presentations are displayed in Office 2000.
More Articles: Articles about the Office 2000 suite
Learn more about using Office 2000 applications by reading these articles.
In Response to Your Online Comments about Excel
In Response To Your Online Comments provides topics that respond directly to Help questions you send to Office Update.
