Last Updated on 2022-01-08 by Jarret Hooper
What is Sections to Sheets?
Sections to Sheets is a free Google Sheets Add-on that separates rows by column sections and puts them in individual pages or sheets in a spreadsheet in preparation for export and printing.
You can find Sections to Sheets at the Google Workspace Marketplace.
Let’s say you want to print out a list of expenditures by department and you want each department to start on a new page. You’ll also want to keep the same header for each page.
You might want to export a list of grades by class number. You sort the grades by class and then export the list with each class starting on a new page with a header and footer.
Sections to Sheets can help you achieve this quickly by creating a new Google Spreadsheet and separating each selection and putting it into a new Sheet(tab) with or without headers and footer. This will enable you to quickly export or print your sheets.
Spreadsheet programs generally don’t do a good job of automatically separating data by a column and printing or exporting it out. Usually, you are left with setting a header and footer and then dragging your cursor over each set data you want to have on a separate page.
This is fine if you don’t have much data, but what happens if say, you want separate your sales data for each city in your state and put that data on separate pages with a neat header and footer. Then it becomes a massive chore prone to error.
But not with Sections to Sheet.
What can Sections to Sheets do?
Sections to Sheets Can:
- Sets a column for you to separate your data by.
- Separates your data by column sections.
- Prepares your data in separate sheets(tabs) for printing or export.
- Automatically detect the width of your columns.
- Allow you to reset the width of your columns.
- Set a headed and/or footer or none at all.
- Retains the original formatting of the original data.
- Retains the column width dimensions of your original data.
What can’t Sections to Sheets do?
Google does not allow it’s add-on programs to access printing on your computer. This is to ensure security on your computer. What Sections to Sheets will do it set up a spreadsheet ready for you to export or print.
Sections to Sheets also does not directly sort the column you want to separate by. This is a simple step that you, the user, will already have done before running the add-on.
How to use Sections to Sheets
Sort your sheet by the column you want to separate by.
(Note you will need to select the advanced range sorting options from the sort range menu)
To open, go to Extensions> Sections to Sheets and click Sections to Sheets.
(note Extensions was previously Add-ons).
A sidebar will appear for you to make your selections.
Select the column you have sorted. The one you wish to use to separate your data by.
Select your headers and or footers if you have them.
Note: You will need to put your header at the top of your data and your footer at the bottom.
Select the width of the columns you want to be displayed. Sections to Sheets automatically calculates the width of your data range in columns and will set it to standard. Sometimes you may wish to only include a selection of columns. You can do this by changing the width, or the starting column and the ending column.
When you are happy with your selection, click “Submit”.
After you have clicked submit, Sections to Sheets will:
- create a new file in the same directory as your current spreadsheet. The new file will be named the same as your current file with “by selection” at the end of it.
- create sheet tabs in that file titled by the column identifier.
- add the data for each column identifier in and add a header and footer if necessary.
Exporting or printing your data
By now all your data will be prepared so that each section sheet will start printing or will be displayed on a separate page.
EXPORT AS PDF:
To export as a PDF got to File> Download as > PFD document (.pdf)
Ensure you have set up the layout you want. Then under the “Export” label, click, “Workbook” to select all sheet tabs. and then click “EXPORT”.
Done. You have a neatly separated PDF document by sections.
To print click the print icon on your quick access bar or (ctrl+p).
After you have set up the layout you want. Select “Workbook” from the “Print” drop-down to select all the sheet tabs. Then select “NEXT”. The Print screen will appear and you can then go ahead and select “Print”.
Online privacy is incredibly important to me. So much so that I have a donate button to the Electronic Frontier Foundation (EFF) on the bottom of my sidebar.
Sections to Sheets does not record your personal information or data.