Make Changes in Multiple Excel Sheets
 

I have similar 100 Survey Forms in Excel Sheets. Now I have to make some
modification in certian Fields of worksheet and want to apply those changes
in All files. Can any body help me in this regard?

Make Changes in Multiple Excel Sheets
 

Hello
- Hold Ctrl key and select with left click each of the sheets you want
included
NB: If all sheets to be included: right-click on one worksheet tab and
choose "select all sheets"
- Make your amendments, they will apply to the selected sheets

HTH
Cordially
Pascal

Make Changes in Multiple Excel Sheets
 

Select the First worksheet.

Go to the last worksheet but dont click it. (you can do this by using
the "|" at the bottom left of Excel.

Now hold the "SHIFT" key and click on the last worksheet.

walla..... all worksheet selected but becareful when you change a cell
cause the changes will be applicable to all worksheets.:cool:


--
Infinity
------------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725
View this thread: http://www.excelforum.com/showthread...hreadid=527469

Make Changes in Multiple Excel Sheets
 

Thanks for reply
But I want to make changes in multiples Excel Files Containg most of similar
Fields. I have 100 Excel Files having 7 sheets. I want to update two or more
field and want to make that change apply to 100 files. Is there any concept
to making a master document in which you make some changes and those changes
apply to other Files.
Or some thing else because now I have to open every file and updating that
information
"Infinity" wrote:


Select the First worksheet.

Go to the last worksheet but dont click it. (you can do this by using
the "|" at the bottom left of Excel.

Now hold the "SHIFT" key and click on the last worksheet.

walla..... all worksheet selected but becareful when you change a cell
cause the changes will be applicable to all worksheets.:cool:


--
Infinity
------------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725
View this thread: http://www.excelforum.com/showthread...hreadid=527469

Make Changes in Multiple Excel Sheets
 

?B?QWhzYW4gWW91c2Fm?= wrote

Thanks for reply
But I want to make changes in multiples Excel Files Containg most of
similar Fields. I have 100 Excel Files having 7 sheets. I want to
update two or more field and want to make that change apply to 100
files. Is there any concept to making a master document in which you
make some changes and those changes apply to other Files.
Or some thing else because now I have to open every file and updating
that information
"Infinity" wrote:


Select the First worksheet.

Go to the last worksheet but dont click it. (you can do this by using
the "|" at the bottom left of Excel.

Now hold the "SHIFT" key and click on the last worksheet.

walla..... all worksheet selected but becareful when you change a
cell cause the changes will be applicable to all worksheets.:cool:


--
Infinity
----------------------------------------------------------------------
-- Infinity's Profile:
http://www.excelforum.com/member.php...o&userid=32725 View
this thread: http://www.excelforum.com/showthread...hreadid=527469




Yes there is a concept to do that. It involves pasting links from your
master document into those other files. Select desired range from master,
open target file, select target range, Edit-PasteSpecial-Paste Link

--
David