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 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+←.
- Click Table2:B3
The formula is pasted and the references adapted.
If you want to retrieve the formula but not to adapt the references, you can:
- Press F2 in the cell that contains the formula
- Select the formula in the dislayed input area
- Press Esc to leave the input area
- Select the target cell
- Press F2 to display the input area and paste.