Enter on value in one worksheet display in whole workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ED - 19 Jul 2007 20:00 GMT

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.

Reply to this Message

Mike H - 19 Jul 2007 20:10 GMT

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

> 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.

Reply to this Message

Peo Sjoblom - 19 Jul 2007 20:14 GMT

Or hold down shift and click first and last tab

Signature

Regards,

Peo Sjoblom

> One way,
>
[quoted text clipped - 8 lines]
>>
>> Thanks.

Reply to this Message

Mike H - 19 Jul 2007 20:46 GMT

absolutely correct, blonde moment from me ;)

Mike

> Or hold down shift and click first and last tab
>
[quoted text clipped - 10 lines]
> >>
> >> Thanks.

Reply to this Message

Rate this thread: