what are the two methods to copy the data in excel
Answers
Answer:
Explanation:
As a precaution, I like to press CTRL+ALT+F9. This forces the spreadsheet to recalculate all cells in case auto-recalculate was turned off.
Click the top cell of the column you wish to copy. In this tutorial, it would be C1.
Press CTRL+SHIFT+ the down arrow key to select the column.
Click the Copy button from the Home tab on the ribbon.
paste-values2
Click the bottom part of the Paste button on the toolbar, and then select the Paste Values button.
paste-values3
his method is a little trickier, but I think you’ll agree that it’s the easier solution.
Follow Steps 1-3 in Method 1.
Move your mouse cursor to the far right of the cell until it changes to a four-headed arrow.
paste-values4
Press your right mouse button and drag the column to the right. (Don’t worry if it looks like you’ve shifted cells up or down.)
paste-values5
With the right mouse button still pressed, drag the column back onto itself and let go of the mouse button. A new menu should appear.
From the context menu, choose Copy Here as Values Only.
paste-values6
1st- Click the copy button from the home Tab on the ribbon
2nd-click the top cell of the column you wish to copy. In this tutorial it would be C1.
It's the right answer