![]() |
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. |
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