If any unexpected shutdown occurs, this feature will recover your file. File Name Application Name Figure . Saved Spreadsheet . .
Closing a Worksheet After saving the worksheet; it remains open. So, you can continue to working with it. When the work is finished, you should save using File → Save (or) Click “Save” icon (or) Ctrl + S and then to close the worksheet using File → Close command (or) Press Ctr l + W . .
. Opening an existing worksheet . . .
Using Open dialog box To reopen an existing worksheet, the File → Open command (or) “Open” icon (or) Ctrl + O can be used. An Open dialog box appears as shown in Figure . that is similar to “Save As” dialog box. The name of the file to be opened can be chosen from the list or folder in which worksheet has been saved.
Default location Available Files and Folders Read only Option Figure . Open Dialog box . . .
Using Recent documents OpenOffice keeps a list of recently opened files. File → Recent Documents option can be used to open an existing worksheet from the list as shown in Figure . . List of recently used files Figure .
List of Recent Documents . Copy, Cut and Paste . . Copy and Paste Data (Coping Data) Select the cell or cells you want to copy Select Edit → Copy or Click “ Copy ” icon from the standard toolbar or Press Ctrl + C.
Move the cell pointer to the cell in which you want to paste. Select Edit → Paste or Click “ Paste ” icon or Press Ctrl + V . . Cut and Paste Data (Moving Data) Select the cell or cells you want to cut Select Edit → Cut or Click “ Cut” icon from the standard toolbar or Press Ctrl + X Move the cell pointer to the cell in which you want to paste.
Select Edit → Paste or Click “Paste ” icon or Press Ctrl + V. . . Copy and Paste Formula The process of Copy and Paste data is used for