| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy a range in Excel without including hidden rows?
I am using Excel 2002. I have created subtotals on a worksheet. I can view
the worksheet and see only the subtotals (the data records are hidden). I would like to create another worksheet consisting of just the header and subtotals from the first worksheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I copy a range in Excel without including hidden rows?
If you select that visible range, you should be able to copy|paste and only the
visible cells will be pasted. If that's not working for you add an additional step. Select the visible cells (and hidden cells) edit|goto|special|visible cells only Then do the copy|paste. Lang wrote: I am using Excel 2002. I have created subtotals on a worksheet. I can view the worksheet and see only the subtotals (the data records are hidden). I would like to create another worksheet consisting of just the header and subtotals from the first worksheet. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add up column of numbers without including hidden rows? | Excel Discussion (Misc queries) | |||
| copy/paste with hidden rows don't want hidden parts to paste | Excel Discussion (Misc queries) | |||
| How do I get excel to sum a range without including hidden cells? | Excel Worksheet Functions | |||
| How do I do a sumif function not including hidden rows? | Excel Worksheet Functions | |||
| How do I NOT copy hidden rows to a new worksheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
