- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Auto Copy and Paste Cell in the Current Sheet or From One Sheet to Another in Excel?
Sometimes we want to use the same data that is already present in the Excel sheet. Instead of tying data again, we can copy it to other locations. When dealing with large amounts of data, or even small amounts of data, this could save us a lot of time. The copying can be done within the sheet or between the sheets that are present in the same workbook.
Read this tutorial to learn how you can autocopy and paste cells in the current sheet or from one sheet to another sheet in Excel.
AutoCopy and Paste Cell in the Current Sheet
Here we will enter the cell address of a single cell and use the auto-fill handle to copy all the data. Let us see a simple process to automatically copy and paste cells in the current sheet in Excel in a faster and more efficient way.
Step 1
Consider an excel sheet containing data similar to the data shown in the image below.
Now click on an empty cell, in our case D1, and enter the formula "=A1" in the formula box, then click on Enter to copy the text of cell A1 into it as shown in the below image.
Step 2
As we can see, we have copied text from A1 to D1. We can also copy all the other data by dragging from the right corner, and the final output will be similar to the below image.
AutoCopy and Paste Cell from One Sheet to Another
Here we will enter the cell address along with the sheet name to copy the data. Let us see a simple process to automatically copy cells from one sheet to another in Excel.
Step 1
Let us consider the same data that we used in the above example.
Now, in the other sheet's cell A1, enter the formula "=Sheet1!A1" and press Enter to get the first result, as shown in the image below.
Step 2
As we can see, we have copied text from A1 to D1 of the new sheet. We can also copy all the other data by dragging from the right corner, and the final output will be similar to the below image.
Conclusion
In this tutorial, we used a simple example to demonstrate how we can auto-copy and paste cells in the current sheet or from one sheet to another in Excel to highlight a particular set of data.
5K+ Views
