Excel 97



Microsoft Office 97
Microsoft Office 97 core programs (Word, Excel, PowerPoint, Outlook) running on Windows NT 4.0 with the Office Assistant present
Developer(s)Microsoft
Initial releaseNovember 19, 1996; 24 years ago
Final release
Service Release 2b (SR-2b) / October 7, 1999; 21 years ago[1]
Operating systemWindows NT 3.51 SP5 and later[2]
PlatformIA-32, DEC Alpha (partial)
PredecessorMicrosoft Office 95
SuccessorMicrosoft Office 2000
TypeOffice suite
License
Websitetechnet.microsoft.com/en-us/library/cc760254.aspx

253 Keyboard Shortcuts for Microsoft Excel 97 at keyxl.com. The internet's online database for keyboard shortcuts. Select Excel 97-2003 Workbook (.xls) from the drop-down list. To automatically save your Excel files in 97-2003 format, execute the following steps. On the File tab, click Options. On the left side, click Save and select Excel 97-2003 Workbook from the drop-down list. In Excel 97/2000 the password is converted to a 40-bit key, which can also be cracked very quickly using modern equipment. As regards services that use rainbow tables (e.g. Password-Find), it takes up to several seconds to remove protection. Microsoft Excel 97/98 (8.0) Excel, from Microsoft, is a powerful spreadsheet application for Mac, Windows, and OS/2. Excel was first released for the Mac. When it was ported to Windows 2.x, they started at version '2.0' to one up current Mac version. There was never a DOS version. Instead, DOS and 8-bit platforms used the older Microsoft Multiplan. Protected View is an isolated sandbox environment for Excel, Word, and PowerPoint. It is offered by Microsoft Office to replace the former Isolated Conversion Environment. Protected View is a read-only mode where most editing functions are disabled.

Microsoft Office 97 (version 8.0) is the fifth major release for Windows of Microsoft Office, released by Microsoft on November 19, 1996.[3] It succeeded Microsoft Office 95 and was replaced by Microsoft Office 2000 in 1999. A Mac OS equivalent, Microsoft Office 98 Macintosh Edition, was released on January 6, 1998.

Microsoft Office 97 is a major milestone release which includes hundreds of new features and improvements over its predecessor.

The suite is officially compatible with Windows NT 3.51 SP5, Windows 95, Windows NT 4.0, Windows 98, Windows 2000, and Windows Me, and is the last version to support Windows NT 3.51.[a]

Two Service Releases (SR-1 and SR-2) were released for Office 97; SR-2 solved the year 2000 problem in Office 97.[4]

Mainstream hotfix support for Office 97 ended on August 31, 2001, while extended hotfix support ended on February 28, 2002.[5] Assisted support options and security updates for Office 97 ended on January 16, 2004.

Features[edit]

Office 97 introduced 'Command Bars,' a paradigm in which menus and toolbars were made more similar in capability and visual design. It also featured natural language systems and sophisticated grammar checking.

Microsoft Office 97 is the first version of Office to feature the Office Assistant, a feature designed to assist users by the way of an interactive animated character, which interfaced with the Office help content. The default assistant was 'Clippit', nicknamed 'Clippy', a paperclip. The Office Assistant feature was also included in its successor, Office 2000, as well as in Office XP (hidden by default) and 2003 (not installed by default), before being removed entirely in Office 2007.

Office 97 is also the first Microsoft product to include product activation, albeit limited to the Brazilian editions of Office 97 Small Business Edition and Publisher.[6]

Two Office 97 applications featured easter eggs: Microsoft Word 97 contained a hidden pinball game and Microsoft Excel contained a hidden flight simulator.[7][8]

Editions[edit]

The vivid cover art emphasized the fifth 'puzzle piece', Microsoft Access
Free

Office 97 was released in five editions:

