PC World Komputer 1998 October A/Pcwk10a98.iso/Lotus/LOTUS/123/SS1N70EN.CNT

Microsoft Windows Help File Content | 1998-05-12 | 59KB | 789 lines

:Base SS1N70EN.HLP>Steps
:Title 1-2-3 Help
:Index @Function Help=SSFN70EN.HLP
:Index Macro Help=SSMN70EN.HLP
:Index Lotus Chart Help=LC1N22EN.HLP
:Index Lotus TeamMail Help=TM1N11EN.HLP
:Index Lotus Customer Support Help=CS1N60EN.HLP
:Link SSFN70EN.HLP
:Link SSSN70EN.HLP
1 Copyright and trademark information =[e-mail]>overview
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 Learning 1-2-3=H_LEARN123_OVER>Overview
3 Using QuickDemos=[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 Using the Expert to get help=[e-mail]>Steps
3 Conventions used in Help=[e-mail]>Overview
3 Finding examples in 1-2-3 Help=[e-mail]>Overview
3 Printing Help information=[e-mail]>Steps
1 What's New?
2 New features in 1-2-3=[e-mail]>Overview
2 Information for 1-2-3 Upgraders
3 Compatibility=[e-mail]>Overview
3 Sharing Files with Previous 1-2-3 Releases
4 Working with 1-2-3 for Windows files =[e-mail]>Overview
4 Working with 1-2-3 for DOS files =[e-mail]>Overview
4 Working with 1-2-3 for OS/2 files =[e-mail]>Overview
3 Upgrading from 1-2-3 for DOS
4 Overview: 1-2-3 Classic=[e-mail]>Overview
4 Using 1-2-3 Classic=[e-mail]>Steps
3 Upgrading from 1-2-3 Release 5 for Windows
4 Overview: Release 5 command equivalents=[e-mail]>Overview
4 Overview: Release 5 macro command equivalents=[e-mail]>Overview
4 Overview: Release 5 info component equivalents=[e-mail]>Overview
2 Information for Excel Users
3 Using the Microsoft Excel Menu Finder =[e-mail]>Steps
3 Microsoft Excel command equivalents in 1-2-3 =[e-mail]>Overview
3 Excel function equivalents in 1-2-3 =[e-mail]>Overview
3 Working with Excel files=[e-mail]>Overview
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 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
4 Setting a default 1-2-3 file type=[e-mail]>Steps
3 Changing 1-2-3 Preferences
4 Overview: 1-2-3 preferences=[e-mail]>Overview
4 Setting 1-2-3 options=[e-mail]>Steps
4 Setting sorting options=[e-mail]>Steps
4 1-2-3 and the year 2000=[e-mail]>Overview
4 Setting options for dates=[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
3 Working with ActiveX and Java Controls
4 Overview: ActiveX controls and JavaBeans in 1-2-3=[e-mail]>Overview
4 Before you begin designing controls=[e-mail]>Steps
4 Embedding ActiveX controls and JavaBeans in a workbook=[e-mail]>Steps
4 Setting the properties for a control=[e-mail]>Steps
4 Writing scripts and testing controls=[e-mail]>Steps
2 Find and Select
3 Selecting Sheet Areas
4 Overview: Selecting sheet areas=[e-mail]>Overview
4 Selecting 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 Entering a formula=[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 by dragging=H_FILLING_A_RANGE_USING_DRAGANDFILL_STEPS
4 Overview: Creating custom SmartFill lists=[e-mail]>Overview
4 Creating a custom SmartFill list=[e-mail]>Steps
4 Modifying a custom SmartFill 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 Deleting data by dragging=[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 data down to fill a range=[e-mail]>Steps
4 Copying data right to fill a range=[e-mail]>Steps
4 Copying to fill a 3D range=[e-mail]>Steps
4 Copying a sheet=[e-mail]>Steps
4 Copying column widths and row heights=[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 Adding a number format to the Frequently Used list=[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 style templates=[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
4 Updating the Preview window=[e-mail]>Steps
3 Changing Print and Page Properties
4 Overview: Print and page properties=[e-mail]>Overview
4 Changing print margins=[e-mail]>Steps
4 Changing page orientation=[e-mail]>Steps
4 Fitting your work on the printed page=[e-mail]>Steps
4 Centering data on the printed page=[e-mail]>Steps
4 Numbering printed pages=[e-mail]>Steps
4 Adding headers and footers=[e-mail]>Steps
4 Changing font properties for headers and footers=[e-mail]>Steps
4 Printing titles on each page=[e-mail]>Steps
4 Adding a page break=[e-mail]>Steps
4 Removing a page break=[e-mail]>Steps
4 Changing the paper size=[e-mail]>Steps
4 Changing the print selection=[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, tables, 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
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
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 from different files=[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 with Previous 1-2-3 Releases
3 Working with 1-2-3 for Windows files =[e-mail]>Overview
3 Working with 1-2-3 for DOS files =[e-mail]>Overview
3 Working with 1-2-3 for OS/2 files =[e-mail]>Overview
3 Sharing Files with Excel
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 Excel function equivalents in 1-2-3=[e-mail]>Overview
3 Sharing Files with Quattro Pro, dBASE, and Paradox
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 Aligning graphic objects to the grid=[e-mail]>Steps
4 Fastening graphic objects to cells=[e-mail]>Steps
4 Hiding or redisplaying graphic objects=[e-mail]>Steps
4 Locking or unlocking graphic objects=[e-mail]>Steps
4 Layering 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 LC1N22EN.CNT
2 Work with Maps
3 Presenting Data in a Map
4 Introducing maps in 1-2-3=[e-mail]>Overview
4 Setting up map data=[e-mail]>Steps
4 Creating a map=[e-mail]>Steps
4 Checking unrecognized region names=[e-mail]>Steps
4 Adding pin characters to a map=[e-mail]>Steps
4 Determining latitude and longitude=[e-mail]>Steps
3 Changing Map Content
4 Modifying a map=[e-mail]>Overview
4 Naming a map=[e-mail]>Steps
4 Changing map range assignments=[e-mail]>Steps
4 Changing map legend labels=[e-mail]>Steps
4 Changing a map title=[e-mail]>Steps
4 Changing bin definitions for colors or patterns=[e-mail]>Steps
4 Overlaying additional map areas=[e-mail]>Steps
4 Removing an overlay from a map=[e-mail]>Steps
4 Redrawing maps=[e-mail]>Steps
3 Changing Map Appearance
4 Changing bin colors or patterns=[e-mail]>Steps
4 Zooming in or out of a map=[e-mail]>Steps
4 Choosing the center of a map=[e-mail]>Steps
4 Changing the plot area of a map=[e-mail]>Steps
4 Changing map legend position=[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 and Approach=[e-mail]>Overview
3 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 Controlling the display of the output range=[e-mail]>Steps
4 Sizing a query table=[e-mail]>Steps
4 Moving 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 Deleting a query table=[e-mail]>Steps
4 Refreshing data in a query table=[e-mail]>Steps
4 Joining database tables=[e-mail]>Steps
4 Overview: ODBC drivers=[e-mail]>Overview
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 database form=[e-mail]>Steps
4 Working with a database form=[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 database report=[e-mail]>Steps
4 Working with a database report=[e-mail]>Steps
4 Creating a dynamic crosstab=[e-mail]>Steps
4 Working with a dynamic crosstab=[e-mail]>Steps
4 Refreshing 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 Work with Database Tables Using the Data Query Add-In (DQA)
3 Overview: Data Query Add-In (DQA)=[e-mail]>Overview
3 Comparing the Data Query Add-In (DQA) to 1-2-3 Release 5=[e-mail]>Overview
3 Loading the Data Query Add-In (DQA)=[e-mail]>Steps
3 Unloading the Data Query Add-In (DQA)=[e-mail]>Steps
3 Working with DQA Query Tables
4 Creating a DQA query table=[e-mail]>Steps
4 Selecting a DQA query table=[e-mail]>Steps
4 Refreshing a DQA query table=[e-mail]>Steps
4 Renaming a DQA query table=[e-mail]>Steps
4 Deleting a DQA query table=[e-mail]>Steps
3 Modifying DQA Query Tables
4 Changing the criteria for a DQA query table=[e-mail]>Steps
4 Changing the fields in a DQA query table=[e-mail]>Steps
4 Showing unique records in a DQA query table=[e-mail]>Steps
4 Selecting a different database table=[e-mail]>Steps
4 Limiting the records in a DQA query table=[e-mail]>Steps
4 Showing an alias field name in a DQA query table=[e-mail]>Steps
4 Listing sample values for DQA criteria=[e-mail]>Steps
4 Joining database tables with DQA=[e-mail]>Steps
3 Analyzing Data in DQA Query Tables
4 Sorting a DQA query table=[e-mail]>Steps
4 Adding a computed column to a DQA query table=[e-mail]>Steps
4 Changing a computed column in a DQA query table=[e-mail]>Steps
4 Creating aggregate summaries in a DQA query table=[e-mail]>Steps
3 Managing Records with DQA
4 Updating a database table with DQA=[e-mail]>Steps
4 Appending records with DQA=[e-mail]>Steps
4 Deleting records with DQA=[e-mail]>Steps
3 Working with External Database Tables and DQA
4 Connecting to an external database table with DQA=[e-mail]>Steps
4 Disconnecting from an external database table=[e-mail]>Steps
4 Creating an external database table with DQA=[e-mail]>Steps
4 Sending SQL commands with DQA=[e-mail]>Steps
4 Generating SQL command equivalents=[e-mail]>Steps
3 Creating a DQA Crosstab
4 Overview: Creating DQA crosstabs=[e-mail]>Overview
4 Selecting the data for a DQA crosstab=[e-mail]>Steps
4 Selecting headings for a DQA crosstab=[e-mail]>Steps
4 Selecting data options for a DQA crosstab=[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 1-variable what-if table=H_SETTING_UP_A_ONE_VARIABLE_WHATIF_TABLE_STEPS
4 Setting up a 2-variable what-if table=H_SETTING_UP_A_TWO_VARIABLE_WHATIF_TABLE_STEPS
4 Setting up a 3-variable what-if table=H_SETTING_UP_A_THREE_VARIABLE_WHATIF_TABLE_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 Linking Data Using OLE
5 Overview: Sharing data using OLE=[e-mail]>Overview
5 What is an OLE link?=[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 Working with datalink tables=[e-mail]>Overview
5 Updating links=[e-mail]>Steps
5 Changing a link's update mode=[e-mail]>Steps
5 Editing links=[e-mail]>Steps
5 Breaking links=[e-mail]>Steps
4 Embedding Objects Using OLE
5 Overview: Sharing data using OLE=[e-mail]>Overview
5 What is an embedded object?=[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
4 Linking Data Using DDE
5 Overview: Sharing data using DDE=[e-mail]>Overview
5 Creating DDE links=[e-mail]>Steps
5 1-2-3 as a DDE client=[e-mail]>Overview
5 1-2-3 as a DDE server=[e-mail]>Overview
5 Updating links=[e-mail]>Steps
5 Changing a link's update mode=[e-mail]>Steps
5 Editing links=[e-mail]>Steps
5 Breaking links=[e-mail]>Steps
5 Glossary of DDE terms=[e-mail]>Overview
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
1 Working with 1-2-3 and the Internet
2 Configuring Internet Options
3 Overview: Working with Internet connections=[e-mail]>Overview
3 Specifying proxy information=[e-mail]>Steps
3 Setting advanced HTTP connection options=[e-mail]>Steps
3 Adding connection information for FTP hosts =[e-mail]>STEPS
3 Editing connection information for FTP hosts =[e-mail]>STEPS
3 Deleting connection information for FTP hosts =[e-mail]>STEPS
2 Bringing Data from the Web into 1-2-3
3 Working with Web Tables
4 Working with Web tables=[e-mail]>Overview
4 Getting data from the Web=[e-mail]>Steps
4 Selecting a Web table=[e-mail]>Steps
4 Moving a Web table=[e-mail]>Steps
4 Refreshing data in a Web table=[e-mail]>Steps
4 Breaking the connection to the Web=[e-mail]>Steps
4 Printing a Web table=[e-mail]>Steps
4 Deleting a Web table=[e-mail]>Steps
3 Changing Web Table Properties
4 Changing a Web table name and source URL=[e-mail]>Steps
4 Sizing a Web table=[e-mail]>Steps
4 Selecting refresh options for a Web table=[e-mail]>Steps
2 Opening and Saving Internet Files
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 Working with HTML files=[e-mail]>Overview
3 Opening an HTML file=[e-mail]>STEPS
3 Searching for text on the Internet=[e-mail]>Steps
3 Saving a workbook to an FTP server on the Internet =[e-mail]>Steps
3 Converting a range to an HTML table =[e-mail]>STEPS
3 Converting a range, sheet, or workbook to jDoc format =H[e-mail]>STEPS
2 Working with Hyperlinks
3 Creating a hyperlink=[e-mail]>Steps
3 Editing a hyperlink=[e-mail]>Steps
3 Removing a hyperlink=[e-mail]>Steps
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
2 Using FastSite to Create and Publish Web Sites
3 FastSite and the other SmartSuite applications=[e-mail]>Overview
3 1-2-3 and FastSite=[e-mail]>Steps
1 QuickDemo Catalog
2 Using QuickDemos=H_LEARN123_DEMOS_OVER>Overview
2 Using the Infobox
3 Using the InfoBox=[e-mail]>STEPS
2 Entering, Editing, and Calculating Data
3 Filling a range by dragging=[e-mail]>STEPS
3 Filling a range with dates=[e-mail]>STEPS
3 Deleting data by dragging=[e-mail]>STEPS
3 Creating a cell comment=[e-mail]>STEPS
3 Summing a range automatically=[e-mail]>STEPS
2 Copying and Moving Data
3 Copying down to fill a range=[e-mail]>STEPS
3 Copying right to fill a range=[e-mail]>STEPS
3 Moving a sheet using drag and drop=[e-mail]>STEPS
2 Naming Sheets and Ranges
3 Naming a sheet=[e-mail]>STEPS
3 Naming a range=[e-mail]>STEPS
3 Naming a range using adjacent labels=[e-mail]>STEPS
2 Changing Columns and Rows
3 Sizing columns=[e-mail]>STEPS
3 Fitting the widest column entry=[e-mail]>STEPS
3 Hiding columns=[e-mail]>STEPS
3 Sizing rows=[e-mail]>STEPS
3 Freezing columns and rows as titles=[e-mail]>STEPS
2 Ordering and Outlining Data
3 Sorting data=[e-mail]>STEPS
3 Outlining data in 1-2-3=[e-mail]>OVERVIEW
3 Demoting rows and columns to create an outline=[e-mail]>STEPS
3 Collapsing an outline to show less detail=[e-mail]>STEPS
3 Expanding an outline to show more detail=[e-mail]>STEPS
2 Working with Versions and Version Groups
3 Creating a version=[e-mail]>STEPS
3 Displaying a version=[e-mail]>STEPS
3 Creating a version group=[e-mail]>STEPS
2 Working with Graphic Objects
3 Creating a text block=[e-mail]>STEPS
3 Creating a map=[e-mail]>STEPS
2 Working with Data Queries
3 Working with 1-2-3 database tables=[e-mail]>OVERVIEW
2 Changing Print Properties
3 Adding headers and footers=[e-mail]>STEPS
3 Changing print margins=[e-mail]>STEPS
1 Tools for Getting Your Work Done
2 Overview: Installing additional language versions of 1-2-3=[e-mail]>Overview
2 Ways to perform tasks=H_WAYS_TO_PERFORM_TASKS_OVER>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 1-2-3 menus=[e-mail]>Overview
3 Getting Help on a menu command=[e-mail]>Steps
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=[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 Saving a set of SmartIcons=[e-mail]>Steps
4 Deleting 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 SmartLabels
3 Working with SmartLabels=[e-mail]>Overview
3 Summing a range automatically=[e-mail]>Steps
3 Creating a SmartLabel=[e-mail]>Steps
3 Editing a SmartLabel=[e-mail]>Steps
3 Deleting a SmartLabel=[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 SSFN70EN.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 What's different in info components=[e-mail]>Overview
:include SSMN70EN.CNT
1 LotusScript
2 Overview: Using LotusScript in 1-2-3=[e-mail]>Overview
1 Troubleshooting
:include CS1N60EN.CNT