[Solved] Copy contents of one cell into another
[Solved] Copy contents of one cell into another
I want the contents of one cell to show up in a second cell, so that when the first cell's content changes, the second cell's contents also changes. How do I do that?
Last edited by MrProgrammer on Fri May 08, 2020 7:06 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
openOffice 3.1
Re: copy contents of one cell into another
If the first cell is A1, then the formula
in another cell will duplicate A1. Does that work for you?
Code: Select all
=A1
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: copy contents of one cell into another
If the address of the first cell is A1 and you want the same display to show in B1, then enter the following formula into B1
Change as appropriate for your specific situation.
I'm also going to recommend that you read Ten Concepts that every Calc user should know
Code: Select all
=A1
I'm also going to recommend that you read Ten Concepts that every Calc user should know
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.