| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying formulas to multiple sheets
I have a workbook with daily sheets. The formulas are the same and in
the same position.Is there a way to copy them to all the sheets at once, or do I have to do it one by one? Thanks beforehand Dimitry |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying formulas to multiple sheets
select the first sheet. hold the shift button down and select the last sheet.
enter your data/formula into a cell and it will be on all of the sheets which were selected "dimitry" wrote: I have a workbook with daily sheets. The formulas are the same and in the same position.Is there a way to copy them to all the sheets at once, or do I have to do it one by one? Thanks beforehand Dimitry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Excel formulas between sheets | Excel Worksheet Functions | |||
| copying data in multiple sheets | Excel Worksheet Functions | |||
| Copying contents from multiple sheets onto one | Excel Worksheet Functions | |||
| Copying formulas referencing multiple sheets | Excel Worksheet Functions | |||
| Copying multiple sheets to a new book and undertake specialised ed | Excel Discussion (Misc queries) | |||
Linear Mode
