The most common thing you often do in Excel copies and paste data. Though you can do this function with a simple command CTRL + C and CTRL + V, however, this command does not always work when you need to perform complex operations.
So, the thing is how to copy and paste objects in Excel?
Don’t worry about the query as we have come up with some easy hacks that you can follow to execute this function. Today, you will get to know how to copy and paste multiple objects from the Excel sheet.
How to Duplicate Objects from Multiple Adjacent Cells?
By applying this duplicate method, you can easily copy and paste objects on other Excel cells. You can use try the following steps to duplicate adjacent cell objects:
- Choose the Excel cell range you need to copy.
- Press and hold the CTRL key from the keyboard.
- Place the cursor on the edge of the selection. The cursor will turn into a plus sign.
- Left-click from the mouse and drag down the cells to the destined place
That’s it!
Whenever you need to duplicate cell data in the same Excel sheet, this method will do wonders. Apart from that, you can even try some keyboard shortcut commands:
These shortcut commands are helpful to duplicate adjacent cell objects:
- Press CTRL + E + S + V + ENTER keys to paste the values only.
- Press CTRL + E + S + F + ENTER keys to paste the Formulas only.
- Press CTRL + E + S + T + ENTER keys to paste the Formatting only.
Remember the sequence of keys while pressing to get the true results.
How to Copy and Paste Objects in Excel with Cell Formatting?
Sometimes, when you need to duplicate the cell formatting to other cells, this method will help you a lot. In this case, you don’t need the content to be copied and just the formatting is needed. For this,
- Select the cell in which you need to duplicate the formatting.
- Press CTRL + C to copy the formatting.
- Choose the cells that needed to be formatted as the original.
- Right-click and select the formatting icon.
All done!
How to Copy and Paste Specific Cell Contents?
This method will more likely be helpful when you need to paste the cell objects with formulas, images, or different numbers formats. You will find it convenient when duplicating data.
Follow the steps:
- Choose the cell range you need to copy.
- Right-click on the selected cells.
- Click on the Copy option from the list.
- Right-click where you need to paste the data.
- Click on the Paste icon and then choose Paste Special option.
- Click OK.
All done!
Remember that if you paste the content over an already-filled cell, you may encounter overwritten data. Therefore, you must be careful in this case.
How to Copy and Paste Objects in Excel without Changing the Format?
Did you ever notice that copying cell data directly will paste the value as it is in the original cell?
It clearly shows that the copied cell might be having formulas, charts, etc. On the other hand, when you don’t need the formatting in the other cell, you can try this method.
Copy & Paste Values without Changing Format in Excel
Let’s see how you can duplicate cell values without changing the format:
- Choose the Excel values you need to copy.
- Right-click on the selected cells and select the Copy option.
- Now, right-click once again on the cell in which you need to content to be pasted and click on the Paste Special menu.
- From the Paste Special screen click on the radio button given as Values.
- Press OK to save changes.
Once the process is completed, the data range will appear in the cells you need them.
Copy & Paste the Formula without Changing the Format in Excel:
In this method, you will get to know how easily you can copy the formula without changing the format. Try the following steps to copy and paste the objects without changing the format.
- Choose the Excel ranges that needed to be copied.
- Now, right-click on the selected cells and choose Paste Special option.
- You will see a new window Paste Special pops up.
- Select the radio button named Formula.
- Press OK to save changes.
To Sum Up:
So, this is it!
You have learned a few ways of copying objects in an Excel sheet and each method is perfectly useful. You can try all of the above methods without any hesitation because each method is tried and tested.
