Microsoft Excel Question:
Download Job Interview Questions and Answers PDF
Is there a way to apply the same formatting to every sheet in a workbook in Excel?
Answer:
Yes. To do this, you will need to right click on one of the worksheet tabs and then choose Select All Sheets. After you do this any formatting that you apply or text you enter will show up on all the sheets in your workbook. In order to eliminate certain sheets from the changes, hold down the Ctrl key and click on the tab of the worksheet you want excluded from the others. You can also group sheets by holding the shift key and selecting the worksheet tab.
Download MS Excel Interview Questions And Answers
PDF