Re: selecting long ranges of cells in excel


if you know the top left cell and the lower right cell, you can use the
go to feature to select the range. for example, activate the go to
feature, type a1:z10 and press enter. everything from a1 to z10 will be
(should be) selected.

this also works if you should need to select more than one range. each
range is separated with a comma.

-------- Original Message --------
From: Pablo Morales []
Sent: Sunday, Dec 11, 2016 3:44 PM EST
Subject: selecting long ranges of cells in excel

Hello all,

In excel, I am trying to select the values between two very distant
cells. How can I select two distant cells, when the distance is that
long that just holding shift and navigating through the arrow keys
doesn’t make sense.

Thanks for all,

Join to automatically receive all group messages.