Easiest way to select big range ?

  • Thread starter Thread starter Nancy Kay
  • Start date Start date
N

Nancy Kay

I often want to select big ranges (ie, bigger than I can see on my
screen). For example, if I want to select A1 through D7845, which is
a contiguous range, is there a quick way to do that?

My approach now to hightlight the range is:
CTL-End
click-and-drag to highlight the last valued row
CTL-Home
shift-click the first valued cell

That's not awful, but is there a better way, since Excel is smart
about knowing range boundaries? I'm interested in the manual keyboard
and mouse way, not in a VBA solution.

Thanks!
 
If data is contiguous, then select first cell of your range and do:-

CTRL+SHIFT+RIGHTARROW

then

CTRL+SHIFT+DOWNARROW

or even just

select first cell and then

CTRL+SHIFT+END
 
type

A1:D7845

in the Name box (on the left side of the Formula bar) and press Enter.
 
after u have selected all data using any of the above methods, NAME th
section as "ALLDATA
 
Or even name a dynamic range, so that it picks up any additions/deletions to the
range automatically
 
Back
Top