Calc- print specific pages...but what are the page numbers?

users
#1

On a single LO Calc spreadsheet file that I have there are many pages on
different sheets that need to be printed but I'd like to exclude
specific pages. That's fine and well but I have no idea what the sheet
page numbers are.

What should I do?

Thanks,

Craig

#2

Hi Craig,

In version 5, you can select multiple sheets with the shift key pressed.

Then, in the print dialog you can select to print only the selected sheets.

Don't know about previous versions, but I guess it will be similar.

#3

On a single LO Calc spreadsheet file that I have there are many pages on different sheets that need to be printed but I'd like to exclude specific pages. That's fine and well but I have no idea what the sheet page numbers are. What should I do?

It's difficult to see how you can know that some *pages* are not required unless you have a clear idea of the page structure. In this case, you would know what pages these were.

There are two ways to think of this, I think:

o Set print ranges. Go to Format | Print Ranges > | Define and Format

Print Ranges > | Edit... and mark all the material that you need to

print. Note that any print range set anywhere in your spreadsheet will suppress any material not so marked, even on other sheets.

o First control the page structure of your printed document using breaks. Go to Insert | Manual Break > | Row Break and Insert | Manual Break > | Column Break to do this. Then go to View | Page Break Preview to display the relevant page numbers to print.

You may also find the scaling facilities helpful - at Format | Page... | Sheet | Scale | Scaling mode.

I trust this helps.

Brian Barker

#4

Hi :slight_smile:
Yes, I was wondering about just using print preview to find out the page
numbers and see how the whole thing looks. It's a bit simplistic but may
be as much as you need right now.
Regards from
Tom :slight_smile: