Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print noncontiguous ranges?
Is there a way to set the print area to noncontinguous ranges in such
a way that they print contiguously on the same page? For example, consider the situation where I want A1:C10, H1:M10 and P1:R10 to print one page as if the 12 columns were contiguous. When I select 3 noncontiguous ranges, select File - Print Area - Set Print Area, then click on Print Preview, each range appears on its own page. I have not been successful at moving or removing the page boundaries so that the ranges are on one page. Since the specific situation does involve skipping columns, I can work around this by hiding the columns that should not print. But before I go to that trouble, I want to know if I am overlooking a better solution. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print noncontiguous ranges?
Hiding the columns seems the most straightforward to me.
Another option if you have to do it lots of times and find hiding/showing the columns too much of a pain: Add a new sheet -- it'll be the one that's printed. Select the first set of cells to print edit|Copy select A1 of Sheet2 (the new sheet) Shift-edit|Paste picture link Then off to the second set of cells edit|copy select the cell under (or adjacent to) the picture of the first table. shift-edit|Paste picture link And once more for the next set of cells.... By pasting the pictures as links, any updates you make to the table will show up in the picture. " wrote: Is there a way to set the print area to noncontinguous ranges in such a way that they print contiguously on the same page? For example, consider the situation where I want A1:C10, H1:M10 and P1:R10 to print one page as if the 12 columns were contiguous. When I select 3 noncontiguous ranges, select File - Print Area - Set Print Area, then click on Print Preview, each range appears on its own page. I have not been successful at moving or removing the page boundaries so that the ranges are on one page. Since the specific situation does involve skipping columns, I can work around this by hiding the columns that should not print. But before I go to that trouble, I want to know if I am overlooking a better solution. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Area ranges print on separate pages? | Excel Discussion (Misc queries) | |||
Using Multiple, Noncontiguous Ranges in COUNTIF? | Excel Discussion (Misc queries) | |||
Print titles: can noncontiguous columns at left be printed & how? | Excel Worksheet Functions | |||
Noncontiguous ranges printed on one page???? | Excel Discussion (Misc queries) | |||
How can I print noncontiguous rows on the same page? | Excel Discussion (Misc queries) |