Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » General » New Row at Top of List

New Row at Top of List

Previous | Next
Latest post Thu, Jan 10 2008 4:54 PM by Mike Alexander. 2 replies.

  • Wed, Jan 9 2008 8:29 PM

    • dkusleika
    • Top 75 Contributor
    • Joined on Wed, Jan 9 2008
    • Omaha
    • Posts 4
    • Points 168
    • MVP

    New Row at Top of List

    Reply |Contact

    Excel 2003.  I want the "new row" with the asterisk to appear at the top of the list rather than the bottom.  Is this possible?     

    Dick Kusleika http://www.dailydoseofexcel.com
    Filed under:
    • Post Points: 21

  • Thu, Jan 10 2008 10:02 AM In reply to

    Re: New Row at Top of List

    Reply |Contact |Mark as Answer

    If it is, they cunningly hid it from us!

    Regards, Jan Karel Pieterse www.jkp-ads.com
    • Post Points: 21

  • Thu, Jan 10 2008 4:54 PM In reply to

    Re: New Row at Top of List

    Reply |Contact |Mark as Not Answer

    The structure of the ListObject is pretty locked down. 
    You're best bet would be to send the data to the list from another area in your spreadsheet.

    Maybe create a dummy row that look like it's part of the List.

    Mike Alexander Microsoft Excel MVP www.datapigtechnologies.com
    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.