How to copy and paste quickly in Excel 2011 for Mac.
January 20, 2011 10:41 PM Subscribe
In Excel 2011 for Mac, everything slows to a crawl if I cut or copy a large number of cells. Is there any way to fix this? If not, is there a different spreadsheet program that could do this quickly?
posted by eisenkr to Technology (14 answers total)
As part of my work, I often have to cut/copy and paste a relatively large number of cells---e.g., a 500x500 square of cells---in Excel. When I do this on a windows machine, the process is instantaneous, regardless of the OS or the version of Excel. Unfortunately, when I try the same procedure in Excel 2011 on my new Macbook pro, the program hangs for a few seconds as I watch the spinning beach-ball. This is particularly frustrating because I often need to repeat the copy/paste procedure a few dozen times.
I have two questions: First, is there any way to tweak Excel 2011 for Mac to speed up the copy/paste procedure? I can instantaneously copy and paste this much data in any other program and every other feature in the 2011 Office suite runs without hesitation.
Second, if there's no way to get around the slowdown, are there any spreadsheet programs for Mac that are both faster and can handle data with a thousand or so columns (most spreadsheet software seems to max out at 256 columns). I already use databases for large data-files and do all of my statistical work in R, but it would be great to have access to a reasonably fast spreadsheet program as well.