Friday, June 28, 2013

Shortcuts to copy a filtered or sub totalled selection of data

Once you have setup a Subtotal sheet you are ready to capture the data you are looking at using copy but it copies ALL the data not just the results from your subtotal.

In Excel 2007 and 2010 its hard to find a way to copy visible data only

Use the QAT menu dropdown to customise the menu and find the command called SELECT Visible Cells, add it to your toolbar.

Or use the shortcut below:

ALT +; to select the data then  CTRL + C then go to Sheet 2 then CTRL + V to paste.

Search This Blog

Desktop Applications Training Blog


Jamie Johnson
JJSurf IT Training Ltd
http://www.jjsurf.co.uk/