RE: copying cells over filtered rows.

35 pts.
Tags:
Microsoft Excel
Ever since I got the new version of Excel, this happens SOMETIMES which is very dangerous. When I have filtered rows, and want to copy/drag and paste a value, sometimes it copies the value between the filtered rows!

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BrentSheets
    Are you asking a question or alerting other members to a bug? If you're asking a question, you'll need to provide more details. Even if you're posting an alert - it would be helpful to list the software version and more details. Thanks.
    6,925 pointsBadges:
    report
  • Aerccm
    Brent, I'm not an IT expert. I just use Excel a lot in my business. It is version 2007 .xlsx My work demands that I crunch a lot of numbers and sometimes I want to copy a value in cell and input it into mulitple cells. I have no problem if my rows aren't filtered. But many times I have rows filitered, where I am only looking for certain values contained in a column. During this operation I have noticed that when I copy a cell's value and drag and paste it into the filtered rows, it also pastes that value in the unfiltered rows as well. The big problem is that this doesn't not always occur, which gives me no sense of security and I wind up copying and 'left clicking' into the rows as I want to ensure the value is not placed in a filtered row. This is not a big problem if there are only a few rows, but I work with spreadsheets with rows that could reach in the 1000's. Perhaps there is some Excel option or command that I need to know about to eliminate the pasting of values in the filtered rows?
    35 pointsBadges:
    report
  • BrentSheets
    Aerccm, I'm no Excel guru but since you haven't had a bite yet - I did a search and found a similar problem that was fixed using the method below. Not sure if it will help you in your case or not. After you copy your value, select the filtered range where you wish to paste - but before you paste - click F5 - then click on the special cells button and select the visible cells only and click okay. You should see the cells selected and then paste.
    6,925 pointsBadges:
    report
  • Aerccm
    Thanks for the feedback.; I will try it and advise. Take care.
    35 pointsBadges:
    report
  • Aerccm
    To BrentSheets: Looks like your fix is going to work. I tried it, it worked and I'll pass on to my coworkers. Thanks a lot and go get those knowledge points, or do I need to do something for you to accomplish that?
    35 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following