When you have an enormous spreadsheet, you don't always want to print the whole thing every time. You want to print just a chunk. Also, when you have an enormous spreadsheet, you don't want to have to re-specify, every single time, exactly which range you want to print.
So you define named ranges. One called Just Totals, maybe, one called January through March--whatever. Whatever the logical subchunks are that you want to print.
How do you easily A) define those ranges with a meaningful name and B) specify which ONE of those you want to print?
Here's how.
How to name a range
Select the range.
Choose Insert > Names > Define.
Name the range.
Click Add.
Click OK.
Now it shows up in this list. Any additional ranges you define will also show up here.
How to choose to print a range
So you're going along, minding your own business, somewhere else in the spreadsheet, and you decide you want to print a range.
Select the range name from the list.
The range is automatically selected.
Choose File > Print.
Select the Selected Cells item. Click Print. You'll only get the selected cells, aka only the ones in that named range.
Helpful info, tyhank you. Have been working with spreadsheets for years and didn't know this.
-PL
Posted by: Paul leRoy | October 01, 2009 at 06:17 AM
Hello
My name is Klaibson and I'm writing from Brazil.
I have a blog here in Brazil that addresses the issue BrOffice / OpenOffice, the www.brofficeparaleigos.blogspot.com
I am writing to you to propose a partnership, or an exchange of links, I disclosing your blog on my list and you disclosing your blog, que tal?
If you want to clarify any questions or to sign the partnership, please contact us.
Good weekend.
Posted by: Klaibson | October 02, 2009 at 08:52 PM
Is it possible to define a range of non-continuous cells? I'm trying with OO.org 3.1 and the method you are describing doesn¡t work for this type of ranges=
Posted by: fusero | October 06, 2009 at 02:23 AM
Is it possible to define a range of non-continuous cells? I'm trying with OO.org 3.1 and the method you are describing doesn't work for this type of ranges.
Posted by: fusero | October 06, 2009 at 02:24 AM
Not that I know of, fusero. It would be two ranges, or else you'd need to hide the intermediate cells first.
Posted by: Solveig | October 07, 2009 at 12:44 PM