\paperw8640 \margr0\margl0\ATXph0 \plain \fs20 \f1 \b Range Finder\par
\b0 Excel 97 employs a colour to simplify formula building and editing. When users double-click on a cell containing a formula, coloured frames appear around the range of cells that corresponds to different parts of the formula. \par
\par
Each range of cells within the formula is also colour-coded so that it is easy to distinguish which cells contribute to which parts of the formula. You can quickly modify the dimensions of a range by grabbing and moving the frame handle of the colour-coded area.\par
\par
\b Web navigation and searching\par
\b0 Using the new Hyperlink() function, users can connect and manage documents by allowing users to create hyperlinks to documents or Web addresses. Other features include Web FastFind, and open from URL.\par
\par
\b Online publishing\par
\b0 Working effectively in a connected environment means that users must be able to publish information online as easily as they now print and save. This can be done within the new Excel 97 online environment using features such as: Save as HTML, Save to URL, Microsoft Excel Viewer, Web Form Wizard and Microsoft Excel 97 HTML tags.\par
\par\par
\b Custom cells\par
\b0 Users have frequently requested formatting options that 'go beyond the grid' of the traditional spreadsheet. In Excel 97 you can modify text and data in ways that go beyond conventional spreadsheet rules, including: rotate text; indent text; merge cells and autosize cells.\par
\par
\b Conditional Formats\par
\b0 User want to be able to easily spot trends or areas of concern in their data at a glance. In Microsoft Excel 97, the new conditional formatting feature gives users this functionality through a simple dialog.\par
\par
Using Conditional Formatting, users can apply their own formats to worksheets based on dynamic, datadriven conditions. Conditional Formatting makes it easy for the user to create rules by choosing options from the drop down menu.\par
\par
\b AutoFilters\par
\b0 The AutoFilter enables you to display only those rows in a list that contain a certain value, or that meet a set of criteria.\par
\par
The AutoFilter command applies drop-down arrows directly to column labels in the list, so you can select the item you want to display.\par
\par
1 Make sure the active cell is in the list.\par
2 From the Data Menu, Filter and AutoFilter.\par
3 When you select an item from the drop-down list, Microsoft Excel temporarily hides the rows that do not contain that item.\par
4 The resulting row labels appear in blue.\par
5 You can show all the data in your list by using the Show All command, or remove the AutoFilter drop-down arrows by clearing the AutoFilter command.\par
\par
\b Custom AutoFilter\par
\b0 You can also find only those rows in a list that meet a set of criteria, such as people whose salaries are in a specific range. To do this, choose the Custom option from the drop-down list. The result then shows. \par
\par
Filtering can be taken one step further by using Advanced Filter, where you can specify multiple criteria and have the option of copying the results to another location.\par
