How To Divide And Duplicate An Excel Worksheet Or Workbook? -Step By Step

 icon and background excel spreadsheet

Learn to use all the Tools with which account known spreadsheet is a goal to consider whether this is widely used, so we could start knowing how to divide and replicate in < strong> Excel .

Splitting and duplicate a worksheet or workbook in Excel -Step by Step

You may also be interested in:

While many of the options can be learned on the fly, to have a guide or extra help does not hurt anyone. From use the BASE database function in Excel to simply use the CODE function in Excel , it is always necessary to learn.

In addition, there are users who are complicated when performing any work on Excel , but still are the need to do so.

Learn to divide an Excel spreadsheet!

A split talking about this spreadsheet , reference is made to divide the panels into a sheet. First, you must easily create the spreadsheet in Microsoft Excel.

In this way, and as a main result, the page dividing panels that can be moved independently these sections.

So to get it, you will have to select the row just below where you want to apply the splitting.

In case of a column, you must choose the right side of which is expected to create segmentation.

Then it is located and press on the tab labeled « Vista «, located in the green top panel usually is the eighth choice.

Within this, a section on options « Window » in the right side you can clearly see will be positioned.

So, to proceed step by step, we will choose the button labeled « Split » Excel to perform the selected change.

 excel document blacno

If, on the other hand, what is desired is to reverse or eliminate fragmentation panels sheet, simply go to the same menu and press again on « Split

What remains is that the person apply knowledge, since we have seen the first part of this tutorial to learn how to divide and replicate in Excel.

Excel Duplicate

There are several ways to generate duplicate of a page or book in Excel, usually these are included within the commands « Move » or « Copy » including.

Move to a new book

This means from one file to another, for this need to have open both locations . That is, the source workbook and the receiver.

Then the page you want to mirror and right click is held down on the tab & nbsp are located;. Then simply need to drag to the new book and search for place or insert into the section tabs on it.

This way, if positioned properly, you must move satisfactorily and thus be achieved easily duplicate it.

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 this.

The first consists of using the « Ctrl » of the keyboard, key press and hold and drag the desired place to another panel tab pages.

 Excel options

Consequently, the release button and click will feature an exact duplicate of the sheet, with the difference that the name will carry a « (1) » next to it, or the corresponding number.

On the other hand, giving the right click of the mouse on the sheet you want to move or copy, the same options open.

Of all these, there will be a call « Move or Copy » which should pressure the settings menu stated.

Already at this point, did decide where you want to move or copy all depends on the interests and needs of each user.

Finally, at the bottom of the window, there will be a checbox with the « Create Copy » option to then take on « OK » and so will have managed to double sheet.

Although already mentioned that one of the best ways to learn to manage this tool is by trial and error, with this guide will already have come a long way learning to divide and replicate in Excel.

How useful did you find this content?

Click on a star to rate!

Average score 0 / 5. Counting of votes: 0

So far, no votes. Be the first to rate this content.

I'm sorry this content was not useful for you!

Let me improve this content!

Tell me, how can I improve this content?

You may also be interested in:

Deja un comentario