របៀប Copy Sheet ទាំងមូលចូល Excel ផ្សេង How to copy the entire sheet to another excel (video in khmer)

Hello everyone! In this video tutorial, you will learn how to copy an entire worksheet from one Excel file to another Excel workbook step-by-step.

Usually, many people select the entire sheet (Ctrl + A), copy (Ctrl + C), and paste (Ctrl + V) into a new file. However, we do not recommend this method because it loses column widths, row heights, page setup settings, and can break formula references when you have a lot of data!

📚 Related Tutorial: Want to master Excel keyboard shortcuts? Check out Learn All Excel Keyboard Shortcuts!

🛠️ Step-by-Step Guide

Method 1: Use the "Move or Copy" Feature (Recommended)

1. Open both the source Excel file and the target Excel file.
2. Right-click on the sheet tab at the bottom that you want to copy.
3. Select Move or Copy... from the context menu.
4. In the To book drop-down menu, choose the destination Excel file.
5. Select where to place the sheet under the Before sheet list.
6. ✅ Important: Make sure to check the Create a copy box (otherwise Excel will move the sheet instead of duplicating it!).
7. Click OK.

Method 2: Fast Drag-and-Drop Shortcut

1. Open both Excel files and arrange them side-by-side on your screen.
2. Press and hold the Ctrl key on your keyboard.
3. Click and drag the Sheet Tab from the source file to the destination workbook window.
4. Release the mouse button first, then release the Ctrl key.

💡 Pro Tips

1. Preserve Formatting & Print Setup: Using Move or Copy... keeps all original column widths, row heights, print settings, and chart formatting 100% intact without manual adjustments.
2. Copy Multiple Sheets at Once: Hold Ctrl (to pick specific sheets) or Shift (for a range of sheets) to select multiple sheet tabs at the same time, then right-click to copy them all together.
3. Duplicate Sheet in the Same File: Hold Ctrl and drag any sheet tab left or right to quickly make a duplicate copy inside the current workbook.