You can embed a link to print a Google Sheet and supply multiple parameters that control the print settings. Create a named range "Print" in the sheet (or substitute any range in A1 notation for `Print`. Get the `<spreadsheet_id>` and `<sheet_id>` from the URL (don't include `<>`). ``` https://docs.google.com/spreadsheets/d/<spreadsheet_id>/export? exportFormat=pdf& gid=<sheet_id>& range=Print& size=letter& portrait=true& fitw=true& gridlines=false& printnotes=false& printtitle=true& pagenum=RIGHT ``` In the cell you want to use as the "Print" button, type "Print to PDF" or similar and add the above link ( `Ctrl + K` ).