try this
right click on a sheet tab"select all sheets"do your thingselect one

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"buss" wrote in message
...
I have a colum with different numbers in each row in the first colum on
worksheet number 1. I want this colum to be the same in the first colum of
each worksheet that I make and to update every worksheet if I have to
insert
a new row in the middle of the worksheet on the first page. Thanks for any
help in advance.