Pasting Into Filtered Data

[Zach Boyer]

Up front, I should explain that I am working on a Mac and originally downloaded the Microsoft Office 2011 version which included Excel. I, however, save the workbook in question in the Excel 97-2004 (.xls) format. For the life of me I can't figure out how to paste into the visible cells only but it's absolutely crucial that I be able to do so. I've watched YouTube videos, but I think many of them apply to newer versions of Excel to which I do not have access. I've scoured these very forums and have yet to find anything definitive. I did, however, figure out how to COPY from visible cells only … and yet when I apply the same technique to pasting—highlighting the section you want, using the Mac shortcut (command + shift + Z) and then pressing paste—it fails. It's also very crucial to keep this data in its original order and therefore any technique using "sorting" could prove problematic. Disclaimer: I also am very new to Excel overall and basically need everything said in complete layman's terms … otherwise I'll be further confused. If anybody out there can hold my hand and walk me through this, I'd be very appreciative of that. Thank you.

[BadlySpelledBuoy]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
http://www.excelforum.com/excel-gene...ells-only.html

Thread Closed.