Office programsStandard EditionProfessional EditionSmall Business EditionSmall Business Edition 2.0[9]Developer
Edition
Word 97YesYesYesYes[b]Yes
Excel 97YesYesYesYes[c]Yes
Outlook 97YesYesYesYes[d]Yes
PowerPoint 97YesYesNoNoYes
Access 97NoYesNoNoYes
Bookshelf BasicsNoYesNoNoYes
Developer Tools and SDKNoNoNoNoYes
Publisher 97NoNoYesNoNo
Small Business Financial Manager 97NoNoYes[e]NoNo
Automap Streets Plus 5.0 (1997) [10]NoNoYes[f]NoNo
Publisher 98NoNoNoYesNo
Small Business Financial Manager 98NoNoNoYes[g]No
Direct Mail ManagerNoNoNoYes[h]No
Expedia Streets 98[11]NoNoNoYes[i]No
Internet Explorer 3.0YesYesYesNoYes
Internet Explorer 4.0NoNoNoYesNo

Contemporary programs[edit]

Excel

Some additional programs were branded as a member of the Office 97 family but were not included in any of the editions:

  • Microsoft FrontPage 97
  • Microsoft FrontPage 98
  • Microsoft Project 98
  • Microsoft Team Manager 97

Notes[edit]

  1. ^Outlook, FrontPage and Publisher 98 require Windows NT 4.0
  2. ^Includes SR-1 update
  3. ^Includes SR-1 update
  4. ^Can be upgraded to Outlook 98 via coupon or download, although several OEM copies included Outlook 98
  5. ^Can be upgraded to Small Business Financial Manager 98 for free from Office Update website (requires Excel 97 SR-1) ; available in the United States, Canada, United Kingdom and Australia
  6. ^Available only in the United States and Canada
  7. ^Available in the United States, Canada, United Kingdom and Australia
  8. ^Available only in the United States
  9. ^Available only in the United States and Canada

References[edit]

  1. ^Paul Thurrott (October 7, 1999). 'Microsoft quietly issues new version of Office 97 SR2'. ITProToday. Retrieved March 24, 2020.
  2. ^'Chapter 5 - System Requirements for MS Office'. Microsoft Office 97 Resource Kit. Microsoft. 1997. ISBN9781572313293. Retrieved June 14, 2017.
  3. ^'Microsoft Office 97 Released to Manufacturing'. News Center. Las Vegas: Microsoft. November 19, 1996. Archived from the original on November 25, 2014.
  4. ^'MS Office 97 Service Release 2b (SR-2b)'. TechNet. Microsoft. October 1999. Retrieved April 2, 2016.
  5. ^'Microsoft Office Family Product Support Lifecycle FAQ'. Microsoft Support. Microsoft. Archived from the original on March 12, 2016. Retrieved April 2, 2016.
  6. ^'Microsoft Extends Anti-Piracy Features in Office 2000'. News Center. Redmond, WA: Microsoft. December 9, 1998.
  7. ^'Excel Easter Egg - Excel 97 Flight to Credits'. The Easter Egg Archive. Retrieved April 2, 2016.
  8. ^'Excel Easter Egg - Excel 97 Flight Simulator - for Later Versions of Microsoft Excel'. The Easter Egg Archive. Retrieved April 2, 2016.
  9. ^'Office 97 Small Business Edition v2 - Features'. microsoft.com. Microsoft. February 1, 2000. Archived from the original on February 26, 2000. Retrieved April 28, 2011.
  10. ^Microsoft Automap Streets Plus Preferred 2-to-1 in New Study
  11. ^Microsoft Launches New Version of Preferred Street-Finding Software
Retrieved from 'https://en.wikipedia.org/w/index.php?title=Microsoft_Office_97&oldid=1007161365'

EXCEL 97: Formatting, Saving, Printing and Copying

A. Colin Cameron, Dept. of Economics, Univ. of Calif.- Davis

This September 1999 help sheet gives information on how to
  • format Excel spreadsheets
  • save Excel worksheets and workbooks
  • print Excel worksheets
  • print Excel charts
  • copy an Excel chart into another program
  • copy Excel worksheet contents to another program as data
  • copy Excel worksheet contents to another program as a picture


FORMATTING

Enter in the cars per household data discussed in Excel:Data Types and Data Input
CARS PER HOUSEHOLDHH SIZE
1 1
2 2
2 3
2 4
3 5

