Kopie, réckelen an änneren d'Faarf vun engem Aarbechtsblat an Excel

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 Plënneren oder kopéieren.
2. Eng Dialogbox wäert opmaachen Plënneren oder kopéieren. Here you can specify before which sheet you want to insert the copied sheet. In our case, we will specify Géi zur Ennto place the sheet to the right of the existing sheet.
3. Wielt d'Këscht aus Schafen eng Kopiea klickt duerno 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 Januar, so the new sheet will be called Januar (2). All contents of the sheet Januar will also be copied to the sheet Januar (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. Plënneren oder kopéieren.

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 Etikett Faarf. 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.