How do I overcome limit in Excel "Go To Special"?
Posted on 2010-11-21
Hello EE Community:
I'm working in Excel (2007) with an export of half a million records, which are not arranged well. There are myriad records where an extra date is mistakenly inserted, which shifts over the subsequent columns of data.
So, I tried F5, [Go To | Special] to select all the cells with dates. After that, I planned to delete these cells and shift cells left to bring the rest of my data into alignment. However, Excel returned the error message "Selection is too large." What is the limit, and how would I overcome?
Thanks so much,