Documentation/How Tos/Printing Selected Print Ranges Using Names

When you have an enormous spreadsheet, you do not always want to print the whole thing every time. You want to print just a chunk. Also, when you have an enormous spreadsheet, you do not 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

1. Select the range.
File:Doc HowTo selected range.png
Range selected for naming
2. Choose Insert > Names > Define.
3. Name the range (for example "nameonly".)
4. Click Add and click OK.
Now it shows up in this list. Any additional ranges you define will also show up here.
File:Doc HowTo listbox names.png
Listbox with defined range names

How to Print a Named Range

1. Select the range name from the list. The range is automatically selected.
2. Choose File > Print.
3. Select the Selected Cells item. Click OK. You will only get the selected cells, that is only the ones in that named range.

This How To comes from Solveig Haugland's Blog

Content on this page is licensed under the Public Documentation License (PDL).