How to Copy an Open Office Calc Sheet With All Formatting

OpenOffice Calc allows you to create, edit and manage spreadsheets electronically.

OpenOffice is a free, open-source application suite similar in layout and function to Microsoft Office. Calc is an application in the OpenOffice suite which allows you to create and manage spreadsheets. Learn how to copy an entire spreadsheet in Calc using these simple steps.

Instructions

1. Right click on the tab of the sheet that you wish to copy, and select "Move/Copy Sheets." The tabs are located along the bottom of the window.

2. Select the document you wish to copy the sheet into in the "To Document" drop-down menu. If you wish to copy the sheet to a different document, you must have the second document open.

3. Select where you would like the copied sheet to be placed in the "Insert Before" box. For example, if you select "Sheet 1," the copied sheet will appear before the current Sheet 1.

4. Check the "Copy" check box in the bottom left-hand corner of the "Move/Copy Sheet" dialog box.

5. Click "OK."

References

• Tutorials for OpenOffice: Sheets, Cells, And Data