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>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube