Learning to use all the tools that the popular spreadsheet has is a goal to keep in mind if it is used a lot, so we could start by knowing how to divide and duplicate in Excel.
While many of the options can be learned as you go, having extra help or guidance doesn’t hurt anyone. From using the database BASE function in Excel to simply using the CODE function in Excel, learning is always necessary.
Learn how to divide a sheet in Excel!
When talking about dividing in this worksheet, it is referring to dividing the panels within a sheet. First, the spreadsheet should be easily created in Microsoft Excel.
In this way, and as the main result, by dividing said page into panels, said sections can be moved independently.
Then, to achieve this, you will have to select just below the row where you want to apply the aforementioned division.
If it is a column, you must choose on the right side where you expect to create the segmentation.
Next, it is located and clicks on the tab called ” View “, located in the upper green panel, it is generally the eighth option.
Within this, a section dedicated to the ” Window ” options will be positioned, on the right side, it will be clearly visible.
Therefore, to continue the step by step, you will choose the button called ” Divide ” so that Excel makes the selected change.
If, on the other hand, what you want is to reverse or eliminate fragmentation in panels of the sheet, it will be enough to go to the same menu and click on “ Divide ” again.
What remains is for the person to apply the knowledge, since we have seen the first part of this tutorial to know how to divide and duplicate in Excel.
Duplicate in Excel
There are several ways to generate a duplicate of a page or workbook in Excel, generally, these are included in the included ” Move ” or ” Copy ” commands.
Move to a new book
This means from one file to another, you will need to have both locations open. That is the sourcebook and the receiver.
Next, the page to be duplicated is located and with the right-click, it is held down on the corresponding tab. Then, you will simply have to drag to the new book and search to place or insert it in the tab section of the same.
In this way, if it is positioned correctly, it should move satisfactorily and thus it will have been easily duplicated.
Copy in the same book
Now, if what you want is to copy or move a sheet within the same book, there are several ways to do it.
The first consists of using the ” Ctrl ” key on the keyboard, keeping it pressed, and dragging the desired tab to another place in the page panel.
Consequently, when you release the button and click, you will have an exact duplicate of the sheet, with the difference that the name will have a “ (1) ” next to it, or the corresponding number.
On the other hand, when you right-click on the sheet that you want to move or copy, its options will open.
Of all these, there will be a call ” Move or Copy ” which must be pressed to expose the settings menu.
At this point, you will decide where you want to move or copy, it all depends on the interests and needs of each user.
Finally, at the end of the window, there will be a checkbox with the option ” Create a copy ” and then click on ” OK “, and in this way, the sheet will have been duplicated.
Although it has already been mentioned that one of the best ways to learn to use this tool is through trial and error, with this guide you will have already gone a long way in learning to divide and duplicate in Excel.