Excel 2002 : How to speed block cells ?

M

Mr. Low

Dear Sir,

I am working with a very large workshhet A1 : M64000.

I can go from cell A1 to cell A48,000 easily by entering cell address at the
top left hand corner of the Excel Worksheet.

But if I wish to highlight cell A1: A48000 or A1:H48000, may I know how to
go about it in the fastest possible way ?

Thanks

Low
 
M

Max

... to highlight cell A1: A48000 or A1:H48000

One quick way ..

Just enter the range, eg input: A1:H48000
within the namebox* then press ENTER
*that's the one at the top left corner with the dropdown,
just above the "A" col header

Another way, press F5, then enter the range, eg A1:H48000
in the Reference box > OK
 
Top