absolutely correct, blonde moment from me ;)

Mike

"Peo Sjoblom" wrote:

Or hold down shift and click first and last tab

--
Regards,

Peo Sjoblom



"Mike H" wrote in message
...
One way,

Hold down the control key and click each sheet tab in turn i.e.select all
sheets. Enter your value in a1 and it will be in all sheets.

Mike

"ED" wrote:

I am trying to enter a new value in cell A1 and would like it displayed
in
the whole workbook ( I have 12 sheets)

Thanks.