Select a large range
 

Dear experts,

Is there a shortcut to select a large range, such as A1:E11000 instead of
select A1:E1 and then hold down the "Shift" key and then the "Page Down" key?

Please advise.

Thanks in advance

Select a large range
 

One way

Type the range in the namebox*, viz.: A1:E11000
Then just press Enter to select the range

*box with the dropdown just to the left of the formula bar
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Freshman" wrote:
Dear experts,

Is there a shortcut to select a large range, such as A1:E11000 instead of
select A1:E1 and then hold down the "Shift" key and then the "Page Down" key?

Please advise.

Thanks in advance

Select a large range
 

Dear Max,

Wonderful! Thanks for your help to me many amny times.

Best regards to you and your family.

Merry X'mas

"Max" wrote:

One way

Type the range in the namebox*, viz.: A1:E11000
Then just press Enter to select the range

*box with the dropdown just to the left of the formula bar
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Freshman" wrote:
Dear experts,

Is there a shortcut to select a large range, such as A1:E11000 instead of
select A1:E1 and then hold down the "Shift" key and then the "Page Down" key?

Please advise.

Thanks in advance

Select a large range
 

Welcome, Freshman.

Warmest regards & Merry Christmas!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Freshman" wrote in message
...
Dear Max,

Wonderful! Thanks for your help to me many amny times.

Best regards to you and your family.

Merry X'mas