[Solved] Copy contents of one cell into another

Discuss the spreadsheet application

[Solved] Copy contents of one cell into another

Postby tadd5181 » Thu Apr 30, 2020 7:35 pm

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]
openOffice 3.1
tadd5181
 
Posts: 17
Joined: Thu Jan 10, 2013 6:40 am

Re: copy contents of one cell into another

Postby FJCC » Thu Apr 30, 2020 8:28 pm

If the first cell is A1, then the formula
Code: Select all   Expand viewCollapse view
=A1

in another cell will duplicate A1. Does that work for you?
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7749
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: copy contents of one cell into another

Postby RusselB » Thu Apr 30, 2020 8:30 pm

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
Code: Select all   Expand viewCollapse view
=A1

Change as appropriate for your specific situation.
I'm also going to recommend that you read Ten Concepts that every Calc user should know
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
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.
User avatar
RusselB
Moderator
 
Posts: 6110
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests