Copy Reference

Tool

Built-in

The copy reference tool gives another method to reference cells or values in a formula. It can also be used to create hyperlinks to top level frames.

Typically, you click on a value while a formula is open to reference that value. With copy reference, you can copy the reference name of a value before ever opening a formula, then paste that reference into the formula you choose.

Use copy reference for a value name:
  1. Right click on a cell, dynamic expression, or drawing label.
  2. Select Copy Reference.
  3. Open a formula.
  4. Paste the reference in (ctrl+v or Right Click>Paste).
Use copy reference for a hyperlink address:
  1. Right click on a top level frame in the left of the screen.
  2. Select Copy Reference.
  3. Insert a hyperlink.
  4. Paste the reference in (ctrl+v or Right Click>Paste).
Notes:
  • When you paste a copied reference in Blockpad, the reference is fitted to the destination. For example, if you copy cell B5 in Sheet1, it will paste as B5 in Sheet1, but as Sheet1.B5 if pasted into Sheet2.
  • Copy Reference also works for table ranges. You can select a range in a table or spreadsheet, click Copy Reference, and then paste the range into a formula.
  • If you paste a copied reference into another file, Blockpad will automatically create an external reference to link to the copied reference.
See also: