Here are all the observational notes using the formula in Excel. Now any format editing done on any of the selected three sheets will be copied to the other selected ones. Select the Sheet1 and now select the Sheet2 with holding Ctrl key and then select Sheet3 keep holding the Ctrl key. First we go to the sheet tabs as shown below. Here we have 4 worksheets and we need to edit the formatting of Sheet1, Sheet2 and Sheet3.įor this we go step by step. Let's understand how to use the function using an example. Only formatting not the data itself.Īll of these might be confusing to understand. Then format any of the selected sheets and the formatting done on the sheet will be copied to all. Go to excel sheet tabs and click all required sheets holding the Ctrl key. For these problems we use the shortcut to do the task.Ĭtrl + Click to select multiple sheets in Excel For example learning the products data of a super store having multiple sheets.

Before proceeding to the analysis in excel, first we need to get the right format of cells. When working with multiple worksheets in Excel.

In this article, we will learn How to format all worksheets in one go in Excel.