Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How to assign index numbers in block ? | Excel Discussion (Misc queries) | |||
Excel 2002 : Is there any speed fill formula ? | Excel Discussion (Misc queries) | |||
Excel 2002 : How to get the difference in a block of data ? | Excel Discussion (Misc queries) | |||
Excel should include flashing cells/block and marching ants like W | Excel Worksheet Functions | |||
Speed of marking cells | Excel Worksheet Functions |