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-click
the first exported sheet’s tab (with the sheet name; at the bottom); -
Ctrl
+Left-click
the other tab(s) you want to export; -
File
→Export as PDF...
; make sureSelection/Selected sheet(s)
is selected underRange
onGeneral
tab.
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