Create a formula to calculate data on a Lotus 1-2-3 worksheet

Microsoft Office Excel 2003

previous page next page

Show All Show All

Create a formula to calculate data on a Lotus 1-2-3 worksheet

Some of the content in this topic may not be applicable to some languages.

  1. Open the Lotus 1-2-3 worksheet that contains the source data.

    ShowHow?

    1. In your Microsoft Office program, click File, and then click Open.
    2. In the Look in, list click the drive, folder, or Internet location that contains the file you want to open.
    3. In the folder list, locate and open the folder that contains the file.

      If you can't find the file, you can search for it.

      ShowHow?

      1. Click Open Button image.
      2. Click Tools in the Open dialog box, and then click Search.
      3. Do one of the following:

        ShowSearch for a file containing specified text

        You can find a file containing text in its title, contents, or properties.

        1. On the Basic tab, in the Search text box, type the text to search for in Microsoft Office files, Web pages, and Microsoft Outlook items.

          ShowTip

          You can use wildcards in the Search text box. Type a question mark (?) to match any single character, or type an asterisk (*) to match any number of characters. For example, s?t finds "sat" and "set"; s*d finds "sad" and "started."
        2. To limit where to search, in the Search in box, select one or more drives, folders, Web sites, or Outlook mailboxes. To search everywhere, select Everywhere. To specify a single location, type it directly in the Search in box.
        3. To limit the types of search results, in the Results should be box, select the types of items to find. To find all types of files, Web pages, and Outlook items, select Anything.
        4. Click Search.

          ShowTip

          To view all properties of a found item, click the command button following the item, and then choose Properties.

        ShowSearch for a file based on one or more properties

        1. On the Advanced tab, enter one or more search criteria.

          ShowHow?

          1. In the Property box, choose a property from the list or type in a property name. The Property box displays the properties available in the currently open document.

            ShowTip

            You can use wildcards in the Property box. Type a question mark (?) to match any single character, or type an asterisk (*) to match any number of characters. For example, s?t finds "sat" and "set"; s*d finds "sad" and "started."

          2. In the Condition box, choose a condition from the list, or type in a condition.
          3. In the Value box, enter the value to associate with the condition.
          4. If previous search criteria exist, click And to add a criterion that must be true in addition to previous criteria. Click Or to add a criterion that is sufficient regardless of previous criteria.
          5. Click Add to add the search criterion.

            Note   If the value is invalid for the condition or property, the Add button is unavailable.

        2. To limit where to search, in the Search in box, select one or more drives, folders, Web sites, or Outlook mailboxes. To search everywhere, select Everywhere. To specify a single drive, folder, or Web site, type it directly in the Search in box.
        3. To limit the types of search results, in the Results should be box, select the types of files, Web pages, and Outlook items to find. To find all types of files and items, select Anything.
        4. Click Search.

          ShowTip

          To view all properties of a found item, click the command button following the item, and then choose Properties.
    4. Click the file, and then click Open.

    ShowOpen a file as a copy

    1. In your Office program, click File, and then click Open.
    2. In the Look in list, click the drive, folder, or Internet location that contains the file you want to open.
    3. In the folder list, locate and open the folder that contains the file.

      If you can't find the file, you can search for it.

      ShowHow?

      You can search the titles, contents, or properties of Microsoft Office files, Microsoft Outlook items, and Web pages.

      1. On the Standard toolbar, click Search Button image.
      2. Do one of the following:

        ShowSearch for a file or Outlook item containing specified text

        You can find a file or Outlook item containing text in its title, contents, or properties.

        1. In the Search text box, type the text to search for in Office files, Web pages, and Outlook items

          ShowTips

          • Type a question mark (?) to match any single character in your search text, or type an asterisk (*) to match any number of characters. For example, s?t finds "sat" and "set"; s*d finds "sad" and "started."
          • When searching for Outlook items, use natural language searches. Natural language searching is only supported in English versions of Microsoft Office XP and later.
        2. To limit where to search, in the Search in box, select one or more drives, folders, Web sites, or Outlook mailboxes. To search everywhere, select Everywhere.
        3. To limit the types of search results, in the Results should be box, select the types of items to find. To find all types of files, Web pages, and Outlook items, select Anything.
        4. Click Search.

        ShowSearch for a file or Outlook item based on one or more properties

        1. In the Basic Search task pane, click Advanced Search.
        2. Enter one or more search criteria.

          ShowHow?

          1. In the Property box, choose a property from the list or type in a property name. The Property box displays the properties available in the currently open document.
          2. In the Condition box, choose a condition from the list, or type in a condition.
          3. In the Value box, enter the value to associate with the condition.
          4. If previous search criteria exist, click And to add a criterion that must be true in addition to previous criteria. Click Or to add a criterion that is sufficient regardless of previous criteria.
          5. Click Add to add the search criterion.

            Note   If the value is invalid for the condition or property, the Add button is unavailable.

        3. To limit where to search, in the Search in box, select one or more drives, folders, Web sites, or Outlook mailboxes. To search everywhere, select Everywhere.
        4. To limit the types of search results, in the Results should be box, select the types of files, Web pages, and Outlook items to find. To find all types of files and items, select Anything.
        5. Click Search.
      I n the Search Results task pane, you can take one or more actions on the search results.

      ShowHow?

      • To quickly view an item's properties, rest the mouse pointer over the item.

      • To open an item in its default editor, click it.

      • To open an item in an Office application, click the command button following the item, and then choose Edit with <application>.

      • To view a Web page in a browser, click the command button following the item, and then choose Open in Browser.

      • To create a new document based on the selected item, click the command button following the item, and then choose New from this file.

      • To copy a hyperlink to the selected item onto the Office Clipboard, click the command button following the item, and then choose Copy link to clipboard.

      • To view all properties of an item, click the command button following the item, and then choose Properties.

    4. Select the file you want to open a copy of. Click the arrow next to the Open button, and then click Open as Copy.

    Note   When you open a file as a copy, a new copy of the file is created in the folder that contains the original file.

    ShowOpen a file as read-only

    1. In your Office program, click File, and then click Open.
    2. In the Look in list, click the drive, folder, or Internet location that contains the file you want to open.
    3. In the folder list, locate and open the folder that contains the file.

      If you can't find the file, you can search for it.

      ShowHow?

      You can search the titles, contents, or properties of Microsoft Office files, Microsoft Outlook items, and Web pages.

      1. On the Standard toolbar, click Search Button image.
      2. Do one of the following:

        ShowSearch for a file or Outlook item containing specified text

        You can find a file or Outlook item containing text in its title, contents, or properties.

        1. In the Search text box, type the text to search for in Office files, Web pages, and Outlook items

          ShowTips

          • Type a question mark (?) to match any single character in your search text, or type an asterisk (*) to match any number of characters. For example, s?t finds "sat" and "set"; s*d finds "sad" and "started."
          • When searching for Outlook items, use natural language searches. Natural language searching is only supported in English versions of Microsoft Office XP and later.
        2. To limit where to search, in the Search in box, select one or more drives, folders, Web sites, or Outlook mailboxes. To search everywhere, select Everywhere.
        3. To limit the types of search results, in the Results should be box, select the types of items to find. To find all types of files, Web pages, and Outlook items, select Anything.
        4. Click Search.

        ShowSearch for a file or Outlook item based on one or more properties

        1. In the Basic Search task pane, click Advanced Search.
        2. Enter one or more search criteria.

          ShowHow?

          1. In the Property box, choose a property from the list or type in a property name. The Property box displays the properties available in the currently open document.
          2. In the Condition box, choose a condition from the list, or type in a condition.
          3. In the Value box, enter the value to associate with the condition.
          4. If previous search criteria exist, click And to add a criterion that must be true in addition to previous criteria. Click Or to add a criterion that is sufficient regardless of previous criteria.
          5. Click Add to add the search criterion.

            Note   If the value is invalid for the condition or property, the Add button is unavailable.

        3. To limit where to search, in the Search in box, select one or more drives, folders, Web sites, or Outlook mailboxes. To search everywhere, select Everywhere.
        4. To limit the types of search results, in the Results should be box, select the types of files, Web pages, and Outlook items to find. To find all types of files and items, select Anything.
        5. Click Search.
      I n the Search Results task pane, you can take one or more actions on the search results.

      ShowHow?

      • To quickly view an item's properties, rest the mouse pointer over the item.

      • To open an item in its default editor, click it.

      • To open an item in an Office application, click the command button following the item, and then choose Edit with <application>.

      • To view a Web page in a browser, click the command button following the item, and then choose Open in Browser.

      • To create a new document based on the selected item, click the command button following the item, and then choose New from this file.

      • To copy a hyperlink to the selected item onto the Office Clipboard, click the command button following the item, and then choose Copy link to clipboard.

      • To view all properties of an item, click the command button following the item, and then choose Properties.

    4. Select the file you want to open a copy of. Click the arrow next to the Open button, and then click Open as Read-Only.

    ShowTips

    • You can create a shortcut to a folder on a network file server or Web server. Use My Network Places.
    • The New File task pane displays a list of the last few files that you most recently opened. Click on the file name to open it.
    • The History folder in the Open window lists the previous files and folders that you have opened.
  2. On the Lotus 1-2-3 worksheet, select the cells you want to link to.
  3. Click Copy Button image on the Standard toolbar.
  4. Switch to the Microsoft Excel workbook that will contain the link formula.
  5. Select the cell in the upper-left corner of the paste area where you want to put the linked data.

    To ensure that the linked data does not replace existing data, make sure that the worksheet has no data below or to the right of the cell you click.

  6. On the Edit menu, click Paste Special.
  7. Click Paste Link.
previous page start next page