I want to be able to paste data into visible cells only … but can't seem to get it to work. For the record, I have a Mac and my document is saved as an Excel 97-2004 workbook .xls. Can anybody walk me though this? Thank you.