Apple M9057 User Manual - Page 164

7-18 AppleWorks 5 User's Manual Inserting and deleting cells, rows, and columns In the Help index,* see: E spreadsheets, arranging Important When you delete a cell, column, or row, you also delete its data. To insert or delete an entire row or column, click one or more headings to select rows or columns, and then on the Default button bar, click to insert cells or click to delete cells. You can also choose Insert Cells or Delete Cells from the Calculate menu. To insert or delete a few cells, make a selection before you choose Insert Cells or Delete Cells. In the dialog box, specify how you want existing cells to be shifted, and then click OK. Select the cells to delete The cells below are shifted up Changing the number of rows and columns A new spreadsheet contains 500 rows and 40 columns. A new spreadsheet frame contains 50 rows and 10 columns. In the Help index,* see: E Document command E frames, formatting E opening To Do this Change the number of rows and columns in a spreadsheet Choose Document from the Format menu, type numbers for Columns Across and Rows Down, and then click OK. Open a spreadsheet frame so that you can change the number of rows and columns in the spreadsheet Select the frame and choose Open Frame from the Window menu. When you open the frame, you see the spreadsheet in a new window. The open frame is linked to the original document. Any changes you make in the open frame are also made in the document. To close the spreadsheet frame, choose Close from the File menu. Resize a spreadsheet frame to display Select the frame and then drag a handle. more cells * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.