Formatting your spreadsheets automatically
When looking at the Spreadsheet Service documentation (https://developers.google.com/apps-script/reference/spreadsheet/) and particularly the
Sheet class (https://developers.google.com/apps-script/reference/spreadsheet/sheet) and the
Range class (https://developers.google.com/apps-script/reference/spreadsheet/range), we can see that there are a lot of available methods that allow us to modify the sheet format; in other words, we can create functions that will set up a custom page layout with a single click.
This could be very helpful when creating shared documents with people who have to fill in some data and have a bad habit of making a mess of the page layout.
For example, they might have to change the ...