I have a calc file with 7 sheets of data. I want to export to pdf only 2 of the sheets. How do I select the sheets I want and not print/export to PDF the other sheets.
-
Left-clickthe first exported sheet’s tab (with the sheet name; at the bottom); -
Ctrl+Left-clickthe other tab(s) you want to export; -
File→Export as PDF...; make sureSelection/Selected sheet(s)is selected underRangeonGeneraltab.
See Selecting Multiple Sheets in help.
Thank you Mike Kaganski. It sure seems obvious and I must have tried every variant of combinations except that one - feeling a bit stupid 