Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change cell information in multiple workbooks
I have 2700 workbooks - all with the same cell that has incorrect
information, I need to change this information ideally without having to open up all of the workbooks, can it be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change cell information in multiple workbooks
Do you mean 2700 separate documents, or 2700 sheets? If you have multiple
worksheets within one document, and the cell addresses are all the same, you can change cell contents simultaneously. For instance, if there are 50 worksheets in a document and you want to change cell D15 in all of them, right-click on any sheet tab name and choose Select all. Then make the change in any sheet. Don't forget to uncheck Select all, or you will continue to make changes in all the selected sheets. "Truemouse2003" wrote in message ... I have 2700 workbooks - all with the same cell that has incorrect information, I need to change this information ideally without having to open up all of the workbooks, can it be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change value in cell | Excel Discussion (Misc queries) | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
How to change the value of a cell when a condition is satisfied, but not otherwise? | Excel Discussion (Misc queries) | |||
change info in 1 cell, prompts you for another | Excel Discussion (Misc queries) | |||
Cell references change when entering new data | New Users to Excel |