ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how can i make a list of numbers automatically (https://www.excelbanter.com/excel-worksheet-functions/145641-how-can-i-make-list-numbers-automatically.html)

aller.maria

how can i make a list of numbers automatically
 
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

Gord Dibben

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




All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com