ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Chancing Excel worksheet (https://www.excelbanter.com/excel-programming/395581-chancing-excel-worksheet.html)

Sergio Tamassia

Chancing Excel worksheet
 
Chancing Excel worksheet

I have 240 filled excel worksheets. I need to change 1 formula over 1 cell.
I can open 1 by 1 and chance de formula. I will appreciate if some one could
help me to do it automatically.

Keithlo

Chancing Excel worksheet
 
If the formula you wish to change is the same cell or range of cells in all
the sheets, you can select all the sheets (shift and click to select a
contiguous range of sheets, or Ctrl and click to select a non-contiguous
range of sheets), and make your change once, and it will automatically be
made on all the sheets you selected.

Hope this helps,

Keith

"Sergio Tamassia" wrote:

Chancing Excel worksheet

I have 240 filled excel worksheets. I need to change 1 formula over 1 cell.
I can open 1 by 1 and chance de formula. I will appreciate if some one could
help me to do it automatically.



All times are GMT +1. The time now is 11:49 AM.

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