Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .