Spreadsheets: how to reference a cell on a different sheet in Excel and in LibreOffice Calc

Posted on Posted in business, computer skills, Excel, LibreOffice Calc, spreadsheets No Comments

Tutoring spreadsheet usage, cell references are important.

Let’s imagine you want a1 in the first sheet of a workbook to have the value of b1 in sheet 2.

Here’s how you can do so with text:

  • Excel: type, in a1 of the first sheet, =sheet2!b1
  • LibreOffice Calc: type, in a1 of the first sheet, =sheet2.b1

HTH:)

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Leave a Reply