Watch Windows
When viewing their documents in Print Layout, users can easily hide the blank spaces and the header/footer area between the pages of their documents. This eliminates wasted space on their screen and allows for easy reading and editing.
Border Drawing
Using the border-drawing pencil, users can easily draw cell borders in their spreadsheet. Options include changing the line color, weight, and style or even adding a border grid to their sheet.
Tab Colors
Users can keep their workbooks organized by color-coding their worksheet tabs. They can choose from a wide variety of colors with which to organize sections of a workbook.
Stock Quote Smart Tag
In previous versions, Excel recognized URLs and assigned links associated with these items. Users could activate the links by clicking them. Excel version 2002 extends this functionality by recognizing stock symbols as they are entered and providing users a Smart Tag icon. The Smart Tag allows users to access additional information on that stock from the Web or even insert into Excel a refreshable Web query of that stock information.
Auto Republish
Saving Excel data to a Web page can occur automatically each time you save your Excel file. For example, if your file contains a range of data or a chart that you share with others on a Web page, each time you save your Excel file the Web page can be updated automatically.
Exporting Team Lists to Excel
Team members can easily export a variety of lists from their Team Web Site back into Excel for further analysis. These lists include Contacts, Announcements, Events, Links, Tasks, and Surveys.
Find and Replace
Users are provided with an enhanced user interface and functionality for the Find and Replace feature. Users can execute a single Find/Replace across all sheets in a workbook, reuse past searches, view a modeless UI, and find new elements such as formatting.
Header & footer
Pictures or drawings can now be inserted directly as headers or footers. You may also insert Indian language page numbers/ date etc.
Cell merging
With the Merge and Center button on the Formatting toolbar, users can unmerge a group of cells just as easily as they can merge a group of cells. It is possible to unmerge even if the Undo option is no longer available.
Pivot Table
A variety of improvements have been made to PivotTable views, including the ability to create custom ad-hoc groups and get visual totals.
