How do I add a named range to an embedded sheet?

You can set a named range in a sheet prior to embedding it in Zeck. Setting a named range will ensure only the data in that range will be embedded into Zeck, rather than the entire tab.

In Excel:

  1. Select the range you want to name, including the row or column labels.
  2. Click Formulas, then choose Create from Selection.
  3. In the Create Names from Selection dialog box, select the checkbox(es) depending on the location of your row/column header. If you have only a header row at the top of the table, then just select Top row.
  4. Click OK.

In Google Sheets:

  1. Select the cells you want to name.
  2. Click Data, then Named ranges. A menu will open on the right.
  3. Type the range name you want.
  4. To change the range, click Spreadsheet Grid.
  5. Select a range in the spreadsheet or type the new range into the text box, then click Ok.
  6. Click Done.

When you select the source file for the sheet that you want to embed into Zeck, the named range(s) that you set will show up in the Named Range tab during the integration process.