LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Hnelg
 
Posts: n/a
Default Filling cells (autofil?) in Excel 2003

Hi,

I have a need to populate a large portion of cells with telephone numbers
and I'm wondering if there is a quick way to do this.

For example, I might start off a cell with the telephone number 82370000 and
will need to populate a column with consecutive numbers up to 82379999 (a
total of 10,000 numbers.

What I have awkwardly tried to do is to use the autofill feature and drag
down 10,000 cells. But, this it pretty difficult to scroll down with as
excel scrolls too quick.

Is there a way I can tell excel to fill downwards for a quantity of 10,000
cells without dragging with the mouse downwards?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel 2003 will not display color fonts or color fill cells DaveC Excel Worksheet Functions 1 April 11th 05 04:38 PM
Excel 97 macros to Excel 2003 Kath Excel Worksheet Functions 1 February 17th 05 07:44 AM
CHR() function not working in Excel 2003 Richard Jonas Excel Discussion (Misc queries) 4 February 16th 05 08:45 AM
Excel 2003 Opens Up Every File in My Documents Glenn Reschke Excel Discussion (Misc queries) 4 February 11th 05 06:00 PM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 13th 04 11:51 PM


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"