ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   copying formulas to multiple sheets (https://www.excelbanter.com/excel-worksheet-functions/151057-copying-formulas-multiple-sheets.html)

dimitry

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

bj

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



All times are GMT +1. The time now is 03:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com