hat
E. Ki sa ki nan Menm bouton ranje? Li pral otomatikman presize chak Fèy travay nan tout liv sou tchèk nan Lis livè yo gen seri a menm jan ak Fèy travay la ou chwazi a. Pou egzanp, a Sheet1 of Travayè A gen yon seri $ A $ 1: $ C $ 6 jan yo montre nan D a anba a, si ou premye klike sou Sheet1 epi klike sou Menm ranje bouton, ou pral wè seri a Sheet2 of Travayè A se chanje nan seri a menm jan Sheet1, ak chak Fèy travay nan tchèk bookbook nan la Lis livè ap gen menm seri a tou kòm Sheet1 nan Workbook A. Al gade nan Ekran:
eng
E. What’s Same range button? It will automatically specify each worksheet of all checked workbooks in the Workbook list to have the same range as the worksheet you selected. For example, The Sheet1 of Workbook A has a range $A$1:$C$6 as shown in the below screenshot, if you first click on Sheet1 and then click Same range button, you will see the range of Sheet2 of Workbook A is changed to the same range as Sheet1, and each worksheet of checked workbooks in the Workbook list will also have the same range as Sheet1 of Workbook A. See screenshots: