Solved

copy

Posted on 2011-09-08
4
146 Views
Last Modified: 2012-05-12
Hi.

1) After filtering on a certain column, I'm trying to copy and paste the subset of values from column a into column b. For some reason all I get is the columns the original values w/o filtering.

2) Same question with hidden columns and rows. I hide columns B and I want to copy and paste columns A and C
0
Comment
Question by:SF1055
4 Comments
 
LVL 4

Accepted Solution

by:
grogman earned 125 total points
ID: 36506339
Highlight your data. Then, on the Home tab, go to the Editing group, click "Find & Select", then click "Go To". In the Go To dialog, click "Special". Under "Select", click "Visible cells only", then click OK.

This will highlight only the visible cells in your selection, which you can now copy and paste to a new location.
0
 
LVL 6

Expert Comment

by:reitzen
ID: 36508162
You could use an advanced filter and use "Copy to another location", which could be column B
0
 
LVL 31

Expert Comment

by:Rob Henson
ID: 36509126
How are you selecting the area to be copied?

When filtered, if you are selecting the whole column by clicking the column header, then the whole column will copy. If you are selecting just the data then it should just copy the visble cells.

With hidden (manually rather than filtered out), the copy will take the whole area copied. If you were to select the whole column/row it would copy the whole again but when pasting it would apply the column/row formatting which in this case is "hidden" so the pasted column/row would also be hidden.

Thanks
Rob H
0
 
LVL 41

Expert Comment

by:dlmille
ID: 36515329
I always select the visible rows, manually, then copy/paste seems to work for me.

Dave
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

747 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