<div>
Hello dplearning,<br />
<br />
Simply hiding a row or column will not prevent you from copying the data there.<br />
<br />
You need to be using the AutoFilter to suppress copying of unseen cells. &nbsp;Of course, even with the AutoFilter,<br />
hidden columns/rows will still paste unless you are applying criteria in the filter.<br />
<br />
Regards,<br />
<br />
Patrick
</div>


Hello dplearning,

Simply hiding a row or column will not prevent you from copying the data there.

You need to be using the AutoFilter to suppress copying of unseen cells.  Of course, even with the AutoFilter,
hidden columns/rows will still paste unless you are applying criteria in the filter.

Regards,

Patrick

<div>
dplearning,<br />
<br />
Or just do what Rory told you :)<br />
<br />
<br />
<br />
Patrick
</div>


dplearning,

Or just do what Rory told you :)



Patrick

<div>
The long way to Rory's shortcut is F5 - Special - Visible cells only<br />

</div>


The long way to Rory's shortcut is F5 - Special - Visible cells only


<div>
<div class="content wysiwyg-content">
I have lost the ability to Paste Visible Cells Only in Excel 2007. I am creating a summary of data from a giant spreadsheet where I need to paste just the visible cells into an existing table in another tab. All columns are being pasted for some reason. &nbsp;I’m doing something wrong, but I’m stumped as to what that is.<br />
<br />

</div>
</div>


I have lost the ability to Paste Visible Cells Only in Excel 2007. I am creating a summary of data from a giant spreadsheet where I need to paste just the visible cells into an existing table in another tab. All columns are being pasted for some reason.  I’m doing something wrong, but I’m stumped as to what that is.



Visible Excel Cells

Multimedia applications are those programs that integrate more than one media at a time; browsers are the most obvious. However, the term has come to include the use of programs that enable the use of any component that isn’t simple text and static graphics, such as audio, video, animation, virtual reality, conferencing and monitoring.

MultiMedia Applications

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

Microsoft Excel

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.