Ask Your Question

How do i export only certain ranges?

asked 2015-06-30 10:59:42 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Version: Component : Spreadsheet OS: Windows 7 (32-bit) Language: English

I have 4 sheets in my workbook, 2 of them are hidden. I wish to export / print only certain ranges from Sheet1.

I have selected the print ranges from Format > Print Ranges.

However, when I export to pdf, both Sheet 1 and Sheet 2 are exported. How do I export only the selected print ranges?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-06-30 11:33:13 +0200

pierre-yves samyn gravatar image


  1. Select the sheets you do not want to export
  2. Format Print Ranges Edit, select - none - in the Print Range listbox
edit flag offensive delete link more


Cool. Worked like a charm. Many thanks monsieur.

random32 gravatar imagerandom32 ( 2015-06-30 11:58:54 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-06-30 10:59:42 +0200

Seen: 367 times

Last updated: Jun 30 '15