How to Transfer Data From One Sheet to Another in Excel

Techwalla may earn compensation through affiliate links in this story.
Image Credit: BananaStock/BananaStock/Getty Images

Working with data in Microsoft Excel is not always easy to do. Formulas and functions can make even the simplest task seem challenging, even if, in reality, it isn't. Some people might use Excel at a very basic level: keeping all of their data on one sheet, not labeling columns or rows properly, or ignoring some settings (such as formatting) that can make data management much easier. Managing data in multiple sheets is one organizational strategy. Fortunately, transferring data from one Excel sheet to another is simple and easy. All it takes is a few clicks. If you're someone who wants to better manage Excel files, you can follow these steps to divide your data and save it in different sheets within the same file.


Step 1

Open the Excel file with which you want to work.

Video of the Day

Step 2

Highlight the rows and columns that you want to move.

Step 3

Click "Edit" and then click "Cut."


Step 4

Click "Insert."

Step 5

Click "Sheet."


Step 6

Click "Blank Sheet."


Step 7

Click the mouse in the first cell of the new sheet.

Step 8

Click "Edit" and then click "Paste." The highlighted contents from the first sheet have been moved to the second sheet.



Report an Issue

screenshot of the current page

Screenshot loading...