[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

[Gord Dibben]

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 F5SpecialVisible cells onlyOK

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


On Fri, 20 Feb 2009 14:03:01 -0800, ADIB
wrote:

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

[Ron de Bruin]

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 F5SpecialCurrent regionOK 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 F5SpecialVisible cells onlyOK to select only the Visible cells.

2) Ctrl c in all Excel versions or:
Excel 97-2003: EditCopy
Excel 2007: Home tabClipboard groupCopy

3) Shift F11 in all Excel versions to insert a worksheet or:
Excel 97-2003: InsertWorksheet
Excel 2007: Home tabCells groupInsert...Sheet
Or use button next to the last tab

4) Ctrl v in all Excel versions or:
Excel 97-2003: EditPaste
Excel 2007: Home tabClipboard groupPaste

5) Select the worksheet with the filter

6) Press Esc


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ADIB" wrote in message ...
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