Scenario 1 : assuming we have 50,000 rows in an excel sheet and we want to select rows up to 11,500. Do we need to use select special to get this done? And if yes, what is the option to do that?
Scenario 2: same like above scenario, if we want to specifically select x no. of rows and y no. of columns in a large data set…..how do we do that?
That’s a very interesting question.
You’ll need to do the following:
- Filter the first row
- Then click on the filter and opt for ‘Custom’ filter
- Select to see the values from 1 to 11,500
- Select the rows up until the rest of the table
This is a relatively fast way to select the rows from 1 to 11,500.
Please correct me if I’m wrong, I was playing around with select special to see if I can try to achieve the same. (selecting a subset of rows in a large data set)
I personally felt that’s even much more faster than the above method.
- Select a row
- Press F5
- In the reference box, type $<StartRownumber>:$<EndRownumber> Eg: 1:11500 or $1:$11500
- Press OK…viola it done!
Super impressive! To be honest I had not seen this technique so far. Would you authorize me to add it in a lesson?
Thanks for your acknowledgement. Woah, It was surprising for me as well to discover this technique while playing around with select special. Lets take this offline, I have mailed you in ur official email id regarding this subject. 🙂
Thanks, Anusha! Email received.