Is it possible to number lists separated by a space on Excel? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              acm◘ 8/8/2006 3:08 PM PST   Question   Excel 2003 Is it possible to auto number lists when there is a space between each item? My list skips a line. See belowThe "items" should be in a different column than the numbers 1. Item 2. Item 3. Item Thank you     Was this post helpful to you?         Reply |   Top           Tom Hutchins 8/8/2006 3:17 PM PST   Answer   Here's an example of one way to do this: Enter 1 in cell A1. Cell A2 is empty. Select cells A1 and A2. Using the fill handle (cursor changes to a plus sign at the lower right corner of the selected cells), drag down as far as desired. Hope this helps, Hutch "acm◘" wrote: > Excel 2003 > Is it possible to auto number lists when there is a space between each item? > My list skips a line. See belowThe "items" should be in a different column > than the numbers > > 1. Item > > 2. Item > > 3. Item > > Thank you     Was this post helpful to you?         Reply |   Top           Gord Dibben 8/8/2006 3:24 PM PST   Answer   In A1 enter a 1 Enter nothing in A2 Select A1 and A2. Right-click on the fill handle and Drag/copy down Column A as far as you wish. Release and "Fill Series" Gord Dibben MS Excel MVP On Tue, 8 Aug 2006 15:09:02 -0700, acm? <acm?@discussions.microsoft.com> wrote: >Excel 2003 >Is it possible to auto number lists when there is a space between each item? >My list skips a line. See belowThe "items" should be in a different column >than the numbers > >1. Item > >2. Item > >3. Item > >Thank you     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies