Copying and pasting data in a spreadsheet cell is the most common task.
With simple keyboard command, you get this work done.
However, the Ctrl+C and Ctrl+V dont work every time to copy cell data.
Especially when youre copying multiple objects at the same time.
But, theres nothing to worry about.
Microsoft offers multiple methods to duplicate values in between Excel sheets.
Keep reading till the end of the article.
Im sure youll find an adequate method for duplicating the Excel data youre looking for.
Usually, Ctrl+C (to copy) and Ctrl +V(to paste) are mostly used.
To avoid that issue, Ive included different methods.
But first, you’re gonna wanna understand the various paste options in MS Excel.
Take a look at the following chart, which should help you duplicate different values.
Youll find these options in the Home tab after copying objects.
punch the drop-down menu beside the Paste option.
Read the following sections to find out the best way to copy and paste Excel data.
Check out our separate post on how toInstall Macro in Excel.
That would help you duplicate data more smoothly.
Heres a complete guide on how toCopy Values Without Formulas on Excel.
Ill share two separate methods to duplicate adjacent cells.
you might choose what suits you the best.
Here are the steps to duplicate adjacent cell objects:
Youre all set.
This method works perfectly when you intend to copy-paste data in the same Excel sheet.
Also, you have the opportunity to use quick keys to duplicate the cells.
Try these useful Keyboard Shortcuts for Copy Paste:
Press these keys one after another.
But remember to hold the ctrl button while you press other keys.
Check out our separate post onFix Microsoft Excel Freezing or Slow.
Also, press Ctrl + R to paste the data into the right column.
However, try the following technique to copy a single value into multiple cells.
Alternatively, you’re able to use a formula:RANDBETWEEN(Bottom, Top).
But in case youre not planning to use random values, I strongly suggest not using that formula.
Also, you’re free to use the fill handle for quick copy-paste.
Just hold the plus sign from the cells edge and drag it down.
Heres a complete guide on how toLock and Unlock Cells in Excel.
This means that the cells that you copied might contain different formulas, data charts, etc.
Here are the methods to copy-paste cells without changing formats:
1.
Read more on how toExcel Documents Open in Notepad on Windows 11.
Try following these steps to copy-paste objects without modifying the format.
I use these methods whenever I need duplication of data in an Excel sheet.
If you have any questions regarding this topic, read the following passage.
Frequently Asked Question
How do you copy an object in Excel?
How do you copy all objects in Excel?
Open your Excel sheet > On the Home tab, click Find & Select > select Go To Special.
That will paste values into multiple excel columns.
How do I copy and paste a picture in Excel?
No matter whether youre using Windows or Mac, you will be able to copy-paste objects more quickly.
And also, share which of these techniques helped you to duplicate Excel data.
Till then, peace!
