| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print only unhidden rows
How do I print only the unhidden rows on a worksheet?
I've tried custom views and print selection only, but neither of those worked. Anything else I'm missing? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Print only unhidden rows
If the rows are hidden, they shouldn't print if you print normally.
In article , fstone09 wrote: How do I print only the unhidden rows on a worksheet? I've tried custom views and print selection only, but neither of those worked. Anything else I'm missing? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Print only unhidden rows
You're right. But what I'm trying to do is print something on one page
without all the blank pages in between. I'm printing rows on page 1 and page 9, and I can move the blue line in page preview to show it as one page. Any ideas? "JE McGimpsey" wrote: If the rows are hidden, they shouldn't print if you print normally. In article , fstone09 wrote: How do I print only the unhidden rows on a worksheet? I've tried custom views and print selection only, but neither of those worked. Anything else I'm missing? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Print only unhidden rows
Sorry, that should have been "I cannot move the blue line..."
"fstone09" wrote: You're right. But what I'm trying to do is print something on one page without all the blank pages in between. I'm printing rows on page 1 and page 9, and I can move the blue line in page preview to show it as one page. Any ideas? "JE McGimpsey" wrote: If the rows are hidden, they shouldn't print if you print normally. In article , fstone09 wrote: How do I print only the unhidden rows on a worksheet? I've tried custom views and print selection only, but neither of those worked. Anything else I'm missing? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Print only unhidden rows
So what rows are hidden?
If all the rows between pages 1 and 9 are hidden, only one (or two, depending on how many unhidden rows are in those pages) will print. In article , fstone09 wrote: You're right. But what I'm trying to do is print something on one page without all the blank pages in between. I'm printing rows on page 1 and page 9, and I can move the blue line in page preview to show it as one page. Any ideas? "JE McGimpsey" wrote: If the rows are hidden, they shouldn't print if you print normally. In article , fstone09 wrote: How do I print only the unhidden rows on a worksheet? I've tried custom views and print selection only, but neither of those worked. Anything else I'm missing? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Print only unhidden rows
All 9 pages print. Pages 2 thru 8 are blank except for the header row. My
solution was to print page 1 and then page 9. That'd be okay if I didn't have 40 files to print with similar problems. What's really strange is that on a couple of files, I could print the eight non-contingent rows I needed on one page. On another couple of files I could move one or two of the blue lines for page break but not the others. Obviously something is controlling or blocking what I want to do on most of my files. Now my boss wants me to copy and paste the rows to a new spreadsheet so they're all together. Here goes another day! "JE McGimpsey" wrote: So what rows are hidden? If all the rows between pages 1 and 9 are hidden, only one (or two, depending on how many unhidden rows are in those pages) will print. In article , fstone09 wrote: You're right. But what I'm trying to do is print something on one page without all the blank pages in between. I'm printing rows on page 1 and page 9, and I can move the blue line in page preview to show it as one page. Any ideas? "JE McGimpsey" wrote: If the rows are hidden, they shouldn't print if you print normally. In article , fstone09 wrote: How do I print only the unhidden rows on a worksheet? I've tried custom views and print selection only, but neither of those worked. Anything else I'm missing? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Print only unhidden rows
Can't you just hide the blank rows?
In article , fstone09 wrote: All 9 pages print. Pages 2 thru 8 are blank except for the header row. My solution was to print page 1 and then page 9. That'd be okay if I didn't have 40 files to print with similar problems. What's really strange is that on a couple of files, I could print the eight non-contingent rows I needed on one page. On another couple of files I could move one or two of the blue lines for page break but not the others. Obviously something is controlling or blocking what I want to do on most of my files. Now my boss wants me to copy and paste the rows to a new spreadsheet so they're all together. Here goes another day! "JE McGimpsey" wrote: So what rows are hidden? If all the rows between pages 1 and 9 are hidden, only one (or two, depending on how many unhidden rows are in those pages) will print. In article , fstone09 wrote: You're right. But what I'm trying to do is print something on one page without all the blank pages in between. I'm printing rows on page 1 and page 9, and I can move the blue line in page preview to show it as one page. Any ideas? "JE McGimpsey" wrote: If the rows are hidden, they shouldn't print if you print normally. In article , fstone09 wrote: How do I print only the unhidden rows on a worksheet? I've tried custom views and print selection only, but neither of those worked. Anything else I'm missing? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Print only unhidden rows
If you add manual pagebreaks to your range, then those pagebreaks will cause
those pages to be printed--even if they're between hidden rows. Maybe you can remove the manual pagebreaks and print. Or maybe you can copy the visible rows to a different worksheet and add the pagebreaks that you want. fstone09 wrote: All 9 pages print. Pages 2 thru 8 are blank except for the header row. My solution was to print page 1 and then page 9. That'd be okay if I didn't have 40 files to print with similar problems. What's really strange is that on a couple of files, I could print the eight non-contingent rows I needed on one page. On another couple of files I could move one or two of the blue lines for page break but not the others. Obviously something is controlling or blocking what I want to do on most of my files. Now my boss wants me to copy and paste the rows to a new spreadsheet so they're all together. Here goes another day! "JE McGimpsey" wrote: So what rows are hidden? If all the rows between pages 1 and 9 are hidden, only one (or two, depending on how many unhidden rows are in those pages) will print. In article , fstone09 wrote: You're right. But what I'm trying to do is print something on one page without all the blank pages in between. I'm printing rows on page 1 and page 9, and I can move the blue line in page preview to show it as one page. Any ideas? "JE McGimpsey" wrote: If the rows are hidden, they shouldn't print if you print normally. In article , fstone09 wrote: How do I print only the unhidden rows on a worksheet? I've tried custom views and print selection only, but neither of those worked. Anything else I'm missing? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CheckBoxes Stack up when Rows are hidden and unhidden | Excel Worksheet Functions | |||
| How do I copy only the unhidden rows/colums? | Excel Discussion (Misc queries) | |||
| How do I protect hidden rows from being unhidden? | Excel Worksheet Functions | |||
| sumif only for unhidden rows | Excel Worksheet Functions | |||
| Excel- Saving only unhidden rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
