Excel 2002 : How to speed block cells ?
 

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





--
A36B58K641

Excel 2002 : How to speed block cells ?
 

same way enter A1:H48000 in top left hand corner

"Mr. Low" skrev:

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





--
A36B58K641

Excel 2002 : How to speed block cells ?
 

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

Excel 2002 : How to speed block cells ?
 

... 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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





--
A36B58K641

Excel 2002 : How to speed block cells ?
 

Thanks for your help.

Low
--
A36B58K641


"excelent" wrote:

same way enter A1:H48000 in top left hand corner

"Mr. Low" skrev:

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





--
A36B58K641

Excel 2002 : How to speed block cells ?
 

Hello Gord,

Thanks for your help.

Low
--


--
A36B58K641


"Gord Dibben" wrote:

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

Excel 2002 : How to speed block cells ?
 

Hello Max,

Thanks for your help.

Low
--
--
A36B58K641


"Max" wrote:

... 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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





--
A36B58K641

Excel 2002 : How to speed block cells ?
 

Welcome, Low.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mr. Low" wrote in message
...
Hello Max,

Thanks for your help.

Low