hat
D. Ki sa ki nan Menm bouton ranje? Li pral otomatikman presize chak Fèy travay nan tout liv sou tchèk nan Lis livè nan ki 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è a Sheet2 of Travayè A ap gen seri a menm jan ak la Sheet1, ak chak Fèy travay nan tchèk bookbook nan la Lis livè ap gen menm seri tou. Al gade nan Ekran:
eng
E. What’s the 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, you have specified range $A$1:$C$6 in Sheet1 of Workbook A as shown in the below screenshot, if you first click on Sheet1 and then click Same range button, you will see the ranges in other worksheets of Workbook A are all changed to $A$1:$C$6 immediately. At the same time, ranges in each worksheet of all checked workbooks in the Workbook list will also change to the same range. See screenshots: