| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting into Filtered Lists (Visible cells only)
Hi
I'm using a filtered list and need to paste a variety of values into the filtered/visible cells only. For example, I have a filtered list showing all the cars that are made by BMW, and I would like to copy and paste value "BMW" into a new column for the filtered/visible rows As you know, merely pasting or paste-special will paste the BMW into all the hidden rows in between as well, and I need to get around that Many thanks for your help in advance SuperJas. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pasting into Filtered Lists (Visible cells only)
Select the data range for the column where you want the values
do Edit=goto = special and select Visible cells type BMW in the formula bar hit Ctrl+enter rather than just enter. -- Regards, Tom Ogilvy "SuperJas" wrote in message ... Hi, I'm using a filtered list and need to paste a variety of values into the filtered/visible cells only. For example, I have a filtered list showing all the cars that are made by BMW, and I would like to copy and paste value "BMW" into a new column for the filtered/visible rows. As you know, merely pasting or paste-special will paste the BMW into all the hidden rows in between as well, and I need to get around that. Many thanks for your help in advance, SuperJas. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste data to a filtered column, pasting to visible cells only | Excel Discussion (Misc queries) | |||
| countif only visible cells (filtered) | Excel Worksheet Functions | |||
| Pasting in visible cells only | Excel Worksheet Functions | |||
| Pasting Visible Cells | Excel Discussion (Misc queries) | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Linear Mode
