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.

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

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

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

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

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