Tip # 2 Format all the worksheets in a workbook

If you need to format all the worksheets in a workbook the same way, you can hold down the Shift or Control button and select the worksheets. Now that you have the worksheets selected, you can change things like cell or page properties that will apply to all the worksheets selected. After you're done, click on an inactive worksheet (if you've selected all the worksheets) or click on an unselected worksheet (if you did not select all the worksheets) to release the hold.