Is there a "create List dialog box" in Excel 2007 ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Newbee - 26 Apr 2008 06:22 GMT

HI, I need to find the "create list dialog box", in Excel 2007. I am doing a
school assignment and the book is Excel '2003'.
They want me to create a list range.

Thanks

Reply to this Message

Billy Liddel - 26 Apr 2008 19:54 GMT

In 2003 select the list and choose, Data, List, Create List and click OK. Or
Select the list and Press Ctrl + L

Peter

> HI, I need to find the "create list dialog box", in Excel 2007. I am doing a
> school assignment and the book is Excel '2003'.
> They want me to create a list range.
>
> Thanks

Reply to this Message

Dave Peterson - 26 Apr 2008 21:28 GMT

List is gone in xl2007.

It's been improved/replaced with Insert|Table.

> HI, I need to find the "create list dialog box", in Excel 2007. I am doing a
> school assignment and the book is Excel '2003'.
> They want me to create a list range.
>
> Thanks

Signature

Dave Peterson

Reply to this Message

Shah Shailesh - 27 Apr 2008 06:13 GMT

If you don't have a Excel-2003, you can download free addins excel menu-2003
to use in Excel-2007 from below site. So you can refer your books of 2003.

http://in.geocities.com/shahshaileshs/

Enjoy Excel-2007.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://in.geocities.com/shahshaileshs/menuaddins

> HI, I need to find the "create list dialog box", in Excel 2007. I am doing
> a
> school assignment and the book is Excel '2003'.
> They want me to create a list range.
>
> Thanks

Reply to this Message

Dave Peterson - 27 Apr 2008 11:49 GMT

But this will only show what looks like the old user interface--it won't bring
back functionality that was dropped in xl2007, right?

> If you don't have a Excel-2003, you can download free addins excel menu-2003
> to use in Excel-2007 from below site. So you can refer your books of 2003.
[quoted text clipped - 17 lines]
> >
> > Thanks

Signature

Dave Peterson

Reply to this Message

Shailesh Shah - 29 Apr 2008 11:48 GMT

Right Dave, BTW for users find defficult to search command in the Ribbon
(Word, Excel and PowerPoint) , there is a nice addon "Search Commands" by
Microsoft Office Labs from below site

http://www.officelabs.com/Pages/Default.aspx

Regards,
Shailesh Shah

> But this will only show what looks like the old user interface--it won't
> bring
[quoted text clipped - 24 lines]
>> >
>> > Thanks

Reply to this Message