How-To Quickly Select A MASSIVE Range In Excel

How to select a very large range in Excel using the keyboard shortcuts of CTRL + SHIFT + Arrow Keys

[trangkaylee]

Thank you very much for sharing this trick! I started a new job last week, and I work with large spreadsheet everyday. Everyday I watch a few videos on youtube to learn new techniques to be more efficient at work. I appreciate your kindness.

[SteS]

Video is not fast at all. Hate slow videos and this is just perfect. You can also type in goto box *A10:A:15000* which will select column A10 to A15000. It can be done in the little box next to the function box too. Learned the shift trick.

Thanks.

[kcoren]

Control, shift, arrow.... works well when highlighting a lot of rows or columns. Thank you

[exceldashboards]

Thanks for the great reply. I am so happy that this will help you!

[nuccibros]

Perfect, exactly what I was looking for. Thank you so much!

[k]

Use
1.F5 + F8
2.Just input range in namebox

[juancorrea]

Hi,

I need help with the following information,

I have an excel sheet with thousands of cells, most of the cells have about 7 numbers of one and two digits separated by commas.

I need to find the way to tell the system to highlight cells with specific criteria, for Ex:

To highlight cells that have specific amount of numbers, like; Give me all the cells that have 4 numbers within a range from 30 to 38 (2, 10, 31, 33, 35, 38. Or between 10 and 19 >>> 5, 11, 12, 13, 15, 30, or from 20 to 29 (21, 23, 25, 28, 32, 35)

Will gladly appreciate any help on this!

[onlybarbi]

going way too fast for us slow speed learners.