Please Help on How to avoid Pasting the data in Filtered Cells EXCEL 2010?

[nandkishorskale]

Please Help on How to avoid Pasting the data in Filtered Cells EXCEL 2010?

Please see the attachment. in first tab "Filleted_Data" of the "PastingProblem.xlsx" where I need to insert the data which is present in second tab "Copied Data".
I made filter on Age column AGE = 3, and now 3 lines I need to insert, so when I am pasting these 3 lines, these lines are inserting in "Age" column having Sr. no. of 3, 4 and 5 instead of Sr. no 3, 6 and 9.

Note: This is just sample data. I need to work like this on thousands of lines. PLEASE RESPOND/HELP ON THIS ME ASAP.

[NeedForExcel]

Try This

1) Select Range
2) F5
3) Alt+S
4) Visible Cells Only
5) Ctrl+C


Hope it helps!

Deep

[NeedForExcel]

BTW There is a Short Key Solution Also -

Alt + : & then Copy

Deep

[mahaveersomani]

use "Alt" + ";" this key

this key will select only visible data then you can copy only visible data and paste where ever you need.

Hope this is useful to you.

Thanks & Regards
CA Mahaveer Somani

[nandkishorskale]

Try This

1) Select Range
2) F5
3) Alt+S
4) Visible Cells Only
5) Ctrl+C


Hope it helps!

Deep

it helps only for copying the visible cells data, but i need to know the way to paste in filtered cells without inserting in filtered cells

[NeedForExcel]

After you copy it, its regular pasting using Ctrl+V

[nandkishorskale]

After you copy it, its regular pasting using Ctrl+V

Can you please help me on this?
http://www.excelforum.com/excel-gene...el-2010-a.html

[nandkishorskale]

How to avoid Pasting the data in Filtered Cells EXCEL 2010?PastingProblem.xlsx

Please see the attachment. in first tab "Filleted_Data" of the "PastingProblem.xlsx" where I need to insert the data which is present in second tab "Copied Data".
I made filter on Age column AGE = 3, and now 3 lines I need to insert, so when I am pasting these 3 lines, these lines are inserting in "Age" column having Sr. no. of 3, 4 and 5 instead of Sr. no 3, 6 and 9.

PastingProblem.xlsx Copied_data.png FilteredData.png

Note: This is just sample data. I need to work like this on thousands of lines. PLEASE RESPOND/HELP ON THIS ME ASAP.

[mahaveersomani]

i saw your file but i requesting you please upload the same file again.....in which your expected outcome (result) should be mention..... so that i can do some thing for you...

Thanks