Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chancing Excel worksheet | Excel Discussion (Misc queries) | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |