| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i paste after filtering in excel?
hi,
i filtered blank rows in a sheet and i want to paste 20 rows of cells in that blank rows at a time... blank rows will be 20 exactly but its not pasting .. if iam pasting one by one row its pasting but its not pasting all together.. pls find a solution. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i paste after filtering in excel?
It's pasting all together. But it's pasting in both the visible and hidden
rows. Maybe you can sort your data so that the area to be pasted is contiguous and then do your pasting. richie wrote: hi, i filtered blank rows in a sheet and i want to paste 20 rows of cells in that blank rows at a time... blank rows will be 20 exactly but its not pasting .. if iam pasting one by one row its pasting but its not pasting all together.. pls find a solution. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i paste after filtering in excel?
On Feb 15, 10:51*am, Dave Peterson wrote:
It's pasting all together. *But it's pasting in both the visible and hidden rows. Maybe you can sort your data so that the area to be pasted is contiguous and then do your pasting. richie wrote: hi, i filtered blank rows in a sheet and i want to paste 20 rows of cells in that blank rows at a time... blank rows will be 20 exactly but its not pasting .. if iam pasting one by one row its pasting but its not pasting all together.. pls find a solution. -- After filtering, selectyour desired range with the mouse, edit, go to, special, visible cells only, copy. Select your destination. paste. You can also drag your "select visible cells" icon from the customize menu, and place it on a toolbar. Pierre |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i paste after filtering in excel?
That's never worked for me to paste over just the visible cells.
I don't think it works in any version of excel. Pierre wrote: <<snipped After filtering, selectyour desired range with the mouse, edit, go to, special, visible cells only, copy. Select your destination. paste. You can also drag your "select visible cells" icon from the customize menu, and place it on a toolbar. Pierre -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i paste after filtering in excel?
On Feb 15, 1:02*pm, Dave Peterson wrote:
That's never worked for me to paste over just the visible cells. I don't think it works in any version of excel. Pierre wrote: <<snipped Dave, you COPY the visible cells. Paste them where you want, in an area that is not filtered. HTH. Pierre |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i paste after filtering in excel?
The original poster wants to paste into the filtered range--not copy from the
filtered range. Pierre wrote: On Feb 15, 1:02 pm, Dave Peterson wrote: That's never worked for me to paste over just the visible cells. I don't think it works in any version of excel. Pierre wrote: <<snipped Dave, you COPY the visible cells. Paste them where you want, in an area that is not filtered. HTH. Pierre -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and paste after filtering | Excel Discussion (Misc queries) | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Linear Mode
