Refer to Another Cell in Spreadsheet

Recently, I take Management and Financial course so I have to familiarized using spreadsheet application. One of them is Open Office Calc (now known as Libre Calc). A good report is when we can use as many sheet in one file so we can divided the calculation not in just single sheet.

But it can be a trouble if we have to always cut and paste it in always sheet if we need some data. A mistake make us to edit all copied data. But actually we can just give reference to other sheet or even to other file.

You just type the formula:

=SheetName.IndexCell

 to make reference in other sheet but in same file or for make reference or you can refer to a cell in other file by just typing this formula:

='NameFile'#SheetName.IndexCell

so it can automatically refer to a cell that you want. By change the master cell one then you just automatically update all cell that refer to master cell.

But actually there is more simple way to make a refer to another cell, and I think it can work to other spreadsheet by just typing to destination cell '=' and go to a cell you want to refer. After then just simply type enter as you refer to another cell in same sheet. Taaraa, automatically it write down the formula.

Hope it can help you.