Format all worksheets of a workbook in a Single Go


It often requires to do formatting in a worksheet and then apply the same in different worksheets of the workbook which is very time consuming activity. So here is the solution:-

If you need to format all the worksheets in a workbook the same way, first select the required worksheets using your mouse while holding Ctrl key Or with key combination of Ctrl + Shift + PageUp / PageDown key.  Now that you have the worksheets selected, you can start doing the formatting and you will see the similar formatting has been applied in all the selected worksheets.

When you are done, click on any worksheet and you will come out of the selection of all worksheets.

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>