Then in Excel only the first part of CARS PER HOUSEHOLD will be displayed.
The cell width needs to be increased. This can be done in one of severalways.

  1. Place the cursor between shaded areas A and B at the top of spreadsheetand double-click.
  2. Place the cursor between shaded areas A and B, click and drag to the rightto increase width.
  3. Place the cursor within shaded area A, click to highlight the column, rightclick and choose column width and make it larger.
  4. Place the cursor within shaded area A, click to highlight the columnand chose Format | Cells.
Methods 3 and 4 can also be used to change other aspects of cell format.

SAVING WORKSHEETS AND WORKBOOKS

When you open up Excel it creates a workbook (the master document),which is composed of one or more worksheets.
You should save the workbook on your diskette with a name that identifiesit as your class or project workbook, e.g. for economics 140 I might usea:e140cam, by choosing File / Save As.
You can save each class session and homework on a separate worksheet.When you first open the workbook it puts you in Sheet1. You can renamethis to e.g. intro by double-clicking on the Sheet1 tab at the bottom ofthe screen and typing intro at the rename prompt. Sheet2 might become Ass2etc.
Save results frequently.

PRINTING WORKSHEETS

To save paper always do a print preview first (File / preview).

For nicer output of a worksheet you can change the column widths ifneed be by moving the cursor to the vertical line that separates the columnheaders, e.g. between A and B.
This is discussed above under formatting.

For nicer output of a worksheet you can choose File | Page Setup andselect the Fit to option.
For example if the output is just a bit over a page in print previewthen select Fit to 1 page by 1 page.

PRINTING A CHART

For nicer output of charts that appear within the worksheet, move themouse within the chart and click (this creates eight small square boxesaround the chart). Then choose File | Print and the chart is printed ona separate page.

COPY A CHART

It is generally easy to copy individual charts to other software suchas a word processor.

  • Highlight the individual chart by clicking within the chart and copy (CTRL-C)
  • Paste special into the software you are using.
Microsoft Office software such as Word may maintain the Excel format ofthe chart when you read it in, so that it can later be edited. Other softwarewill instead save it as a picture, often as a WIndows meta-file (.wmf).

COPY WORKSHEET CONTENTS AS TEXT

This is particularly done to copy data from the spreadsheet into anotherprogram such as a word processor.

Microsoft Excel 97 Download

  • Highlight the area in the work-sheet to be copied and copy (CTRL-C).
  • Paste into the word processor (CTRL-V) or other software.
Excel 97This will copy data across and insert it.
Interpretation of the data depends on what is copied across (e.g. dataor chart) and the software it is copied to (e.g. word processor). As anexample, if two columns of data are copied across they might be put intoa two-column table in Word.

Excel 97-2003 Workbook

COPY WORKSHEET CONTENTS AS A PICTURE

Rather than print nicely formatted Excel output on paper we may wishto copy it into a word processor or web page. This output may include boththe data and some charts. This is a little tricky and may perhaps be deferredto a time when you really have reason to do this.

Excel 97 Password Remover

  • Highlight the area in the work-sheet to be copied and copy (CTRL-C).
  • Paste-special into the word processor or other software (Edit |Paste Special).

  • For Microsoft Word one can paste special in a number of formats arepossible. Choose picture which saves the file as a .gif file. This is thebest way to maintain good picture quality yet use up relatively littlestorage space.
  • Save the Microsoft Word file as a Word document, or for webpage publicationas a webpage or html file.
The picture itself does not appear in the file that is saved. The filethat is saved instead has a reference to the picture. The picture willbe saved with a name such as image001.gif. It is better to give the thispicture file a more meaningful name, but then you will also need to changethe reference in the file that was saved.

If you have Adobe Acrobat Exchange (not just the reader) another wayto digitally save the Excel output is to print the Excel file to a PDFWRITERwhich will save the file in pdf form. Other people can then read the outputusing a pdf viewer such as Adobe Acrobat reader.

Excel 97 2003 Workbook Download

For further information on how to use Excel go to
http://www.econ.ucdavis.edu/faculty/cameron