OpenOffice.org videos and documentation
Plan-B for OpenOffice.org, learning office productivity software with videos


Tech Support for OpenOffice.org
Applications
Go to Open Office Writer Index
Go to Open Office Impress Index
Go to Open Office Math Index
Go to Open Office Draw Index
Go to Open Office Calc Index
Go to Open Office Base Index
Go to Open Office Online Help Index

Paste cells using the toolbar - OpenOffice.org Calc

How-To: Paste cells using the toolbar - OpenOffice.org Calc
  1. When pasting cells using the toolbar, you must have something copied or cut already stored in the clipboard.
  2. In this example, we have cut two cells here one of which had a formula within it.
  3. We are going to paste the cells on to another sheet. To do this click on the sheet tab where we want to paste the cells.
  4. Once on the next sheet, click on the location where you want to paste the cells.
  5. Next, go to the toolbar and click here on the "Paste Button," it should have a clipboard and paper icon.
  6. Great! We have pasted the cells here.
  7. Take note that cells can carry all of its content including formulas when cut/copied and then pasted. So if you click on a cell...
  8. ...you will notice that the formula is preserved. Notice as well that the cell references in the formula have updated to preserve the function and its result.
  9. Congratulations! You have learned how to paste cells using the toolbar.
powered by Plan-B screencast technology

Paste cells using the toolbar

This screencast demonstrates how to cells using the . You learn:

  • About the .
  • How to or cells.
  • How to find the paste button.
  • How to paste cells.

Advanced topics

For advanced functionality with similar results see:

OpenOffice.org™ is a trademark of OpenOffice.org.

Further questions?

*
*
*
* required fields
Get OpenOffice.org - Free!