PC World Komputer 1997 November/Pcwk1197.iso/LOTUS/Eng-ins/123/SS1N60EN.CNT

Microsoft Windows Help File Content | 1997-01-02 | 53KB | 727 lines

:Base SS1N60EN.HLP>Steps
:Title 1-2-3 Help
:Index @Function Help=SSFN60EN.HLP
:Index Macro Help=SSMN60EN.HLP
:Index Lotus Chart Help=LC1N21EN.HLP
:Index Lotus TeamMail Help=TM1N11EN.HLP
:Index Lotus Customer Support Help=CS1N97EN.HLP
:Link SSFN60EN.HLP
:Link SSSN60EN.HLP
1 Getting Started
2 Starting and Ending 1-2-3
3 Overview: Welcome to 1-2-3=[e-mail]>Overview
3 Opening an existing workbook=[e-mail]>Steps
3 Creating a blank workbook=[e-mail]>Steps
3 Creating a new workbook using a Smartmaster=[e-mail]>Steps
3 Ending 1-2-3=[e-mail]>Steps
2 Exploring the Workspace
3 Overview: Parts of the 1-2-3 window=[e-mail]>Overview
3 Overview: The InfoBox =[e-mail]>Overview
3 Overview: Using SmartIcons=[e-mail]>Overview
3 Overview: Using the status bar=[e-mail]>Overview
3 Working with Windows
4 Overview: Workbook windows=[e-mail]>Overview
4 Moving windows=[e-mail]>Steps
4 Sizing windows=[e-mail]>Steps
4 Splitting windows=[e-mail]>Steps
4 Creating a new window=[e-mail]>Steps
4 Cascading windows=[e-mail]>Steps
4 Tiling windows top to bottom=[e-mail]>Steps
4 Tiling windows side by side=[e-mail]>Steps
4 Viewing open windows=[e-mail]>Steps
2 Learning about 1-2-3
3 Overview: Learning 1-2-3=[e-mail]>Overview
3 Taking a tour=[e-mail]>Overview
3 Using demos=[e-mail]>Overview
3 Did you know...?=[e-mail]>Overview
3 Late breaking news about 1-2-3=[e-mail]>Overview
2 Getting Help
3 Getting Help with 1-2-3=[e-mail]>Overview
3 Conventions used in Help=[e-mail]>Overview
3 Examples in 1-2-3 Help=[e-mail]>Overview
3 Printing Help information=[e-mail]>Steps
1 Top 10 Tasks
2 Overview: 1-2-3 Top 10 tasks=[e-mail]>Overview
2 Previewing and printing data=[e-mail]>Overview
2 Moving data in and out of 1-2-3=[e-mail]>Overview
2 More power with @functions and formulas=[e-mail]>Overview
2 Styling a sheet=[e-mail]>Overview
2 Copying, moving, and filling=[e-mail]>Overview
2 Charting and mapping your data=[e-mail]>Overview
2 Easy database access=[e-mail]>Overview
2 Automating 1-2-3=[e-mail]>Overview
2 Row and column operations=[e-mail]>Overview
2 Starting smart with SmartMaster templates=[e-mail]>Overview
1 How Do I?
2 Find and Select
3 Selecting Sheet Areas
4 Overview: Selecting sheet areas=[e-mail]>Overview
4 Quick summary of selection techniques for sheet areas=[e-mail]>Overview
4 Selecting a single cell=[e-mail]>Steps
4 Selecting a range=[e-mail]>Steps
4 Selecting a range across sheets=[e-mail]>Steps
4 Selecting a range from a dialog box=[e-mail]>Steps
4 Selecting a collection of ranges=[e-mail]>Steps
4 Selecting columns or rows=[e-mail]>Steps
4 Selecting sheets=[e-mail]>Steps
3 Selecting Graphic Objects
4 Overview: Selecting graphic objects=[e-mail]>Overview
4 Selecting graphic objects=[e-mail]>Overview
3 Finding Data
4 Overview: Finding data=[e-mail]>Overview
4 Using the navigator to find named ranges=[e-mail]>Steps
4 Finding ranges and graphic objects=[e-mail]>Steps
4 Finding text or numbers=[e-mail]>Steps
4 Finding and replacing text or numbers=[e-mail]>Steps
2 Enter and Edit Data
3 Entering Data
4 Overview: Entering data=[e-mail]>Overview
4 Entering text=[e-mail]>Steps
4 Entering numbers=[e-mail]>Steps
4 Entering dates=[e-mail]>Steps
4 Entering times=[e-mail]>Steps
4 Summing a range automatically=[e-mail]>Steps
4 Creating a cell comment=[e-mail]>Steps
3 Filling a Range Automatically
4 Overview: Filling ranges=[e-mail]>Overview
4 Filling a range with numbers=[e-mail]>Steps
4 Filling a range with dates=[e-mail]>Steps
4 Filling a range with times=[e-mail]>Steps
4 Filling a range with text=[e-mail]>Steps
4 Filling a range using drag and fill=H_FILLING_A_RANGE_USING_DRAGANDFILL_STEPS
4 Overview: Creating custom fill lists=[e-mail]>Overview
4 Creating a custom fill list=[e-mail]>Steps
4 Modifying a custom fill list=[e-mail]>Steps
3 Editing Data
4 Overview: Editing data=[e-mail]>Overview
4 Editing data in a cell=[e-mail]>Steps
4 Editing data in text blocks=[e-mail]>Steps
4 Editing a cell comment=[e-mail]>Steps
3 Deleting
4 Deleting data in ranges=[e-mail]>Steps
4 Deleting graphic objects=[e-mail]>Steps
4 Using drag and clear to delete data=[e-mail]>Steps
4 Deleting styles=[e-mail]>Steps
3 Checking Spelling
4 Checking spelling=[e-mail]>Steps
4 Changing spell checking options=[e-mail]>Steps
4 Changing to another dictionary=[e-mail]>Steps
4 Editing the user dictionary=[e-mail]>Steps
4 Creating a user dictionary=[e-mail]>Steps
2 Copy and Move
3 Copying and Moving Data in 1-2-3
4 Overview: Copying and moving=[e-mail]>Overview
4 Copying using the Clipboard=[e-mail]>Steps
4 Moving using the Clipboard=[e-mail]>Steps
4 Moving a sheet=[e-mail]>Steps
4 Copying and moving using drag and drop=[e-mail]>Steps
4 Copying down to fill a range=[e-mail]>Steps
4 Copying right to fill a range=[e-mail]>Steps
4 Copying styles=[e-mail]>Steps
4 Copying cell comments=[e-mail]>Steps
3 Copying and Moving Data Between Applications
4 Overview: Copying and moving 1-2-3 data to other applications=[e-mail]>Overview
4 Overview: Using data from other applications in 1-2-3=[e-mail]>Overview
4 Copying data from 1-2-3 with drag and drop=[e-mail]>Steps
4 Copying and moving data from other applications into 1-2-3=[e-mail]>Steps
4 Copying data into 1-2-3 with drag and drop=[e-mail]>Steps
2 Change the Appearance of Data and Objects
3 Using the InfoBox
4 Overview: The InfoBox =[e-mail]>Overview
4 Using the InfoBox =[e-mail]>Steps
3 Changing Text Style and Alignment
4 Overview: Alignment =[e-mail]>Overview
4 Aligning data in cells =[e-mail]>Steps
4 Aligning data in text blocks =[e-mail]>Steps
4 Wrapping data in a cell =[e-mail]>Steps
4 Spanning text across columns =[e-mail]>Steps
4 Rotating data =[e-mail]>Steps
4 Changing text styles=[e-mail]>Steps
3 Changing Number Format
4 Overview: Number formats=[e-mail]>Overview
4 Formatting numbers=[e-mail]>Steps
4 Formatting numbers as currency=[e-mail]>Steps
4 Changing the currency symbol=[e-mail]>Steps
4 Promoting a number format=[e-mail]>Steps
3 Changing Borders, Lines, and Colors
4 Overview: Changing borders, lines, and colors=[e-mail]>Overview
4 Changing range borders=[e-mail]>Steps
4 Changing graphic object borders=[e-mail]>Steps
4 Changing line styles=[e-mail]>Steps
4 Changing interior color and pattern=[e-mail]>Steps
4 Adding designer frames=[e-mail]>Steps
3 Styling Ranges Quickly
4 Using fast format to style a range=[e-mail]>Steps
4 Using the style gallery=[e-mail]>Steps
4 Overview: Named styles=[e-mail]>Overview
4 Creating a named style=[e-mail]>Steps
4 Applying a named style=[e-mail]>Steps
4 Renaming a named style=[e-mail]>Steps
4 Redefining a named style=[e-mail]>Steps
4 Resetting a cell's styles to a named style=[e-mail]>Steps
4 Removing a named style from cells=[e-mail]>Steps
4 Deleting a named style=[e-mail]>Steps
2 Preview and Print
3 Previewing Your Work
4 Overview: The Preview window=[e-mail]>Overview
4 Overview: Keyboard and mouse shortcuts in the Preview window=[e-mail]>Overview
4 Previewing your work before printing=[e-mail]>Steps
4 Zooming in and out of the Preview window=[e-mail]>Steps
3 Changing Print and Page Properties
4 Overview: Print and page properties=[e-mail]>Overview
4 Changing font properties for headers and footers=[e-mail]>Steps
4 Changing the print selection=[e-mail]>Steps
4 Numbering printed pages=[e-mail]>Steps
4 Changing print margins=[e-mail]>Steps
4 Changing page orientation=[e-mail]>Steps
4 Centering data on the printed page=[e-mail]>Steps
4 Fitting your work on the printed page=[e-mail]>Steps
4 Adding headers and footers=[e-mail]>Steps
4 Printing titles on each page=[e-mail]>Steps
4 Changing the paper size=[e-mail]>Steps
3 Managing Named Print Styles
4 Overview: Named print styles=[e-mail]>Overview
4 Creating a named print style=[e-mail]>Steps
4 Applying a named print style=[e-mail]>Steps
4 Redefining a named print style=[e-mail]>Steps
4 Resetting a named print style=[e-mail]>Steps
4 Retrieving a print style from an earlier release of 1-2-3=[e-mail]>Steps
4 Renaming a print style=[e-mail]>Steps
4 Deleting a named print style=[e-mail]>Steps
4 Copying a named print style from another file=[e-mail]>Steps
3 Printing Your Work
4 Overview: Printing=[e-mail]>Overview
4 Quick printing=[e-mail]>Steps
4 Printing a workbook=[e-mail]>Steps
4 Printing the current sheet=[e-mail]>Steps
4 Printing a range=[e-mail]>Steps
4 Printing graphic objects, charts, and maps=[e-mail]>Steps
4 Printing to a file=H_PRINT_TO_FILE_STEPS
4 Printing text in the Script Editor=[e-mail]>Steps
4 Selecting a printer=[e-mail]>Steps
4 Changing printer properties=[e-mail]>Steps
4 Adding a page break=[e-mail]>Steps
4 Removing a page break=[e-mail]>Steps
2 Work with Files
3 Creating and Opening Files
4 Overview: Creating and opening files=[e-mail]>Overview
4 Working with SmartMaster templates=[e-mail]>Overview
4 Creating a blank workbook=[e-mail]>Steps
4 Creating a workbook using a SmartMaster=[e-mail]>Steps
4 Creating a SmartMaster template=[e-mail]>Steps
4 Opening an existing file=[e-mail]>Steps
4 Opening a recently used file=[e-mail]>Steps
4 Opening a text file=[e-mail]>Steps
4 Combining data=[e-mail]>Steps
4 Importing a picture=[e-mail]>Steps
4 Opening a Notes file attachment from within 1-2-3=[e-mail]>Steps
3 Closing and Saving Files
4 Overview: Closing and saving files=[e-mail]>Overview
4 Closing a file=[e-mail]>Steps
4 Saving a new workbook=[e-mail]>Steps
4 Saving an existing file=[e-mail]>Steps
4 Saving a range as a new file=[e-mail]>Steps
4 Saving a file to a Notes database=[e-mail]>Steps
3 Sharing Files
4 Working with 1-2-3 files=[e-mail]>Overview
4 Working with Excel files=[e-mail]>Overview
4 The Excel log file=[e-mail]>Overview
4 Viewing the Excel log file=[e-mail]>Steps
4 Translating Excel files=[e-mail]>Overview
4 Translating formatting information in Excel files=[e-mail]>Overview
4 Translating functions in Excel files=[e-mail]>Overview
4 Working with Quattro Pro files=[e-mail]>Overview
4 Viewing the Quattro Pro log file=[e-mail]>Steps
4 Working with dBASE and Paradox files=[e-mail]>Overview
3 Protecting Data
4 Overview: Protecting data=[e-mail]>Overview
4 Preventing others from opening a workbook=[e-mail]>Steps
4 Leaving part of a workbook or sheet unprotected=[e-mail]>Steps
4 Locking workbook contents=[e-mail]>Steps
4 Locking sheet contents=[e-mail]>Steps
4 Overview: Using a workbook reservation=[e-mail]>Overview
4 Getting a workbook reservation=[e-mail]>Steps
4 Releasing a workbook reservation=[e-mail]>Steps
4 Changing the reservation setting=[e-mail]>Steps
3 Managing Files
4 Adding a title and description=[e-mail]>Steps
4 Viewing workbook file statistics=[e-mail]>Steps
4 Tracking changes in a workbook=[e-mail]>Steps
2 Work with Sheets
3 Sheet Basics
4 Overview: Sheets=[e-mail]>Overview
4 Creating a sheet=[e-mail]>Steps
4 Naming a sheet=[e-mail]>Steps
4 Deleting a sheet name=[e-mail]>Steps
4 Changing sheet tab color=[e-mail]>Steps
4 Hiding or showing sheet tabs=[e-mail]>Steps
4 Grouping sheets=[e-mail]>Steps
4 Ungrouping sheets=[e-mail]>Steps
4 Freezing columns and rows as titles=[e-mail]>Steps
4 Clearing frozen titles=[e-mail]>Steps
3 Inserting and Deleting
4 Inserting a range=[e-mail]>Steps
4 Inserting columns or rows=[e-mail]>Steps
4 Deleting a range=[e-mail]>Steps
4 Deleting columns or rows=[e-mail]>Steps
4 Deleting sheets=[e-mail]>Steps
3 Sizing Columns and Rows
4 Overview: Sizing columns and rows=[e-mail]>Overview
4 Sizing columns=[e-mail]>Steps
4 Fitting the widest column entry=[e-mail]>Steps
4 Sizing rows=[e-mail]>Steps
4 Fitting the tallest row entry=[e-mail]>Steps
3 Naming Ranges
4 Overview: Range names=[e-mail]>Overview
4 Naming a range=[e-mail]>Steps
4 Naming a range using adjacent labels=[e-mail]>Steps
4 Deleting range names=[e-mail]>Steps
3 Hiding Data
4 Overview: Hiding data=[e-mail]>Overview
4 Hiding cell contents=[e-mail]>Steps
4 Hiding columns=[e-mail]>Steps
4 Hiding rows=[e-mail]>Steps
4 Hiding sheets=[e-mail]>Steps
4 Displaying hidden columns=[e-mail]>Steps
4 Displaying hidden rows=[e-mail]>Steps
4 Displaying hidden sheets=[e-mail]>Steps
3 Outlining Data
4 Overview: Creating an outline=H_OUTLINING_SHEET_DATA_OVER>Overview
4 Overview: Working with rows and columns in outlines=[e-mail]>Overview
4 Demoting rows and columns to create an outline=[e-mail]>Steps
4 Promoting rows and columns=[e-mail]>Steps
4 Collapsing an outline to show less detail=[e-mail]>Steps
4 Expanding an outline to show more detail=[e-mail]>Steps
4 Specifying how summary data relates to detail data=[e-mail]>Steps
4 Showing and hiding the outline frame=[e-mail]>Steps
4 Removing an outline=[e-mail]>Steps
3 Organizing Data
4 Parsing data=[e-mail]>Steps
4 Sorting data=[e-mail]>Steps
4 Transposing data=[e-mail]>Steps
2 Work with Graphic Objects
3 Overview: Working with graphic objects=[e-mail]>Overview
3 Creating Graphic Objects
4 Creating a line, arc, or arrow=[e-mail]>Steps
4 Creating a polyline or polygon=[e-mail]>Steps
4 Creating a rectangle or ellipse=[e-mail]>Steps
4 Creating a freehand drawing=[e-mail]>Steps
4 Creating a text block=[e-mail]>Steps
4 Bringing a picture into 1-2-3=[e-mail]>Steps
3 Performing Basic Tasks with Graphic Objects
4 Selecting graphic objects=[e-mail]>Overview
4 Sizing graphic objects=[e-mail]>Steps
4 Restoring a picture to its original size=[e-mail]>Steps
4 Moving graphic objects=[e-mail]>Steps
4 Styling graphic objects=[e-mail]>Overview
4 Naming a graphic object=[e-mail]>Steps
3 Performing Advanced Tasks with Graphic Objects
4 Fastening graphic objects=[e-mail]>Steps
4 Hiding or redisplaying graphic objects=[e-mail]>Steps
4 Locking or unlocking graphic objects=[e-mail]>Steps
4 Shuffling graphic objects=[e-mail]>Steps
4 Flipping graphic objects=[e-mail]>Steps
4 Rotating graphic objects=[e-mail]>Steps
4 Grouping graphic objects=[e-mail]>Steps
4 Ungrouping graphic objects=[e-mail]>Steps
4 Reshaping a polyline, polygon, or freehand drawing=[e-mail]>Steps
2 Work with Charts
3 Overview: Creating a chart in 1-2-3=[e-mail]>Overview
3 Creating a chart in 1-2-3=[e-mail]>Steps
:include LC1N21EN.CNT
2 Work with Maps
3 Map Basics
4 Overview: Maps=[e-mail]>Overview
4 Setting up map data=[e-mail]>Steps
4 Creating a map=[e-mail]>Steps
4 Reconciling map region names=[e-mail]>Steps
4 Adding pin characters to a map=[e-mail]>Steps
3 Changing Map Content
4 Overview: Changing map content=[e-mail]>Overview
4 Naming a map=[e-mail]>Steps
4 Changing range assignments=[e-mail]>Steps
4 Changing the plot area=[e-mail]>Steps
4 Changing legend labels=[e-mail]>Steps
4 Changing a map title=[e-mail]>Steps
4 Changing color or pattern bin values=H_CHANGING_COLOR_AND_PATTERN_BIN_VALUES_STEPS
4 Adding an overlay to a map=[e-mail]>Steps
4 Removing an overlay from a map=[e-mail]>Steps
4 Redrawing maps=[e-mail]>Steps
3 Changing Map Appearance
4 Overview: Changing map appearance=[e-mail]>Overview
4 Changing bin colors or patterns=[e-mail]>Steps
4 Changing the zoom factor of maps=[e-mail]>Steps
2 Work with Database Tables
3 Overview: Working with databases=[e-mail]>Overview
3 Creating a 1-2-3 database table=[e-mail]>Steps
3 Overview: Working with 1-2-3 data in an embedded Approach object=[e-mail]>Overview
3 Working with Query Tables
4 Overview: Query tables=[e-mail]>Overview
4 Creating a query table=[e-mail]>Steps
4 Working with a query table=[e-mail]>Steps
4 Moving and sizing a query table=[e-mail]>Steps
4 Copying a query table=[e-mail]>Steps
4 Adding a field in a query table=[e-mail]>Steps
4 Deleting a field in a query table=[e-mail]>Steps
4 Reordering fields in a query table=[e-mail]>Steps
4 Copying query results to an output range=[e-mail]>Steps
4 Working with an output range=[e-mail]>Steps
4 Deleting an output range=[e-mail]>Steps
4 Refreshing data=[e-mail]>Steps
3 Managing Database Records
4 Adding records using a query table=[e-mail]>Steps
4 Editing records using a query table=[e-mail]>Steps
4 Deleting records using a query table=[e-mail]>Steps
4 Creating a form=[e-mail]>Steps
4 Working with a form=[e-mail]>Steps
4 Joining database tables=[e-mail]>Steps
3 Analyzing Database Records
4 Sorting records in a query table=[e-mail]>Steps
4 Finding specific records in a query table=[e-mail]>Steps
4 Creating a report=[e-mail]>Steps
4 Working with a report=[e-mail]>Steps
4 Creating a dynamic crosstab=[e-mail]>Steps
4 Working with a dynamic crosstab=[e-mail]>Steps
3 Creating Mailing Labels and Form Letters
4 Creating mailing labels=[e-mail]>Steps
4 Working with mailing labels=[e-mail]>Steps
4 Creating a form letter=[e-mail]>Steps
4 Working with a form letter=[e-mail]>Steps
2 Analyze and Share Data
3 Working with Versions
4 Overview: Versions=[e-mail]>Overview
4 Overview: Sharing versions with a team=[e-mail]>Overview
4 Creating a version=[e-mail]>Steps
4 Displaying a version=[e-mail]>Steps
4 Changing version properties=[e-mail]>Steps
4 Deleting a version=[e-mail]>Steps
4 Creating a version report=[e-mail]>Steps
4 Merging versions and version groups=[e-mail]>Steps
3 Working with Version Groups
4 Overview: Version groups=[e-mail]>Overview
4 Creating a version group=[e-mail]>Steps
4 Displaying a version group=[e-mail]>Steps
4 Changing a version group=[e-mail]>Steps
4 Deleting a version group=[e-mail]>Steps
3 Solving What-If Problems
4 Overview: What-if tables and Backsolving=[e-mail]>Overview
4 Setting up a one variable what-if table=[e-mail]>Steps
4 Setting up a two variable what-if table=[e-mail]>Steps
4 Setting up a three variable what-if table=[e-mail]>Steps
4 Calculating what-if tables=[e-mail]>Steps
4 Clearing what-if table settings=[e-mail]>Steps
4 Backsolving what-if problems=[e-mail]>Steps
3 Performing Statistical Analysis
4 Overview: Using 1-2-3 to analyze data=[e-mail]>Overview
4 Calculating a frequency distribution=[e-mail]>Steps
4 Overview: Using regression analysis=[e-mail]>Overview
4 Performing a regression analysis=[e-mail]>Steps
4 Predicting values=[e-mail]>Steps
4 Overview: Using data matrixes=[e-mail]>Overview
4 Inverting a matrix=[e-mail]>Steps
4 Multiplying matrixes=[e-mail]>Steps
3 Linking and Embedding Data
4 Overview: Sharing data using OLE=[e-mail]>Overview
4 Linking Data
5 Overview: OLE Links=[e-mail]>Overview
5 Creating an OLE link in 1-2-3=[e-mail]>Steps
5 Using drag and drop to create an OLE link=[e-mail]>Steps
5 Creating a linked object from a file=[e-mail]>Steps
5 Updating OLE links=[e-mail]>Steps
5 Changing an OLE link's update mode=[e-mail]>Steps
5 Editing OLE links=[e-mail]>Steps
5 Breaking OLE links=[e-mail]>Steps
4 Embedding Objects
5 Overview: Embedded objects=[e-mail]>Overview
5 Creating an embedded object=[e-mail]>Steps
5 Using drag and drop to embed an object=[e-mail]>Steps
5 Creating an embedded object from existing data=[e-mail]>Steps
5 Editing an embedded object=[e-mail]>Steps
5 Dragging a range to the desktop=[e-mail]>Steps
2 Work with a Team Using 1-2-3
3 Using TeamMail and TeamReview
4 Overview: TeamMail in 1-2-3=[e-mail]>Overview
4 Overview: TeamReview in 1-2-3=[e-mail]>Overview
4 Overview: Differences between TeamMail and TeamReview=[e-mail]>Overview
4 Sending a workbook with TeamMail=[e-mail]>Steps
4 Sending a message with TeamMail=[e-mail]>Steps
4 Sending a range for review=[e-mail]>Steps
4 Saving routing information=[e-mail]>Steps
4 Routing a message using saved route information=[e-mail]>Steps
4 Receiving a range or workbook=[e-mail]>Steps
4 Merging ranges into a workbook=[e-mail]>Steps
3 Exchanging Data with Lotus Notes
4 Overview: Exchanging data between 1-2-3 and Notes=[e-mail]>Overview
4 Overview: Setting up Notes/FX=[e-mail]>Overview
4 Setting up named ranges to exchange data with Notes=[e-mail]>Steps
4 Adding Notes/FX fields to a Notes form=[e-mail]>Steps
4 Embedding a 1-2-3 workbook object in a Notes document=[e-mail]>Steps
4 Embedding a 1-2-3 workbook object in a Notes form=[e-mail]>Steps
4 Creating a new Notes document=[e-mail]>Steps
4 Updating fields in a Notes document from 1-2-3=[e-mail]>Steps
4 Updating information in 1-2-3 from a Notes document=[e-mail]>Steps
3 Consolidating Data
4 Overview: Distributing workbooks with TeamConsolidate=[e-mail]>Overview
4 Overview: Creating the TeamConsolidate Notes database=[e-mail]>Overview
4 Overview: Setting up the master workbook=[e-mail]>Details
4 Creating the master workbook from an existing workbook=[e-mail]>Steps
4 Creating a new master workbook=[e-mail]>Steps
4 Distributing sheets=[e-mail]>Steps
4 Overview: Working in the TeamConsolidate database=[e-mail]>Overview
4 Editing a distributed sheet=[e-mail]>Steps
4 Consolidating distributed sheets=[e-mail]>Steps
2 Customize 1-2-3
3 Changing the View
4 Changing the view scale=[e-mail]>Steps
4 Setting the custom view scale=[e-mail]>Steps
3 Changing Sheet Defaults
4 Overview: Sheet defaults=[e-mail]>Overview
4 Setting a default font for a sheet=[e-mail]>Steps
4 Setting a default alignment for a sheet=[e-mail]>Steps
4 Setting a default number format for a sheet=[e-mail]>Steps
4 Setting default colors and pattern for a sheet=[e-mail]>Steps
4 Setting a default column width for a sheet=[e-mail]>Steps
4 Setting a default row height for a sheet=[e-mail]>Steps
4 Setting view preferences for a sheet=[e-mail]>Steps
3 Changing Workbook Defaults
4 Setting a default font and colors for new workbooks=[e-mail]>Steps
4 Setting column and row defaults for new workbooks=[e-mail]>Steps
4 Setting recalculation defaults=[e-mail]>Steps
4 Setting view preferences for workbooks=[e-mail]>Steps
3 Changing 1-2-3 Preferences
4 Overview: 1-2-3 preferences=[e-mail]>Overview
4 Setting startup options=[e-mail]>Steps
4 Setting sorting options=[e-mail]>Steps
4 Setting 1-2-3 options=[e-mail]>Steps
4 Setting file locations=[e-mail]>Steps
4 Setting TAB and ENTER key behavior=[e-mail]>Steps
4 Changing the 1-2-3 Classic menu key=[e-mail]>Steps
4 Changing international settings=H_CHANGING_INTERNATIONAL_SETTINGS_OVER>Overview
3 Working with Add-ins
4 Overview: Add-ins=[e-mail]>Overview
4 Creating an add-in=[e-mail]>Steps
4 Loading add-ins=[e-mail]>Steps
4 Registering add-ins=[e-mail]>Steps
4 Removing add-ins from the Manage Add-Ins list=[e-mail]>Steps
4 Unloading add-ins=[e-mail]>Steps
4 Using add-in @functions=[e-mail]>Overview
1 Working with 1-2-3 and the Internet
2 Overview: Working with Internet connections=[e-mail]>Overview
2 Connecting to a Lotus Site
3 Connecting to the Lotus home page=H_123_CONNECTING_TO_THE_LOTUS_HOME_PAGE_STEPS
3 Connecting to Lotus Customer Support =[e-mail]>Steps
3 Connecting to the Lotus FTP site =[e-mail]>Steps
3 Connecting to the Lotus SmartSuite Reference Library page=[e-mail]>Steps
2 Connecting to an Internet Server
3 Opening a workbook from a Web server on the Internet =[e-mail]>STEPS
3 Opening a workbook from an FTP server on the Internet =H[e-mail]>STEPS
3 Publishing a range on the Internet=H_123_PUBLISHING_A_RANGE_STEPS
3 Saving a workbook to an FTP server on the Internet =[e-mail]>Steps
3 Creating a button link to the Web=[e-mail]>Steps
3 Searching for text on the Internet=[e-mail]>Steps
2 Configuring Internet Options
3 Configuring Internet options =[e-mail]>STEPS
3 Adding, editing, or setting a default proxy =[e-mail]>STEPS
3 Adding connection information for Internet hosts =[e-mail]>STEPS
3 Deleting connection information for Internet hosts =[e-mail]>STEPS
3 Editing connection information for Internet hosts =[e-mail]>STEPS
1 Demo Catalog
2 Using demos=H_LEARN123_DEMOS_OVER>Overview
1 Tools for Getting Your Work Done
2 Overview: Installing additional language versions of 1-2-3=[e-mail]>Overview
2 Overview: Ways to perform tasks=[e-mail]>Overview
2 Using the Keyboard
3 Keyboard shortcuts=[e-mail]>Overview
3 Function keys=[e-mail]>Overview
3 Script editing and debugging keys=[e-mail]>Overview
3 Selection keys=[e-mail]>Overview
3 Pointer-movement keys=[e-mail]>Overview
3 Editing keys=[e-mail]>Overview
3 Style keys=[e-mail]>Overview
3 Sheet navigation keys=[e-mail]>Overview
3 Workbook navigation keys=[e-mail]>Overview
3 Dialog box keys=[e-mail]>Overview
3 InfoBox keys=[e-mail]>Overview
3 Help keys=[e-mail]>Overview
3 Special keys=[e-mail]>Overview
2 Using Menus
3 Overview: Using menus=[e-mail]>Overview
3 Canceling a command=[e-mail]>Steps
3 Undoing a command=[e-mail]>Steps
3 Getting Help on a menu command=[e-mail]>Steps
2 Menu Commands
3 Main Menu
4 File menu=[e-mail]>Overview
4 Edit menu=[e-mail]>Overview
4 View menu=[e-mail]>Overview
4 Create menu=[e-mail]>Overview
4 Window menu=[e-mail]>Overview
4 Help menu=[e-mail]>Overview
3 Context-Sensitive Menus
4 Range menu=[e-mail]>Overview
4 Sheet menu=[e-mail]>Overview
4 Drawing menu=[e-mail]>Overview
4 Chart menu=[e-mail]>Overview
4 Map menu=[e-mail]>Overview
4 Query Table menu=[e-mail]>Overview
4 OLE object menu=[e-mail]>Overview
4 Preview menu=[e-mail]>Overview
4 Actions menu=[e-mail]>Overview
2 Using the InfoBox
3 Overview: The InfoBox=[e-mail]>Overview
3 Using the InfoBox=[e-mail]>Steps
2 Using SmartIcons
3 Using SmartIcons
4 Overview: Using SmartIcons=[e-mail]>Overview
4 Hiding and showing a set of SmartIcons=[e-mail]>Steps
4 Hiding and showing bubble help for SmartIcons and InfoBox tabs=[e-mail]>Steps
4 Selecting and displaying a set of SmartIcons=[e-mail]>Steps
4 Moving a set of SmartIcons=[e-mail]>Steps
4 Changing the display size of SmartIcons=[e-mail]>Steps
3 Customizing SmartIcons
4 Overview: Customizing SmartIcons=[e-mail]>Overview
4 Adding an icon to a set of SmartIcons=[e-mail]>Steps
4 Creating an icon=[e-mail]>Steps
4 Editing an icon=[e-mail]>Steps
4 Attaching a script or macro to an icon=[e-mail]>Steps
4 Moving an icon within a set of SmartIcons=[e-mail]>Steps
4 Removing an icon from a set of SmartIcons=[e-mail]>Steps
4 Deleting a set of SmartIcons=[e-mail]>Steps
4 Saving a set of SmartIcons=[e-mail]>Steps
1 Formulas and @Functions
2 Using Formulas
3 Overview: Using formulas=[e-mail]>Overview
3 Guidelines for entering formulas=[e-mail]>Overview
3 Entering a formula=[e-mail]>Steps
3 Using range addresses in a formula=[e-mail]>Steps
3 Using range names in a formula=[e-mail]>Steps
3 Referring to other workbook files in formulas=[e-mail]>Steps
3 Editing a formula=[e-mail]>Steps
3 Updating file links=[e-mail]>Steps
3 Common errors in formulas=[e-mail]>Overview
3 When and how formulas recalculate=[e-mail]>Overview
2 Copying and Moving Formulas
3 Overview: Copying and moving formulas=[e-mail]>Overview
3 Copying a formula=[e-mail]>Steps
3 Copying a formula's result=[e-mail]>Steps
3 Moving a formula=[e-mail]>Steps
2 Using @Functions
3 Overview: @Functions=[e-mail]>Overview
3 Getting Help on an @function=[e-mail]>Steps
3 Entering an @function=[e-mail]>Steps
3 Adding an item to the @function menu=[e-mail]>Steps
3 Removing an item from the @function menu=[e-mail]>Steps
3 Rearranging items on the @function menu=[e-mail]>Steps
:include SSFN60EN.CNT
1 Macros
2 Overview: 1-2-3 macros=[e-mail]>Overview
2 Installing Help on macro commands=[e-mail]>Steps
2 Creating Macros
3 Writing a macro=[e-mail]>Steps
3 Syntax rules for macros=[e-mail]>Overview
3 Calling a script from a macro=[e-mail]>Steps
3 Naming and documenting a macro=[e-mail]>Steps
3 Saving a macro=[e-mail]>Steps
3 Creating a macro that runs automatically=[e-mail]>Steps
2 Using Macros
3 Running a macro=[e-mail]>Steps
3 Stopping a running macro=[e-mail]>Steps
3 Debugging a macro=[e-mail]>Steps
3 Common errors in macros=[e-mail]>OVERVIEW
3 Macro compatibility=[e-mail]>Overview
2 Info Components
3 Overview: Info components=[e-mail]>Overview
3 File info components=[e-mail]>Overview
3 Mapping info components=[e-mail]>Overview
3 Print info components=[e-mail]>Overview
3 Printer Setup info components=H_M_INFO_PRINTER>Overview
3 Sort info components=[e-mail]>Overview
3 User Setup info components=H_M_INFO_US>Overview
3 Window info components=[e-mail]>Overview
3 Worksheet Defaults info components=H_M_INFO_SWD>Overview
3 What's different in info components=[e-mail]>Overview
:include SSMN60EN.CNT
1 LotusScript
2 Overview: Using LotusScript in 1-2-3=[e-mail]>Overview
1 What's New for Upgraders
2 New Features
3 Team computing=[e-mail]>Overview
3 Productivity and ease of use=[e-mail]>Overview
3 Internet access=[e-mail]>Overview
3 Object Linking and Embedding=[e-mail]>Overview
3 Programmability=[e-mail]>Overview
3 Compatibility=[e-mail]>Overview
2 Using 1-2-3 Classic
3 Overview: 1-2-3 Classic=[e-mail]>Overview
3 Using 1-2-3 Classic=[e-mail]>Steps
2 Command Equivalents
3 For 1-2-3 for DOS Upgraders
4 Slash (/) Command Equivalents
5 /Copy=[e-mail]>Overview
5 /Data=[e-mail]>Overview
5 /File=[e-mail]>Overview
5 /Graph=[e-mail]>Overview
5 /Move=[e-mail]>Overview
5 /Print=[e-mail]>Overview
5 /Quit=[e-mail]>Overview
5 /Range=[e-mail]>Overview
5 /System=[e-mail]>Overview
5 /Worksheet=[e-mail]>Overview
4 Colon (:) Command Equivalents
5 :Display=[e-mail]>Overview
5 :Format=[e-mail]>Overview
5 :Graph=[e-mail]>Overview
5 :Named-Style=[e-mail]>Overview
5 :Print=[e-mail]>Overview
5 :Quit=[e-mail]>Overview
5 :Special=[e-mail]>Overview
5 :Text=[e-mail]>Overview
5 :Worksheet=[e-mail]>Overview
3 For 1-2-3 Release 5 for Windows Upgraders
4 Overview: Release 5 command equivalents=[e-mail]>Overview
4 Chart commands=[e-mail]>Overview
4 Edit commands=[e-mail]>Overview
4 File commands=[e-mail]>Overview
4 Help commands=[e-mail]>Overview
4 Query commands=[e-mail]>Overview
4 Range commands=[e-mail]>Overview
4 Style commands=[e-mail]>Overview
4 Tools commands=[e-mail]>Overview
4 Transcript commands=[e-mail]>Overview
4 View commands=[e-mail]>Overview
4 Window commands=[e-mail]>Overview
2 Macro - LotusScript Command Equivalents
3 1-2-3 Release 5 Macro Command Equivalents
4 Overview: Release 5 macro command equivalents=[e-mail]>Overview
4 Chart macro commands=[e-mail]>Overview
4 Data manipulation macro commands=[e-mail]>Overview
4 Database macro commands=[e-mail]>Overview
4 DDE and OLE macro commands=[e-mail]>Overview
4 Edit macro commands=[e-mail]>Overview
4 File macro commands=[e-mail]>Overview
4 Flow-of-control macro commands=[e-mail]>Overview
4 Keystroke equivalents=[e-mail]>Overview
4 Navigation macro commands=[e-mail]>Overview
4 Range macro commands=[e-mail]>Overview
4 SmartIcons macro commands=H_123_SMARTICON_MACRO_COMMANDS_REF>Overview
4 Solver macro commands=[e-mail]>Overview
4 Style macro commands=[e-mail]>Overview
4 Text file macro commands=[e-mail]>Overview
4 Tools macro commands=[e-mail]>Overview
4 User environment macro commands=[e-mail]>Overview
4 Version Manager macro commands=[e-mail]>Overview
4 Window and screen display macro commands=[e-mail]>Overview
3 1-2-3 Release 5 Info Component Equivalents
4 Overview: Release 5 info component equivalents=[e-mail]>Overview
4 File info component equivalents=[e-mail]>Overview
4 Macro debug info component equivalents=[e-mail]>Overview
4 Mapping info component equivalents=[e-mail]>Overview
4 Print info component equivalents=[e-mail]>Overview
4 Printer Setup info component equivalents=H_123_PRINTER_SETUP_INFO_COMPONENTS_REF>Overview
4 Sort info component equivalents=[e-mail]>Overview
4 User Setup info component equivalents=H_123_USER_SETUP_INFO_COMPONENTS_REF>Overview
4 Window info component equivalents=[e-mail]>Overview
4 Worksheet Defaults info component equivalents=H_123_WORKSHEET_DEFAULTS_INFO_COMPONENTS_REF>Overview
1 Troubleshooting
:include CS1N97EN.CNT