Select a shape
Click in the formula bar, and type an equal sign
Click on the cell that contains the name for that shape.

There's an example he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for Seating Plan.

cityinday wrote:
Hi,

I am creating a dinner event layout using excel. The names of all
diners are keyed into individual cells. may i know if there is a way
which i can create a graphical representation of tables and the names
to each seat. Thanks!




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html