First you should click any single range in the data set, then on the data tab choose Advanced, it should be in filter group. When advanced filter window has appeared, you can enter the range for the data set in criteria range box. Finally, click OK and this is it.
