Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split Print Area: How to make it print to one page
On an .xlsx spreadsheet made with Excel 2010, I want to print a split
area: Row 1, columns B to I + Rows 96 to 108, columns B to I. Using the control key, I'm able to highlight those two areas, but it keeps printing the two area on separate pages. Is there a way to print these two areas on a single page? (Printing in landscape, there is no issue of being too large a print area for one page.) Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split Print Area: How to make it print to one page
Excel does not support non-contiguous print areas on single pages.
Hide rows 2 through 95. Alternative............set print area rows 96:108 with row 1 as row to repeat at top. Gord Dibben Microsoft Excel MVP On Wed, 28 Sep 2011 19:11:57 -0500, Kirk Bubul wrote: On an .xlsx spreadsheet made with Excel 2010, I want to print a split area: Row 1, columns B to I + Rows 96 to 108, columns B to I. Using the control key, I'm able to highlight those two areas, but it keeps printing the two area on separate pages. Is there a way to print these two areas on a single page? (Printing in landscape, there is no issue of being too large a print area for one page.) Thanks in advance for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split Print Area: How to make it print to one page
Thanks, Gord, I tried your alternative method and that works great
for me. I especially like the fact that the setting is sticky from print occasion to print occasion, since one of the blocks always the top row(s) that serve as headers. On Wed, 28 Sep 2011 17:33:55 -0700, Gord wrote: Excel does not support non-contiguous print areas on single pages. Hide rows 2 through 95. Alternative............set print area rows 96:108 with row 1 as row to repeat at top. Gord Dibben Microsoft Excel MVP On Wed, 28 Sep 2011 19:11:57 -0500, Kirk Bubul wrote: On an .xlsx spreadsheet made with Excel 2010, I want to print a split area: Row 1, columns B to I + Rows 96 to 108, columns B to I. Using the control key, I'm able to highlight those two areas, but it keeps printing the two area on separate pages. Is there a way to print these two areas on a single page? (Printing in landscape, there is no issue of being too large a print area for one page.) Thanks in advance for any help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split Print Area: How to make it print to one page
Good to hear.
Gord On Thu, 29 Sep 2011 04:56:52 -0500, Kirk Bubul wrote: Thanks, Gord, I tried your alternative method and that works great for me. I especially like the fact that the setting is sticky from print occasion to print occasion, since one of the blocks always the top row(s) that serve as headers. On Wed, 28 Sep 2011 17:33:55 -0700, Gord wrote: Excel does not support non-contiguous print areas on single pages. Hide rows 2 through 95. Alternative............set print area rows 96:108 with row 1 as row to repeat at top. Gord Dibben Microsoft Excel MVP On Wed, 28 Sep 2011 19:11:57 -0500, Kirk Bubul wrote: On an .xlsx spreadsheet made with Excel 2010, I want to print a split area: Row 1, columns B to I + Rows 96 to 108, columns B to I. Using the control key, I'm able to highlight those two areas, but it keeps printing the two area on separate pages. Is there a way to print these two areas on a single page? (Printing in landscape, there is no issue of being too large a print area for one page.) Thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split print area in excel - One Page Print | Excel Worksheet Functions | |||
Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
In Excel, how do I make the freezed pane area, print on each page. | Excel Discussion (Misc queries) |