| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to find and replace content of a specific cell based on its ad
I have a workbook with large amount of sheets and I need to replace in cell
A8 in each sheet its content with text XXX, but the former content of the A8 is not the sam, in each cell is different. Is there anyway how to do it at once so i dont have to do it for one sheet by one? Is it possible to replace with a formula? Is it possible to replace like this range of cells? thank you in advance for your help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to find and replace content of a specific cell based on its ad
Group (ALL) your sheets - Enter the New Value in A8
Immediately -- UNGROUP your Sheets "IVUSKA" wrote: I have a workbook with large amount of sheets and I need to replace in cell A8 in each sheet its content with text XXX, but the former content of the A8 is not the sam, in each cell is different. Is there anyway how to do it at once so i dont have to do it for one sheet by one? Is it possible to replace with a formula? Is it possible to replace like this range of cells? thank you in advance for your help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to find and replace content of a specific cell based on its ad
Hi,
Hold down the CTRL key and click each sheet tab to 'Group' them and then enter XXX in A8 of the sheet that's visible and it will be in A8 of all shets. Don't forget to 'Ungroup' them by clicking on a sheet tab when you've done this. Mike "IVUSKA" wrote: I have a workbook with large amount of sheets and I need to replace in cell A8 in each sheet its content with text XXX, but the former content of the A8 is not the sam, in each cell is different. Is there anyway how to do it at once so i dont have to do it for one sheet by one? Is it possible to replace with a formula? Is it possible to replace like this range of cells? thank you in advance for your help |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to find and replace content of a specific cell based on itsad
R-click sheet tab and pick Select All Sheets. Now Edit A8, all sheets
will have the edit. R-click Tab, select Ungroup IVUSKA wrote: I have a workbook with large amount of sheets and I need to replace in cell A8 in each sheet its content with text XXX, but the former content of the A8 is not the sam, in each cell is different. Is there anyway how to do it at once so i dont have to do it for one sheet by one? Is it possible to replace with a formula? Is it possible to replace like this range of cells? thank you in advance for your help |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to find and replace content of a specific cell based on its ad
hey guys thx a lot it really works... u r soooooo cooooool.... u made my day:-)
"IVUSKA" wrote: I have a workbook with large amount of sheets and I need to replace in cell A8 in each sheet its content with text XXX, but the former content of the A8 is not the sam, in each cell is different. Is there anyway how to do it at once so i dont have to do it for one sheet by one? Is it possible to replace with a formula? Is it possible to replace like this range of cells? thank you in advance for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Find/Replace * (asterisk) in cell content | Excel Discussion (Misc queries) | |||
| Find & Replace - Limit search to a specific column | Excel Worksheet Functions | |||
| FIND SPECIFIC TEXT AND REPLACE IT | Excel Worksheet Functions | |||
| replace the content of cell | Excel Discussion (Misc queries) | |||
| Replace all empty or " by the content of the cell above it | Excel Worksheet Functions | |||
Linear Mode
