Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a large range that is aggregate into several levels of groups. I want to copy only the rows visible at the current outline level. For example, if I collapse all rows to the first outline level I want to then be able to copy just the rows at the 1st outline level and paste into a different sheet/range.

share|improve this question
    
I don't think this is possible without using vba... –  assylias Apr 22 '12 at 21:32
    
Are the levels by row or by column? –  rishimaharaj Apr 25 '12 at 23:33
    
Can you submit a screenshot? –  Langhard Sep 18 '12 at 13:31
add comment

1 Answer

There is an option in Microsoft Excel which allows you to select only visible cells, rows or columns. This command can be added to the toolbar. To add the "Select Visible Cells" command:

In MS Excel 2007: Right click on the toolbar on top and click Customize Quick Access toolbar. Under Choose Command From drop down menu, select Commands Not in the Ribbon. Scroll down and click on Select Visible Cells. Click on Add and OK.

In MS Excel 2003: Right click on the toolbar on top and click Customize. Go to Commands tab and select Edit under Categories. Scroll down the list under Commands and click on Select Visible Cells. Now drag and drop the command to the toolbar.

share|improve this answer
    
This command, also accessible by the (Alt)+; keyboard shortcut, is very versatile; it also applies when rows and/or columns have been hidden manually or by a filter. Thanks for telling us about the toolbar option. –  Scott Sep 27 '12 at 21:48
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.