Paste into Visible Cells Only

C

CR

Is there a way to paste into visible cells only? I have a spreadsheet with
several columns of data that are not on the spreadsheet I am taking data
from. I have hidden these columns and left only the columns that match the
other spreadsheet. Is there a way to only paste into the cells that are
showing? Thank you in advance for your help.
 
D

Debra Dalgleish

When you paste, it will paste into a contiguous range, not the visible
cells in the filtered range.

Perhaps you could mark the visible rows, by putting an X in an adjacent
column. Then, sort by the marked column, and paste into the grouped cells.
 
Top