When you have the workbook open, there is a blank square above where the row
numbers are located. If you click on that little square your page will
highlight as well as all of the pages in your workbook. Any changes you make
when all of these are highlighted will affect the entire workbook.
Shirley