Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to eyeball08,Wondergirly,bofh,johnstevens77,Bhoddhisatva, for Donating to support the site

Spreadsheet saving paper

Seek assistance with all types of tech. - computer, phone, TV, heating controls etc.
cinelli
Lemon Slice
Posts: 553
Joined: November 9th, 2016, 11:33 am
Has thanked: 234 times
Been thanked: 161 times

Spreadsheet saving paper

#418370

Postby cinelli » June 9th, 2021, 12:44 pm

I suspect the answer to this question is no ...

I have a spreadsheet with several tabs, three of which contain little information. So when I come to print them, each takes up only about a quarter of a page. Is it possible to print all three tabs on the same sheet of paper? Or could I save the output from the three to PFD then combine these into one page? I am using Libre Office but could work in Excel.

Thanks.

Cinelli

ReformedCharacter
Lemon Quarter
Posts: 3133
Joined: November 4th, 2016, 11:12 am
Has thanked: 3629 times
Been thanked: 1518 times

Re: Spreadsheet saving paper

#418374

Postby ReformedCharacter » June 9th, 2021, 12:52 pm

cinelli wrote:I suspect the answer to this question is no ...

I have a spreadsheet with several tabs, three of which contain little information. So when I come to print them, each takes up only about a quarter of a page. Is it possible to print all three tabs on the same sheet of paper? Or could I save the output from the three to PFD then combine these into one page? I am using Libre Office but could work in Excel.

Thanks.

Cinelli

Would it be possible to create another 'summary' sheet with the data from the others and just print that?

RC

servodude
Lemon Half
Posts: 8368
Joined: November 8th, 2016, 5:56 am
Has thanked: 4471 times
Been thanked: 3601 times

Re: Spreadsheet saving paper

#418377

Postby servodude » June 9th, 2021, 1:04 pm

ReformedCharacter wrote:
cinelli wrote:I suspect the answer to this question is no ...

I have a spreadsheet with several tabs, three of which contain little information. So when I come to print them, each takes up only about a quarter of a page. Is it possible to print all three tabs on the same sheet of paper? Or could I save the output from the three to PFD then combine these into one page? I am using Libre Office but could work in Excel.

Thanks.

Cinelli

Would it be possible to create another 'summary' sheet with the data from the others and just print that?

RC


That I think is the best solution

You can change the print options to put multiple pages on to the same sheet of paper
- but not in a way that gives you flexiblity of content depending on what's on each sheet
- so best to create a summary that links across the sheets

-sd

Nocton
Lemon Slice
Posts: 491
Joined: November 6th, 2016, 11:25 am
Has thanked: 134 times
Been thanked: 138 times

Re: Spreadsheet saving paper

#418634

Postby Nocton » June 10th, 2021, 2:42 pm

Open up a document (writer or Word)
Open up the Snipping tool.
Then snip what you want to print from each page and paste into document.
Move and size snips to fit all on single page and then print.

cinelli
Lemon Slice
Posts: 553
Joined: November 9th, 2016, 11:33 am
Has thanked: 234 times
Been thanked: 161 times

Re: Spreadsheet saving paper

#418715

Postby cinelli » June 10th, 2021, 8:35 pm

Nocton wrote:Open up a document (writer or Word)
Open up the Snipping tool.
Then snip what you want to print from each page and paste into document.
Move and size snips to fit all on single page and then print.


That's a good idea. Thanks. The snipping tool is known as "shutter" in linux.

Cinelli


Return to “Technology - Computers, TV, Phones etc.”

Who is online

Users browsing this forum: No registered users and 30 guests