Rengê pelê xebatê di Excel de kopî bikin, biguhezînin û biguhezînin

Excel allows you to copy already created sheets, move them both within and outside the current workbook, and change the color of the tabs to make it easier to navigate among them. In this lesson, we will analyze all these features in as much detail as possible and learn how to copy, move and change the color of sheets in Excel.

Copy sheets in Excel

If you need to copy content from one sheet to another, Excel allows you to create copies of existing sheets.

1. Right-click on the tab of the sheet you want to copy, and from the context menu select Biguherînin an kopî bikin.
2. Qutiyek diyalogê dê vebe Biguherînin an kopî bikin. Here you can specify before which sheet you want to insert the copied sheet. In our case, we will specify Biçe dawîto place the sheet to the right of the existing sheet.
3. Qutiya kontrolê hilbijêrin Kopiyek çêbikinû paşê bitikîne OK.
4. The sheet will be copied. It will have exactly the same name as the original sheet, plus a version number. In our case, we copied the sheet with the name Rêbendan, so the new sheet will be called Çile (2). All contents of the sheet Rêbendan will also be copied to the sheet Çile (2).

You can copy a sheet to any Excel workbook, as long as it is currently open. You can select the required book from the drop-down list in the dialog box. Biguherînin an kopî bikin.

Move a sheet in Excel

Sometimes it becomes necessary to move a sheet in Excel to change the structure of the workbook.

1. Click on the tab of the sheet you want to move. The cursor will turn into a small sheet icon.
2. Hold down the mouse and drag the sheet icon until a small black arrow appears at the desired location.
3. Release the mouse button. The sheet will be moved.

Change sheet tab color in Excel

You can change the color of the worksheet tabs to organize them and make it easier to navigate the Excel workbook.

1. Right-click on the tab of the desired worksheet and select the item from the context menu Rengê labelê. The Color Picker will open.
2. Choose the desired color. When hovering over the various options, a preview will appear. In our example, we will choose red.
3. The color of the label will change.

When a sheet is selected, the color of the tab is almost invisible. Try to select any other sheet in the Excel workbook and you will immediately see how the color changes.