Easy Excel question - paste visible cells Excel 2010

desidude

New Member
Joined
Jan 31, 2011
Messages
7
Hi friends,

I am using Excel 2010. I have two columns, A and B

Column A lists the company and column B lists the stock price.

There can be multiple entries with the same company name in Column A, e.g. you can see the name IBM in row 1, 5, 1016, 9812 etc.

So, I am applying a data filter in column A and for example selecting all the listings for IBM.

Let's say I get 500 results. Now in column B, I want to enter the stock price once in the first row, and then copy it down to all the cells for IBM only.

When I do copy and paste, it pasted the values in all the cells from the first one listing IBM to the last one, including those which are non IBM in between.

I am sure there is a simple solution to this in excel 2010....

I hope my explanation is clear....please do help me if you can.

Thanks,
desidude
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

desidude

New Member
Joined
Jan 31, 2011
Messages
7
Hmm..Thanks Andrew Sir...but I am little confused. As I have used a Data Filter and selected 'IBM' in column A...it only shows me the cells corresponding to IBM in column B.

However when I enter a stock price in any cell in IBM related cell in column B and try and copy and paste to the other cells that show up when the filter is applied, it pastes it in all the cells, even those which are not showing up in the filter...

would you solution solve this?

Thank You Sir
 

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,719
Office Version
  1. 365
Platform
  1. Windows
I also found that instead of copy - paste if you just drag the number down it only seems to fill the visible cells.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
That won't happen if you do as I suggested. Although it looks like you have only selected the visible cells you have actually selected those that aren't visible as well. You need to select just the visible ones.

Note that this behaviour is different from previous versions of Excel.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,335
Messages
5,595,569
Members
413,996
Latest member
mabelO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top