PC World Komputer 1998 October A

home *** CD-ROM | disk | FTP | other *** search

/ PC World Komputer 1998 October A / Pcwk10a98.iso / Lotus / LOTUS / 123 / LAGN11EN.DLL / string.txt

Wrap

Text File | 1998-04-27 | 12KB | 214 lines

1424 Filling a range by dragging 2425 Select the cell or range containing the data you want to base the sequence on. 2426 Position the mouse pointer at the bottom right corner of the cell or range until the pointer displays four arrowheads. 2427 Drag to select the range to fill. 2428 Release the mouse button. 2848 Changing print margins 3392 Creating a cell comment 3849 From the File menu, choose Preview & Page Setup. 3850 Notice that the margins appear as dashed lines in the Preview window. 3851 Click this tab for margin information. 3852 Enter the new margins. 3853 Your changes appear in the Preview window. 3854 If you want to print now, right-click in the Preview window to display the shortcut menu. 3855 If you like, you can close the InfoBox... 3856 ...and close the Preview window. 4393 Click the cell. 4394 Choose Range - Cell Comment. 4395 (Optional) Click Name and Date Stamp. 4396 Enter the comment text. 4397 (Optional) Move, collapse, or close the InfoBox. 4816 Deleting data by dragging 4860 1 4864 2 5402 Based on field estimates 5817 Select the range you want to clear. 5818 Position the mouse pointer at the bottom right corner of the range until the pointer displays four arrowheads. 5819 Hold down the left mouse button and drag up and to the left to delete data in the range. 5820 Release the mouse button. 5821 (Optional) To delete the top left cell of the range, press DEL. 6784 Creating a map 7785 Set up the range of data you want to map. 7786 Select the range containing the map data, or select a single cell within the range. 7787 Choose Create - Map. 7788 Click the sheet where you want the top left corner of the map to appear. 10176 Freezing columns and rows as titles 11177 To freeze columns, position the mouse pointer on the border of the sheet frame to the right of the row numbers and drag right to the last column you want to freeze. 11178 To freeze rows, position the mouse pointer on the border of the sheet frame below the column letters and drag down to the last row you want to freeze. 13568 Expanding an outline to show more detail 14569 To expand a single outlined section of the sheet to a particular level, click the plus sign for the level you want to expand. 14570 To expand all outlined sections of the sheet to a particular level, click the outline-level button corresponding to that level. 16960 Displaying a version 17961 Choose Range - Version - Display Version. 17962 From the "Display version for range" list, select the range containing the version you want to display. 17963 From the list of versions, select the version you want to display. 17964 If the version is in a part of the sheet outside the displayed area and you want to see the version when you display it, select "Go to version when displayed." 17965 Click Display. 17966 (Optional) To display another version of the same range, repeat step 3; to display a version of a different named range, repeat steps 2 and 3. 17967 Click Done. 18384 Adding headers and footers 19385 From the File menu, choose Preview & Page Setup. 19386 1-2-3 displays the Preview window on the right... 19387 ...and opens the InfoBox. 19388 Click this tab for header and footer information. 19389 Select the header or footer segment you want to create. 19390 You can type text in the box. 19391 You can also use these icons to enter information... 19392 ...such as the page number. 19393 1-2-3 enters a symbol in the InfoBox... 19394 ...but displays the actual information in the Preview window. 19395 You can click in the Preview window for a closer look. 19396 If you want to print now, right-click in the Preview window to display the shortcut menu. 19397 If you like, you can close the InfoBox... 19398 ...and close the Preview window. 20352 Creating a text block 20397 Page 21353 Choose Create - Text. 21354 Move the mouse pointer where you want the text block to appear. 21355 Click to create a default-sized text block, or drag until the text block is the size you want. 21356 Release the mouse button. 21357 Enter text by typing or by pasting it from the Clipboard. 21358 When you finish entering text, click in the sheet. 22320 Naming a sheet 22357 Great year! 23321 Double-click the tab of the sheet you want to name. 23322 Enter a name according to the naming conventions. 23323 Press ENTER. 24322 RESULTS 25712 Copying down to fill a range 26713 Select the range. 26714 Choose Edit - Copy Down. 29104 Demoting rows and columns to create an outline 30105 Make sure you have specified how summary data relates to detail data. 30106 Select the row numbers or column letters for the rows or columns you want to demote. 30107 Choose Sheet - Outline - Demote Rows, or Sheet - Outline - Demote Columns. 30176 Naming a range 31177 Select the range you want to name. 31178 Choose Range - Name. 31179 Enter a range name in the "Name" box according to the naming conventions. 31180 (Optional) To name another range, click Add and repeat steps 1 and 3. 31181 Click OK. 32180 RESULTS 32186 REGIONS 32496 Creating a version 33497 Select the range. 33498 Choose Range - Version - New Version. 33499 If the range is not already named, enter a name in the "Name of range containing versions" box or accept the default name. 33500 Accept the default version name or enter a different name in the "Name of new version" box. 33501 (Optional) To copy data in the original named range into the new version, select "Use current data for new version." 33502 (Optional) Click Next to enter a comment or set options. 33503 Click Done. 33920 Working with 1-2-3 database tables 34464 Sizing columns 34504 BestCase 34507 Let's hope for the best! 34921 A 1-2-3 database table is a worksheet range containing data... 34922 organized in columns called fields... 34923 and rows called records. 34924 The first row of a database table contains a name for each field. 34925 Each field name represents a category of data. 34926 For example, this field contains names of products. 34927 Each row below the field names contains a record. 34928 This is a record of a sale of violins to Vivaldi Strings. 34929 You can find records, and analyze and summarize the data in a database table. 34930 To find records in a database table, you use a query table. 34931 For example, this query table finds all the records for sales of violas. 34932 1-2-3 gives you many other ways to work with database tables. 34933 You can create mailing labels, summarize data in a report, and use a crosstab to analyze data. 34934 For example, this crosstab shows the number of each instrument sold by each sales representative. 34935 To work with a 1-2-3 database table, use the Create - Database commands or the Data Query Add-In (DQA). 35465 Position the mouse pointer on the column border to the right of the column letter. 35466 Drag the border right or left until the column is the width you want. 35467 Release the mouse button. 35888 Sorting data 36889 Select the range of data you want to sort. 36890 Choose Range - Sort. 36891 From the "Available columns" list, select a column to sort by. 36892 Click >> or drag the selected column into the "Sort by" list. 36893 (Optional) If two or more records have the same entry for the column you selected, add another column to the "Sort by" list. 36894 Under Sort order, select an option. 36895 (Optional) Select "Header at top" and enter a number or click the arrows to indicate how many rows make up the headers. 36896 Click OK. 37312 Outlining data in 1-2-3 37856 Using the InfoBox 38313 1-2-3's outlining feature simplifies finding data in large worksheets. 38314 For example, this worksheet contains sales data for Western Europe and the United States. 38315 To compare Q1 sales with Q3 sales, you have to look at row 16... 38316 ...and then look down to row 32. 38317 1-2-3's outline feature lets you collapse data to make the comparison easier. 38318 This sheet has been formatted as an outline. 38319 Clicking the outer button here collapses all the rows in the outline. 38320 1-2-3 collapses the rows between 3 and 16... 38321 ...19 and 32... 38322 ...and 35 and 48. 38323 Now, suppose you want to compare West European sales with U.S. sales. 38324 With outlining, you can also collapse columns. 38325 Clicking the outer button here collapses all the columns in the outline. 38326 1-2-3 collapses the columns between A and D... 38327 ...and between D and G. 38328 Now, let's say you want to redisplay just U.S. sales by city. 38329 With outlining, you can work with parts of the sheet. 38330 A plus sign indicates that this section of the outline is collapsed. 38331 Clicking this plus sign redisplays this section. 38332 This minus sign indicates that this section is fully expanded. 38333 Outlining is a helpful way to streamline your large worksheets. 38857 Select what you want to modify. 38858 Right-click the selection and choose the Properties command. 38859 Click the tab for the properties you want to change. 38860 Select one or more options. 38861 (Optional) Move, collapse, or close the InfoBox. 39866 {TAB}{HOME}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{ENTER} 44640 Collapsing an outline to show less detail 45641 To collapse a single outlined section of the sheet to a particular level, click the minus sign for the level you want to collapse. 45642 To collapse all outlined sections of the sheet to a particular level, click the outline-level button corresponding to that level. 45712 Copying right to fill a range 46713 Select the range. 46714 Choose Edit - Copy Right. 50000 Fitting the widest column entry 51001 Position the mouse pointer on the column border to the right of the column letter. 51002 Double-click the border. 51424 Summing a range automatically 52425 Enter the data in the sheet. 52426 To sum columns, select the cell to the left of where you want to display the sum. 52427 Type Total or Totals. 52428 Press ENTER. 52496 Creating a version group 52848 Moving a sheet using drag and drop 53392 Hiding columns 53428 Total 53497 Choose Range - Version - Version Groups. 53498 Click New Group. 53499 Enter a name in the "Name of version group" box or accept the default name. 53500 To add a version to the new group, drag it from the "Available versions" list to the "Versions in group" list. 53501 To remove a version from the group, drag it outside the "Versions in group" list. 53502 From the "Protection for group list, " select an option: "Protected, " "Unprotected, " or "Hidden." 53503 (Optional) In the "Comments" box, enter a comment about the version group. 53504 Click OK to return to the Version Groups dialog box. 53505 Click Done. 53849 Drag the edge of the tab for the sheet you want to move.... 53850 ...to where you want to move it. 54393 Position the mouse pointer in the sheet frame on the right border of the column you want to hide. 54394 Drag the column border left until the indicator shows column size as 0 (zero) characters. 54395 Release the mouse button. 54507 This is the most realistic scenario. 56784 Filling a range with dates 57785 Select the range to fill. 57786 Choose Range - Fill. 57787 In the "Fill using" list, select " Dates." 57788 Select an lnterval. 57789 Enter the start date and the increment. 57790 (Optional) Enter the stop date. 57791 Click OK. 58792 10-Sep-1997 58796 10-Sep-2007 60176 Naming a range using adjacent labels 61177 Select the range containing the labels you want to use as range names. 61178 From the Range menu, choose Name. 61179 Click Use Labels. 61180 Select an option from the "For cells" list. 61181 Click Done. 63568 Sizing rows 64569 Position the mouse pointer on the bottom border of the row. 64570 Drag the border up or down until the row is the height you want. 64571 Release the mouse button.