Frequently asked questions - Writer

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

• FAQ Home
• General
• Writer
• Calc
• Impress
• Draw
• Math
• Base

How to copy and paste a formula without the result

We want to copy a formula in a table to paste it to another cell or another table. For this, you have to select the cell and not its content before copying it.

In the example below, we want to copy and paste the formula in Table1:A3 to Table2:B3:

Select A3

Process

1. Select the cell Table1:A3.
   • The easiest way is to click in the cell, then drag the mouse (using Ctrl + A would select the content and not the cell).
   • Using the keyboard, place the cursor in the cell and press ⇧ Shift + → Then ⇧ Shift + ←.
2. Copy
3. Click Table2:B3
4. Paste

The formula is pasted and the references adapted.

If you want to retrieve the formula but not to adapt the references, you can:

1. Press F2 in the cell that contains the formula
2. Select the formula in the dislayed input area
3. Copy
4. Press Esc to leave the input area
5. Select the target cell
6. Press F2 to display the input area and paste.