Microsoft Office Tutorials and References
In Depth Information
Printing a Selection
Figure 10–5. There are the scores, but not where we want them.
So what’s going on? Really, two things:
When you instruct Excel to print a worksheet, it searches by default for
data by proceeding from the beginning of the sheet (i.e., the A
column), and will include all the blank areas it finds en route to the
data until it actually finds the data. It’ll thus print this worksheet
starting at column A up to and including the area containing the data,
starting in the J column.
The Print Active Sheets option will also print everything on the sheet, no
matter where that data is located.
For sake of the illustration, this means that if you had devised a worksheet whose data
starts in the X column, Excel would by default print columns A through W—all of these
blank—before reaching the actual data to print, meaning you’d end up with a collection
of empty printed pages before the page you wanted to print rolled out. It also means
that if you have a small range in A7:B19 that you want to print, and you also happen to
have squirreled away a bit of data in cell ZA241, Excel will by default print all the blank
columns between B and ZA too, until it finally stops at ZA241.
But all that happens by default, when you simply click the Print button without giving any
additional thought to what you wanted to see on paper, and leave the Print Active Sheets
option selected. And that default makes sense if you’ve started your data entry in the A
column and have a confined range of data to print, as is often the case.
But it doesn’t make sense in our case, where we’d end up with a two-page printout, with
the student names on one page and their grades on another.
Needless to say, there’s a way to deal with our little problem—by selecting precisely the
range you do want to print and then telling Excel to print only that area. You do that by