ok let me clear everything. I have one excel sheet in which i have 10,000 plus rows of values. When i filter the column and select which item i need..for example: there are 10 rows.I filter it and select 1 and 10 row respectively. Then i select these both rows and make copy (Ctlr + C) and paste (Ctlr + V) somewhere else in the same sheet.(different row). It should show me only these two rows not all the row (1 to 10). problem is its showing me all rows from 1 to 10 which i don't want like this. I want only dose two row which is supposed to be like this. I hope this time u will understand.