ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel (https://www.excelbanter.com/excel-discussion-misc-queries/143342-excel.html)

Muddled

Excel
 
Is it possible to make a Starting number in an excel workbook in column a-1,
& command it to make each subsequent cell below it have the next number
entered automatically?
--


Gary Brown

Excel
 
=A1+1
copy down.
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Muddled" wrote:

Is it possible to make a Starting number in an excel workbook in column a-1,
& command it to make each subsequent cell below it have the next number
entered automatically?
--


Don Guillett

Excel
 
try
=row(a1)
or
=$a$1+ROW()-1
to compensate for row deletions.

--
Don Guillett
SalesAid Software

"Muddled" wrote in message
...
Is it possible to make a Starting number in an excel workbook in column
a-1,
& command it to make each subsequent cell below it have the next number
entered automatically?
--




All times are GMT +1. The time now is 02:42 AM.

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