ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2003 List designs (https://www.excelbanter.com/excel-discussion-misc-queries/172514-2003-list-designs.html)

KJ

2003 List designs
 
2 part question.
I have excel 07 and an associate has 03.

I've created a spreadsheet using tables in 07. When I sent it to my coworker
using 03 I had to re-create the "list". Is there something I could've done
differently or do I just need to get over it?

Part two: In 07 they give you design options ei every other row is
highlighted.
In 03 I can't find a similar function for the list.

I went from 2000 to 07 so I missed the whole 2003 experience. I would
appreciate any help!

Tyro[_2_]

2003 List designs
 
What is a list?

"KJ" wrote in message
...
2 part question.
I have excel 07 and an associate has 03.

I've created a spreadsheet using tables in 07. When I sent it to my
coworker
using 03 I had to re-create the "list". Is there something I could've
done
differently or do I just need to get over it?

Part two: In 07 they give you design options ei every other row is
highlighted.
In 03 I can't find a similar function for the list.

I went from 2000 to 07 so I missed the whole 2003 experience. I would
appreciate any help!




Jon Peltier

2003 List designs
 
Do you have Excel 2003? If so, select a data range, go to Data menu List
Create List. You'll see a highlighted region with autofiltering dropdowns
and so forth. This very useful feature was fortified in Office 2007. I
haven't played with it much between 2007 and 2003; I think a 2003 list
becomes a 2007 table smoothly, but the reverse not as smoothly.

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


"Tyro" wrote in message
et...
What is a list?

"KJ" wrote in message
...
2 part question.
I have excel 07 and an associate has 03.

I've created a spreadsheet using tables in 07. When I sent it to my
coworker
using 03 I had to re-create the "list". Is there something I could've
done
differently or do I just need to get over it?

Part two: In 07 they give you design options ei every other row is
highlighted.
In 03 I can't find a similar function for the list.

I went from 2000 to 07 so I missed the whole 2003 experience. I would
appreciate any help!







All times are GMT +1. The time now is 12:56 PM.

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