#1   Report Post  
season
 
Posts: n/a
Default lists

I want to create a list from 3600-4000 in one column. What shortcut can I use
so I don't have to literally type each number?
  #2   Report Post  
Gary's Student
 
Posts: n/a
Default

Enter 3600 in a cell, click on the cell and then place the cursor on the
lower right-hand corner of the cell (it will change shape).

While holding down the right clicker, drag the crusor down a ways, then
release the right clicker. Select Fill Series from the resultant options
--
Gary's Student


"season" wrote:

I want to create a list from 3600-4000 in one column. What shortcut can I use
so I don't have to literally type each number?

  #3   Report Post  
Karthik
 
Posts: n/a
Default

Example:


In cell A1 enter 3600
In cell A2 enter 3601


Select these two cells (using mouse or key board) and now take ur mouse

cursor over to the bottom right end of cell A2. You will see ur cursor
change to a black plus sign. Click and drag this till cell A 401and you

will have the numbers from 3600 to 4000.


By the way which season????

Karthik Bhat
Bangalore

Reply
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
IF statement with lists and dropdowns malik641 Excel Worksheet Functions 1 June 21st 05 01:41 AM
How do I return dynamic lists? liciakay Excel Worksheet Functions 1 March 30th 05 08:22 AM
Comparing 2 Customer Lists to Identify Shared Customers carl Excel Worksheet Functions 2 January 26th 05 07:17 PM
How do I compare two lists of names in excel? Jack the Cate Excel Discussion (Misc queries) 1 December 24th 04 12:07 PM
finding common numbers in large lists Jenn Excel Worksheet Functions 1 November 11th 04 07:42 PM


All times are GMT +1. The time now is 03:04 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"