print or copy filtered rows

  • Thread starter Thread starter ADIB
  • Start date Start date
A

ADIB

Hi all
How do i copy or print filtered row and column for instence
i have data from a2:g2 and a2:g45 after sorting or filter it comes only 15
rows i want to copy these rows on another sheet also i want to print it.
please give me any suggestion.Thanks
 
To copy to another sheet just select the filtered rows and copy.

The hidden rows should not copy.

If they do for some strange reason try F5>Special>Visible cells only>OK

Copy those to another sheet for printing.

Easiest would be to just print the filtered sheet. Hidden rows will not
print.


Gord Dibben MS Excel MVP
 
Basic steps are this

Copy the filter result to a new worksheet:

1) Select the whole data range or if you not have empty rows/columns in the range
you can use Ctrl * to select all data or use F5>Special>Current region>OK with
one cell selected in the data range.
If it copy all the data (there are a few reports of 2007 users) use also the shortcut
Alt ; or F5>Special>Visible cells only>OK to select only the Visible cells.

2) Ctrl c in all Excel versions or:
Excel 97-2003: Edit>Copy
Excel 2007: Home tab>Clipboard group>Copy

3) Shift F11 in all Excel versions to insert a worksheet or:
Excel 97-2003: Insert>Worksheet
Excel 2007: Home tab>Cells group>Insert...Sheet
Or use button next to the last tab

4) Ctrl v in all Excel versions or:
Excel 97-2003: Edit>Paste
Excel 2007: Home tab>Clipboard group>Paste

5) Select the worksheet with the filter

6) Press Esc
 
Back
Top