Excel 2002 : How to speed block cells ?

[Guest]

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

 

[Guest]

same way enter A1:H48000 in top left hand corner

"Mr. Low" skrev:

 

[Gord Dibben]

Enter A1:A48000 in the namebox and hit <enter>


Gord Dibben MS Excel MVP

 

[Guest]

... 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

 

[Guest]

Thanks for your help.

Low
--
A36B58K641

same way enter A1:H48000 in top left hand corner

"Mr. Low" skrev:

 

[Guest]

Hello Gord,

Thanks for your help.

Low

 

[Guest]

Hello Max,

Thanks for your help.

Low

 

[Max]

Welcome, Low.