Moving a sheet in 1-2-3 97




I use 1-2-3 97. Am I crazy, or is there no way to move a sheet to a different position within a file?
- Tina Guarlski


I can't judge your sanity, but you've uncovered a serious defect in 1-2-3 97. Incredibly, the program has no way to change the order of worksheets in a file. Instead, you must do the following:
1. Select Create--Sheet to insert a new worksheet at the desired position.
2. Activate the worksheet you want to move by clicking its sheet tab.
3. Select the entire worksheet by clicking its sheet letter, which is in the upper left corner of the worksheet where the row numbers and column letters intersect.
4. Choose Edit--Cut.
5. Activate the empty sheet that you inserted in Step 1, and select cell A1.
6. Choose Edit--Paste.
7. Delete the old copy of the worksheet.
Before using this technique, be aware of its limitations. First, row heights and column widths won't get copied. And if your sheet has charts, don't bother with this method -- the charts get copied along with the cell contents, but the charts will continue to refer to the original sheet. Finally, any formulas referring to other sheets won't be copied correctly unless they contain absolute sheet references.
The bottom line? Use this procedure with caution. We can only hope Lotus will correct the problem in a 1-2-3 update.
- John Walkenbach


Category: Spreadsheet
Issue: Jan 1998
Pages: 167

These Web pages are produced by Australian PC World © 1997 IDG Communications