Paste into filtered area

  • Thread starter Thread starter Maia
  • Start date Start date
M

Maia

Hi,

is there any way copied cells can be pasted into the visible cells of a
column with autofilter on? The only result I get is that the figures are
pasted to cells in order (visible or not) starting from the first cell.

Thanks,
Maia
 
Excel pastes copied cells into a contiguous range -- you can't paste
into visible cells only.

You can type a value into the first of the filtered rows, and use the
fill handle to copy that value down to only the visible rows.

Or, mark the visible rows with an x in an adjacent column, then sort by
the column that contains the x. This will group the records, and you can
copy and paste into those rows.
 
Back
Top