I am trying to put together a spreadsheet in OO with 3 sheets. There is one cell on all the sheets which needs to have exactly the same content (a date). i.e. whatever I put in sheet 1 should also appear on sheets 2 and 3
Anyone know how I do that?
Full Version: cells in openoffice having the same content
never mind - I figured it out
=(cell address)
Why couldn't I figure that out during the half hour I was trying before I posted...?
=(cell address)
Why couldn't I figure that out during the half hour I was trying before I posted...?
Click the Cell (eg. A1) in Sheet 2.
Enter '=Sheet1.A1' (without the quotation mark).
You can do the same for Sheet 3.
Enter '=Sheet1.A1' (without the quotation mark).
You can do the same for Sheet 3.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.