How to apply the same formatting to every sheet in MS Excel workbook?

0 votes
asked Aug 17 in MS Excel Issues by Rosy
Hello everyone,

I am looking to apply the same formatting to every sheet in MS Excel workbook. But don’t know the right way to do so. Can anyone please suggest me the right way to do so?

1 Answer

0 votes
answered Aug 17 by alva (640 points)

Very first right click ‘Worksheet’ tab > now choose ‘Select All Sheets’. And after that any formatting is done will be applied to the whole workbook.

However if looking to apply it to a particular group of sheets, then choose only those sheets that require formatting.

Welcome to Q&A - Repair MS Excel File, where you can ask questions and receive answers from other members of the community.
...