Posted to microsoft.public.excel.misc

Gord Dibben

Posts: n/a

How can i quickly mark a huge range, like A1 to DV3500?

In the Name Box(left side of Formula Bar)

type A1:DV3500 and ENTER

Gord Dibben Excel MVP

On 7 Dec 2005 10:14:30 -0800, wrote:

Hi folks,
How can i move from A1 to DV3500 quickly without scrolling all the way
down?
What keys will achieve this?
thanks
Cricket

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
create range bar graph	Aussie1497	Charts and Charting in Excel	2	April 26th 23 11:47 AM
Counting empty cells within a range of cells	Rosehill - ExcelForums.com	New Users to Excel	2	May 2nd 05 08:53 AM
Dynamic Print Range Help	waxwing	Excel Worksheet Functions	2	February 21st 05 03:47 PM
Define a range based on another named range	Basil	Excel Worksheet Functions	2	February 21st 05 01:47 PM
named range refers to: in a chart	Spencer Hutton	Excel Discussion (Misc queries)	1	December 14th 04 10:15 PM

All times are GMT +1. The time now is 09:30 AM.

About Us

"It's about Microsoft Excel"