Make Changes in Multiple Excel Sheets

A

Ahsan Yousaf

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?
 
P

papou

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
 
I

Infinity

Select the First worksheet.

Go to the last worksheet but dont click it. (you can do this by usin
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 cel
cause the changes will be applicable to all worksheets.:cool
 
A

Ahsan Yousaf

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
 
D

David

=?Utf-8?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
Click to expand...

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
 
Top