If you select a number of sheets (e.g. by ctrl+clicking their sheet
tabs) then any change you make on one of the sheets will also be made
on the others.

Be sure to right-click a sheet tab and select Ungroup sheets when you
have finished making the changes that are to apply to all the sheets or
subsequent changes will have undesired side-effects on other sheets.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup