Gravity - Creating Named Ranges and Printable Areas

To include spreadsheets in your report, you will have to create Printable Areas for each spreadsheet. This allows for your spreadsheets to be formatted correctly and display data in a transparent, accurate, and simple way.  

1. Select a spreadsheet file that you will include in your report.

2. Once in your spreadsheet, select the range of cells you want printed in your report.

3. When finished, click "Data"

4. Click "Named ranges".

5. Name the range and when completed, click "Done".

6. Once we have created a named range, click on the three dots beside spreadsheet.

7. Then click "Properties"

8. Click on "Areas".

9. In the Areas tab, click on the arrow on the right side of the box.

10. Select the named ranged you created.

11. Once you have added the range you want to show in your report, you can edit various formatting settings. As well, you can toggle "Suppress Zeros" to remove any row that total zero from the printable area.

12. Once completed, click "Save".