Wednesday 30 November 2016

Selecting only visible cells in Excel

I found a neat solution to a problem I have manually been working around for quite sometime.

If you have hidden any rows or columns in Excel and want to copy the remaining data only, or if you have made use of the outlining tool and have created subtotals in your document and you only want to copy those subtotals then you can do so by following these steps;-

  1. Select the data you want to copy
  2. Press Ctrl+G to bring up the "Go To" window
  3. In the bottom left corner click the Special button which will bring up the "Go To Special" window
  4. From this window select "Visible cells only" 
  5. Click OK

Now copy and paste the selection as you normally would.

No comments:

Post a Comment