| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
many thanks will try that
"Alan" wrote: No need for a formula, as Alan Beban advised, hold down the shift key and select all the sheets, then enter whatever in F5 "scotty" wrote in message ... if i want to change cell f5 on all sheets what formula would i use "Alan Beban" wrote: scotty wrote: i want to change the same cell on many sheets in one go can anyone give me the formula for this Select all the sheets; then insert the formula in the appropriate cell in the active sheet. Alan Beban |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| name of another worksheet in cell for reference | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Threaded Mode
