Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing On One Page Using Print-Area
I can send the excel sheet but it looks like:
a b c q r s hea bea cea de re qq One active worksheet where I have used print area and selected columns a,b,c,q,r, a s to print. Unable to have that print out on one page, even though there is more than enough room to fit. Columns a,b,c print on one page. Columns q,r,s on the second page. I would like all six columns to print on one page. There is more than enough room. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing On One Page Using Print-Area
Hide columns D through P.
"whynot" wrote in message ... I can send the excel sheet but it looks like: a b c q r s hea bea cea de re qq One active worksheet where I have used print area and selected columns a,b,c,q,r, a s to print. Unable to have that print out on one page, even though there is more than enough room to fit. Columns a,b,c print on one page. Columns q,r,s on the second page. I would like all six columns to print on one page. There is more than enough room. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing On One Page Using Print-Area
Thanks. I can if no other options. I freeze the first three columns, and then
display different columns on the right hand pane depending on the month. Not sure what 'triggers' excel to believe that no further room on first page. thanks. "Wondering" wrote: Hide columns D through P. "whynot" wrote in message ... I can send the excel sheet but it looks like: a b c q r s hea bea cea de re qq One active worksheet where I have used print area and selected columns a,b,c,q,r, a s to print. Unable to have that print out on one page, even though there is more than enough room to fit. Columns a,b,c print on one page. Columns q,r,s on the second page. I would like all six columns to print on one page. There is more than enough room. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing On One Page Using Print-Area
With A, B and C frozen, you cannot just scroll over and show Q, R and S and
expect Excel to print just those 6 columns as one print range. The intervening columns are not hidden, just scrolled underneath A, B and C You must actually hide them as Wondering suggested. Gord Dibben MS Excel MVP On Mon, 1 Oct 2007 16:59:00 -0700, whynot wrote: Thanks. I can if no other options. I freeze the first three columns, and then display different columns on the right hand pane depending on the month. Not sure what 'triggers' excel to believe that no further room on first page. thanks. "Wondering" wrote: Hide columns D through P. "whynot" wrote in message ... I can send the excel sheet but it looks like: a b c q r s hea bea cea de re qq One active worksheet where I have used print area and selected columns a,b,c,q,r, a s to print. Unable to have that print out on one page, even though there is more than enough room to fit. Columns a,b,c print on one page. Columns q,r,s on the second page. I would like all six columns to print on one page. There is more than enough room. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing On One Page Using Print-Area
thanks, understand. not sure the frozen columns are the issue. used print
area to select items abc, qrs. it a problem i thought others woud encounter. a b c q r s Housing Total Owed Remaining Sept Owe Sept pay Date Paid A,b,c are headers, and q,r,s are monthly payments. After a bit all of the columns no longer fit, and you don't need to know what you paid four months ago. Was looking for a more elegant solution, but will go ahead and hide the columns. thanks for writing, "Gord Dibben" wrote: With A, B and C frozen, you cannot just scroll over and show Q, R and S and expect Excel to print just those 6 columns as one print range. The intervening columns are not hidden, just scrolled underneath A, B and C You must actually hide them as Wondering suggested. Gord Dibben MS Excel MVP On Mon, 1 Oct 2007 16:59:00 -0700, whynot wrote: Thanks. I can if no other options. I freeze the first three columns, and then display different columns on the right hand pane depending on the month. Not sure what 'triggers' excel to believe that no further room on first page. thanks. "Wondering" wrote: Hide columns D through P. "whynot" wrote in message ... I can send the excel sheet but it looks like: a b c q r s hea bea cea de re qq One active worksheet where I have used print area and selected columns a,b,c,q,r, a s to print. Unable to have that print out on one page, even though there is more than enough room to fit. Columns a,b,c print on one page. Columns q,r,s on the second page. I would like all six columns to print on one page. There is more than enough room. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing On One Page Using Print-Area
Excel will not accept non-contiguous print ranges on one sheet.
What I and others do for this type of operation is set up custom views. ViewCustom ViewAdd.........add a view with full sheet showing. Name it fullsheet. Hide the columns and rows you don't want printed and name this printabcqrs. Now you can switch views at will for viewing and printing. Add the Custom Views Icon to your toolbar for choosing. Gord On Mon, 1 Oct 2007 21:04:03 -0700, whynot wrote: thanks, understand. not sure the frozen columns are the issue. used print area to select items abc, qrs. it a problem i thought others woud encounter. a b c q r s Housing Total Owed Remaining Sept Owe Sept pay Date Paid A,b,c are headers, and q,r,s are monthly payments. After a bit all of the columns no longer fit, and you don't need to know what you paid four months ago. Was looking for a more elegant solution, but will go ahead and hide the columns. thanks for writing, "Gord Dibben" wrote: With A, B and C frozen, you cannot just scroll over and show Q, R and S and expect Excel to print just those 6 columns as one print range. The intervening columns are not hidden, just scrolled underneath A, B and C You must actually hide them as Wondering suggested. Gord Dibben MS Excel MVP On Mon, 1 Oct 2007 16:59:00 -0700, whynot wrote: Thanks. I can if no other options. I freeze the first three columns, and then display different columns on the right hand pane depending on the month. Not sure what 'triggers' excel to believe that no further room on first page. thanks. "Wondering" wrote: Hide columns D through P. "whynot" wrote in message ... I can send the excel sheet but it looks like: a b c q r s hea bea cea de re qq One active worksheet where I have used print area and selected columns a,b,c,q,r, a s to print. Unable to have that print out on one page, even though there is more than enough room to fit. Columns a,b,c print on one page. Columns q,r,s on the second page. I would like all six columns to print on one page. There is more than enough room. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing On One Page Using Print-Area
That worked. Thanks a lot!!.
"Gord Dibben" wrote: Excel will not accept non-contiguous print ranges on one sheet. What I and others do for this type of operation is set up custom views. ViewCustom ViewAdd.........add a view with full sheet showing. Name it fullsheet. Hide the columns and rows you don't want printed and name this printabcqrs. Now you can switch views at will for viewing and printing. Add the Custom Views Icon to your toolbar for choosing. Gord On Mon, 1 Oct 2007 21:04:03 -0700, whynot wrote: thanks, understand. not sure the frozen columns are the issue. used print area to select items abc, qrs. it a problem i thought others woud encounter. a b c q r s Housing Total Owed Remaining Sept Owe Sept pay Date Paid A,b,c are headers, and q,r,s are monthly payments. After a bit all of the columns no longer fit, and you don't need to know what you paid four months ago. Was looking for a more elegant solution, but will go ahead and hide the columns. thanks for writing, "Gord Dibben" wrote: With A, B and C frozen, you cannot just scroll over and show Q, R and S and expect Excel to print just those 6 columns as one print range. The intervening columns are not hidden, just scrolled underneath A, B and C You must actually hide them as Wondering suggested. Gord Dibben MS Excel MVP On Mon, 1 Oct 2007 16:59:00 -0700, whynot wrote: Thanks. I can if no other options. I freeze the first three columns, and then display different columns on the right hand pane depending on the month. Not sure what 'triggers' excel to believe that no further room on first page. thanks. "Wondering" wrote: Hide columns D through P. "whynot" wrote in message ... I can send the excel sheet but it looks like: a b c q r s hea bea cea de re qq One active worksheet where I have used print area and selected columns a,b,c,q,r, a s to print. Unable to have that print out on one page, even though there is more than enough room to fit. Columns a,b,c print on one page. Columns q,r,s on the second page. I would like all six columns to print on one page. There is more than enough room. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Area Printing | New Users to Excel | |||
Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
Print Area. 1st page Landscape 2nd page Portrait?? | Excel Worksheet Functions | |||
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) |