Move or copy di excel 2022 tidak berfungsi

Terakhir Diperbarui: 6 Desember 2017

MASALAH

Ketika mencoba menyalin lembar dalam buku kerja yang sama, lembar akan dipindahkan, bukan diduplikasi.

Hal ini merupakan bug yang terdapat pada Excel 2016 versi pratinjau [16.0.4229.1002]. Bug ini telah diperbaiki dalam versi yang dirilis secara resmi [RTM]. Tidak ada rencana untuk memperbaiki bug ini dalam versi pratinjau.

STATUS: DIPERBAIKI

Untuk memperbaiki masalah ini, lakukan hal berikut:

1. Hapus instalan versi pratinjau Office. Masuk ke Panel Kontrol, kemudian Program dan Fitur, klik kanan produk Office, lalu pilih Hapus Instalan. Untuk informasi selengkapnya, lihat Menghapus instalan Office dari PC.

2. Instal Office versi rilis [RTM]. Buka Pusat Layanan Pelisensi Volume, lalu instal Office Professional Plus 2016, atau aplikasi Office mandiri Anda.

3. Aktifkan pembaruan otomatis. Anda juga dapat memeriksa Pembaruan Publik terkini dalam Office Pembaruan, untuk mendapatkan informasi tambahan tentang metode instalasi lainnya.

Sumber Daya Lainnya

Tanyakan kepada ahlinya

Terhubung dengan para ahli, diskusikan praktik terbaik, pembaruan, dan berita terkini Excel, serta baca blog kami.

Komunitas Teknologi Excel

Dapatkan bantuan di komunitas

Ajukan pertanyaan dan temukan solusi dari Agen Dukungan, MVP, Teknisi, dan pengguna Excel lain.

Forum Excel di

Sarankan fitur baru

Kami sangat senang membaca saran dan umpan balik Anda! Bagikan pendapat Anda. Kami mendengarkan.

Berikan umpan balik

Lihat Juga

Perbaikan dan solusi untuk masalah terkini di Excel untuk Windows

You can move or copy a worksheet in the same workbook to organize your workbook exactly how you want.

Move a worksheet within a workbook

• Select the worksheet tab, and drag it to where you want it.

  Caution: When you move a sheet to another workbook, check any formulas or charts that refer to data on the sheet because moving the sheet might cause errors or produce unintended results in your data. Similarly, if you move a sheet that is referred to by 3-D references, the calculation might include or leave out data on the sheet.

Copy a worksheet in the same workbook

• Press CTRL and drag the worksheet tab to the tab location you want.

OR

1. Right click on the worksheet tab and select Move or Copy.

2. Select the Create a copy checkbox.

3. Under Before sheet, select where you want to place the copy.

4. Select OK.

Move a sheet

• Drag the sheet tab to the location that you want along the row of sheet tabs.

Copy a sheet

1. Hold down OPTION.

2. Drag the sheet tab to the location that you want the copied sheet to appear along the row of sheet tabs.

   Important: Release the mouse button before you release the OPTION key.

Move a sheet to another workbook

Caution: When you move a sheet to another workbook, check any formulas or charts that refer to data on the sheet because moving the sheet might cause errors or produce unintended results in your data. Similarly, if you move a sheet that is referred to by 3-D references, the calculation might include or leave out data on the sheet.

1. Open the workbook that you want to move the sheet to.

2. On the Window menu, click the workbook that contains the sheet that you want to move.

   Click the sheet that you want to copy to the other workbook.

3. On the Edit menu, click Sheet > Move or Copy Sheet.

4. On the To book menu, click the workbook that you want to move the sheet to.

   Tip: To create a new workbook that contains the moved sheet, click new book.

5. In the Before sheet box, click the sheet that you want to insert the moved sheet before, or click move to end.

6. Click OK.

Copy a sheet to another workbook

1. Open the workbook that you want to copy the sheet to.

2. On the Window menu, click the workbook that contains the sheet that you want to copy.

   Click the sheet that you want to copy.

3. On the Edit menu, click Sheet > Move or Copy Sheet.

4. On the To book menu, click the workbook that you want to copy the sheet to.

   Tip: To create a new workbook that contains the moved sheet, click new book.

5. In the Before sheet box, click the sheet that you want to insert the copied sheet before, or click move to end.

6. Select the Create a copy check box.

7. Click OK.

Change the color of a sheet tab

Coloring the sheet tabs can help you keep track of your information in a large workbook.

1. Hold down CONTROL and click the sheet tab.

2. Click Tab Color, and then click the color that you want to use.

If you have elements in your worksheet that interfere with duplicating it, you can still create a copy of the worksheet manually by copying all the data and pasting it into a new sheet. Here's how:

1. Select all the data in the worksheet.

   Keyboard shortcut: Press CTRL+Spacebar, on the keyboard, and then press Shift+Spacebar.

2. Copy all the data on the sheet by pressing CTRL+C.

3. Click the plus sign to add a new blank worksheet.

4. Click the first cell in the new sheet and press CTRL+V to paste the data.

   Note: You will lose any conditional formatting applied to the cells when you paste them into the new worksheet.

In Excel for the web, the option to move or copy a sheet isn’t available when you right-click a sheet tab, as it is in the Excel desktop application. In Excel for the web, you can achieve the same result by copying all of the data in the worksheet and pasting it into a blank worksheet in the other workbook.

Follow these steps to move or copy a worksheet to another workbook in Excel for the web:

1. Select all the data in the worksheet.

   Keyboard shortcut: Press CTRL+Spacebar and then press Shift+Spacebar.

2. Copy all the data on the sheet by pressing CTRL+C.

3. Open the workbook in which you want to paste the data, then click the + in the status bar to add a new blank worksheet. 

4. Click the first cell in the new worksheet, then press CTRL+V to paste the data into that worksheet.

   Note: You will lose any conditional formatting applied to the cells when you paste them into the other workbook.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.