Microsoft Excel is a fairly powerful tool due to the study it does with the data, this has led it to become a very popular software for the financial and accounting sector . It has improved intelligence, since it allows you to create and edit files, run graphics, make spreadsheets, optimize formulas and much more, in a very practical and simple way.
As in any program of Microsoft Office , sometimes there is a need to make a copy paste so as not to have to transcribe the information back to the destination location. So these actions over time have become essential for those who work with a computer, thus being automated instructions.
It has become so widespread that it became fundamental when composing and restructuring any document. If you still do not know how to do this, in this tutorial we will explain step by step the processes that you must do to be able to do it and fill with cells cells in Excel . We will also show you how to solve the problems when this has been blocked.
Index:
Steps and methods to copy and paste the contents of cells in Excel
The main objective of copy and paste is to save you time when manually writing a text. That is why we will detail below the different methods to do it from the different computer shortcuts. Discover all the Excel commands in this part .
Keyboard shortcuts for copy and paste
If you will do this repeatedly, it is best to look for a more comfortable way to do it without having to use the mouse. We will help you make the process even simpler than it already is, just by selecting the text you want. In this case the Ctrl key will be the protagonist of all shortcuts.
- Ctrl + C: This command is used to copy the cells you have selected to place them in another place or destination.
- Ctrl + X : It is manipulated to cut the chosen cells and proceed to save them to the clipboard.
- Ctrl + V : With this you will be able to paste the cells that are inside the clipboard group wherever you want.
From the options bar
Another way to execute it is through the options bar, there are all the elements that make up Excel, including the most basic ones such as copy, cut and paste . When you select the content you want, it is deposited in a buffer memory, called clipboard .
- The first thing you will have to do is select the “Start” option.
- Then, choose “Clipboard” and then proceed to click on “Copy”, to duplicate the cells or the chosen content .
- Once all the data has been copied, you must select the box where you want to move them and press “Start” > “Clipboard”> “Paste.”
Using drag and drop
With this type of method you do not need to be an expert in Excel , because it is quite fast and simple to manipulate, an alternative that allows you to perform this interface. You just need to select and slide to Where do you want the text attached?
- First you have to select the range of cells that you want to copy and cut.
- Press the left mouse button on your computer to limit the rank and then move it to its new position.
- Then, simply you will have to release the mouse button to the place where you want take the data.
- Finally you have to know that before releasing the mouse you must press the Ctrl key + click with the mouse.
From the fill controller
This type of method is the one that allows you to copy a set of data into continuous cells for ease. It is visualized with a small black box that is located in the lower right corner and that when placing the courses on it, changes to a cross.
- The first thing you should do is select the cell and fill in the adjacent ones.
- Double-clicking the fill controller will copy the selected range down to locate a cell with content.
- In this way the formula will be automatically copied with its respective calculation.
In the same way you can do it with this process, which allows you to achieve it quickly. You will only need to right-click your computer to see the context menu.
- Select the cells and click with the left button of the mouse on top of it.
- Then choose the option that indicates “Copy or cut ”.
- Choose the destination that you have decided to transfer the data.
- Again click the left mouse button, but this time to choose potentiallyPegar†.
How to copy and drag Excel formulas into another cell or spreadsheet ?
If for some reason you want to copy and drag Excel formulas to another column or spreadsheet, you can choose specific pastes in target cells.
- Choose the cell that has the formula that you want to copy.
- Click “Start” choose “Copy ” or use the shortcut Ctrl+C.
- Now, on the same or another sheet, you have to press and click on the cell in the one you want to place.
- In order to paste the formula with its format, you will have to click on “Start”> “Paste” or also with Ctrl + V.
How to solve the problem when Excel crashes when copying and pasting and not answer?
We have already seen all the steps and different methods that you should use to be able to copy and paste in Excel but, How can you do to solve the problem when the application crashes when trying to do it and does not respond? strong> Next we’ll mention how to solve it.
Test the recovery of MS Office applications span >
This option may allow you to save your documents when the program has this error, so you don’t lose what you have done. You will also be able to recover files that were not saved at the indicated time.
- Go to the “Start” menu of your computer > “ All programs “> “Tools Microsoft Office “ >” MS Office application recovery. “
- Now you must select the document that does not respond. li>
- Then click on “Recover application” and rescue the document.
Using the Microsoft Office self-recovery
Previously Excel had a Autosave option, but for a few years this was supplanted by self-recovery. This causes the documents made in this interface to be saved with a backup copy. So if they close unexpectedly, it recovers the file:
- Go to “File” then “Information” and then “Manage versions”. There you can examine the backup copies of the unsaved files.
- Locate the Excel workbook and click where it says “Open” and ” Save ”.