<div>
Thanks,<br />
<br />
But some time back, I saw it copied on hidden rows also. Why would that happen?<br />
<br />
San.
</div>


<div>
If you select more cells and just paste in without selecting destination it will paste it starting from the selected cell and in that case if there are some hidden rows it will paste to those rows as well.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Once I filter a list, for example, in Region column I filter a list for North entries only (there are South, East, and West also). Then after the filtered list is obtained, I want to be able to paste some values in a column only against North (at present North is filtered). How can I achieve this?<br />
<br />
Thanks,<br />
<br />
San.
</div>
</div>


Hi,

Once I filter a list, for example, in Region column I filter a list for North entries only (there are South, East, and West also). Then after the filtered list is obtained, I want to be able to paste some values in a column only against North (at present North is filtered). How can I achieve this?

Thanks,

San.

Paste on filtered data

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.