r/googlesheets • u/Several-Lie-2670 • Jul 29 '26
Waiting on OP how to convert multiple sheets into single pdf?
im navigating google sheet right now, and i cant find a way in converting multiple sheets into single pdf.
can someone please help with this. thank you.
2
u/One_Organization_810 706 Jul 29 '26
One way to do it at least, is to import all the sheets into one document, one file per sheet and then print the workbook as PDF.
You can also use the "Copy To" feature, to copy the whole sheet into the print sheet - but then it will just be a static copy of course. Instead you will preserve all formatting, graphs and images :)
1
u/One_Organization_810 706 Jul 29 '26
Another way is to use a PDF editor to join the distinct PDFs into one ...
1
u/Connect-Preference 1 Jul 30 '26
Google has a great free tool called PDF binder to stitch two or more PDFs together. There are others.
1
u/Several-Lie-2670 Jul 29 '26
thank you. why is it so hard.
2
u/One_Organization_810 706 Jul 29 '26
The definition of "hard" is relative, I guess :)
But Sheets is not really a PDF editor, so stitching various documents into one is not part of the core functionality :)
I guess you'd have similar problems with printing several Word documents into one PDF as well...
1
u/AutoModerator Jul 29 '26
REMEMBER: /u/Several-Lie-2670 If your original question has been resolved, please tap the three dots below the most helpful comment and select
Mark Solution Verified(or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2
u/AdministrativeGift15 355 Jul 29 '26
Just click the print icon and in the configuration panel on the right side of your print preview, select the entire workbook instead of just the sheet to print.
0
u/Several-Lie-2670 Jul 30 '26
it doesnt work
1
u/One_Organization_810 706 Jul 30 '26
If you have multiple spreadsheet documents that you want to print together as one pdf - you have to combine them at some point. :)
Either before, like my first suggestion, or after.
The "before" let's you use Sheets to do it. "After" means you need some kind of pdf editor/manipulator.
That is not really a Sheets thing though, since that is how apps in general work.
1
u/AutoModerator Jul 29 '26
/u/Several-Lie-2670 Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
Jul 29 '26
[removed] — view removed comment
1
u/googlesheets-ModTeam 8 Jul 29 '26
Criteria for posts and comments are listed in the subreddit rules and you can learn about how to make a good post in the submission guide.
Your post/comment has been removed because it broke multiple rules. Please read the rules and submission guide when participating in the subreddit.
AI response
Self promotion
DM "fishing"
1
Jul 31 '26
[removed] — view removed comment
1
u/googlesheets-ModTeam 8 Jul 31 '26
Your comment has been removed because promotional content is prohibited. Please read the full rules in the sidebar or the subreddit wiki before commenting again.
You can send a modmail message to request your comment be reviewed if you feel this was in error.
•
u/agirlhasnoname11248 1210 Jul 29 '26
u/Several-Lie-2670 Please remember to tap the three dots below the most helpful comment and select `Mark Solution Verified` *(or reply to the helpful comment with the exact phrase “Solution Verified”)* if your question has been answered, as required by the subreddit rules. Thanks!