Solved

Paste on filtered data

Posted on 2014-11-06
5
100 Views
Last Modified: 2014-11-06
Hi,

Once I filter a list, for example, in Region column I filter a list for North entries only (there are South, East, and West also). Then after the filtered list is obtained, I want to be able to paste some values in a column only against North (at present North is filtered). How can I achieve this?

Thanks,

San.
0
Comment
Question by:sanjay-gandhi
  • 3
  • 2
5 Comments
 
LVL 15

Accepted Solution

by:
Haris Djulic earned 500 total points
Comment Utility
Hello,

you just select the cells in column next to Region column and paste the values to selected cells.

Here you can see it  step-by-step video
0
 

Author Closing Comment

by:sanjay-gandhi
Comment Utility
Thanks,

But some time back, I saw it copied on hidden rows also. Why would that happen?

San.
0
 
LVL 15

Expert Comment

by:Haris Djulic
Comment Utility
If you select more cells and just paste in without selecting destination it will paste it starting from the selected cell and in that case if there are some hidden rows it will paste to those rows as well.
0
 

Author Comment

by:sanjay-gandhi
Comment Utility
Thanks Haris.
0
 
LVL 15

Expert Comment

by:Haris Djulic
Comment Utility
Sure, anytime..
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now