| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pasting in visible cells only
I have a list that I would like to copy and paste into a spreadsheet that is
filtered. when I do this, some of the data goes into the hidden rows. Is there a way to "paste" to visible cells only? I can't seem to do it with the "select visible cells" function. Thanks! Heidi |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pasting in visible cells only
Can you sort your data so that the visible rows are grouped together. Then you
could paste to that nice contiguous range. Howieben wrote: I have a list that I would like to copy and paste into a spreadsheet that is filtered. when I do this, some of the data goes into the hidden rows. Is there a way to "paste" to visible cells only? I can't seem to do it with the "select visible cells" function. Thanks! Heidi -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pasting in visible cells only
Select the range you want to paste to an choose to edit - go to and
select visible cells only. Per Erik On Thu, 4 May 2006 11:54:02 -0700, Howieben wrote: I have a list that I would like to copy and paste into a spreadsheet that is filtered. when I do this, some of the data goes into the hidden rows. Is there a way to "paste" to visible cells only? I can't seem to do it with the "select visible cells" function. Thanks! Heidi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns | Excel Worksheet Functions | |||
| Stoping users pasting formulas into cells | Excel Worksheet Functions | |||
| average of visible cells in a filtered range | Excel Worksheet Functions | |||
| AutoFill Visible Cells with Months | New Users to Excel | |||
| SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY | Excel Worksheet Functions | |||
Linear Mode
