• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Working with Calc Data > Reference Data Outside This Sheet

54. Reference Data Outside This Sheet

If all your data resided in the current sheet, referencing other cells would be simple. You'd only need to know the other cell's address, such as D4. What if the cell is in another sheet inside the current spreadsheet? If Sheet1 needs to reference cell G6 in a sheet named Sheet3, you cannot use the simple G6 reference.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint