Enter A1:A48000 in the namebox and hit <enter


Gord Dibben MS Excel MVP

On Sat, 26 May 2007 08:00:01 -0700, Mr. Low
wrote:

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