Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enter on value in one worksheet display in whole workbook
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enter on value in one worksheet display in whole workbook
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enter on value in one worksheet display in whole workbook
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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enter on value in one worksheet display in whole workbook
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I enter info in Excel and have it display as an '*'? | Excel Discussion (Misc queries) | |||
How do I enter a SSN but only display the last four digits? | Excel Discussion (Misc queries) | |||
how do I enter a value, display that many fields? | Excel Discussion (Misc queries) | |||
Enter name on 1st worksheet and have it auto. enter on all others | Excel Discussion (Misc queries) | |||
Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel |