Excel 2003 vs Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

marriottra - 20 Mar 2008 22:16 GMT

How do I???

I was an extensive user of the "LIST" functionality under the DATA heading
in Excel 2003. Does Excel 2007 have the same functionality? I can copy
files from Excel 2003 into Excel 2007 and the list function works but I do
not see how to do a "List" with toggle row in the 2007 version. Any feedback
would be appreciated.

Signature

RAM0114

Reply to this Message

Mike Middleton - 21 Mar 2008 02:20 GMT

marriottra or RAM0114 -

In Excel 2007, when I press the F1 key and type "list" into the search box,
the fifth item is "What happened to Excel lists?"

That item explains: "The Excel List feature still exists, but it has been
renamed. Excel lists are now called Excel tables."

Other Help items include how to "Create or delete an Excel table in a
worksheet."

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

> How do I???
>
[quoted text clipped - 4 lines]
> feedback
> would be appreciated.

Reply to this Message

Jon Peltier - 21 Mar 2008 15:01 GMT

CTRL+L still converts a plain range into a List/Table in 2007.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

> marriottra or RAM0114 -
>
[quoted text clipped - 21 lines]
>> feedback
>> would be appreciated.

Reply to this Message