How can I export a multiselection in calc to PDF? (to include column headings)

I have a regular calc sheet where the first row is the headings for the column. How can I export a multiselection to PDF? That is, I want the headings and some rows of the table, but not everything inbetween. See example below where > denotes selection <:

> NAME        VALUE     <
  Lisa        hot dog
> Raggis      ice cream <

I think the best way would be to use filter to show the data table as you want it in the pdf.

Select the headers of the table, then select Data, Autofilter.

If its difficult to use filters on the existing table content to select the rows required, you could add a helper column to apply the filter. You could then hide this column to avoid export to the pdf.