how to find and replace content of a specific cell based on its ad

I

IVUSKA

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
 
J

JMay

Group (ALL) your sheets - Enter the New Value in A8
Immediately -- UNGROUP your Sheets
 
M

Mike H

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
 
B

Bob I

R-click sheet tab and pick Select All Sheets. Now Edit A8, all sheets
will have the edit. R-click Tab, select Ungroup
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find replace in multiple sheets based on namebox 2
Find and replace specific characters within a cell based on positi 2
How to Find/Replace * (asterisk) in cell content 4
Find and Replace variable string 11
replace one tag in content of one cell and format not changed 1
Find and replace a value within a formula 2
Excel 2002: Why Find and Replace not working? 6
Replace the minus value 3

Top