View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how can i make a list of numbers automatically

Couple of methods.

1. Enter first and second number in two adjacent cells. Select both then
Drag/copy down or across.

2. Enter one number in a cell. Right-click and drag....release button and
"Fill Series"


Gord Dibben MS Excel MVP

On Thu, 7 Jun 2007 08:11:05 -0700, aller.maria
wrote:

i'm trying to make a calendar for a project and would like the 'fill handle'
button to automatically correlate the numbers. anyone could let me know how
to do that? sometimes it happens automatically but other times it doesn't
seem to work