MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formatting multiple worksheets in one operation

Posted by Carrie on August 07, 2001 10:50 AM

I am wondering if there is a way to format multiple worksheets in one operation when the worksheets are linked. For example, I have a price list (1 worksheet is in U.S. currency and the other worksheet is in Canadian currency and they are linked) and I am constantly having to add new products to our price list and I want to figure out a way to update the Canadian worksheet automatically when I add new rows of products to the U.S. price list. Is this possible?

Posted by Dwight on August 07, 2001 1:31 PM

I have a feeling you're talking about seperate workbooks and not worksheets. You can easily format multiple worksheets within the same workbook simply by selecting the desired sheets together before you begin formatting. If you're using multiple workbooks you may want to combine them into one file to facilitate this.

Posted by brent on August 07, 2001 2:56 PM

To "selecting the desired sheets together before you begin formatting" hold the Ctrl key while, with the mouse, highlight the worksheet 'tabs' that you want to link in the formatting