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?

MS Excel Interview Question
MS Excel Interview Question

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

Previous QuestionNext Question
I have converted my MS Access database to a current conversion. I am getting conversion errors?How can I identify which cells in my spreadsheet have a formula and which do not in MS Excel?