How to split and duplicate a spreadsheet in Excel

Excel is a program that allows you to perform calculations for various areas, from creating a company budget to education. In some situations your spreadsheet will be overwhelmed with data and you will have to check information from distant columns . Therefore, in this article we will give you the instructions to split and duplicate a spreadsheet.

How to Split and Duplicate a Spreadsheet in EXCEL – Steps to Follow

Index( )

1. In which case you might need to duplicate and split a sheet in Excel?
2. What steps do I need to follow to split a spreadsheet into two pages?
   1. To split vertically
   2. Split the screen horizontally
3. What is the course to follow to duplicate an excel sheet multiple times?
4. Is it the same procedure for Excel 2016 and 2019?
5. How to know what version of Microsoft Office is installed on my PC?

In which case you might need to duplicate and split a sheet in Excel?

When working with spreadsheets with too much data that involves moving from one tab to another to review data, formulas or references can complicate the work, for this type of case it is useful to duplicate or divide an Excel sheet in order not to spoil the work developed and that some data is not moved gives you the option to lock the column.

What steps do I need to follow to split a spreadsheet into two pages?

• Open the Microsoft Excel workbook.
• In the options bar, left click and select the customize ribbon option.
• Go to the right side of the pop-up window and enable the scheduler option.
• The developer tab will appear on the ribbon.
• Choose the Visual Basic option.
• A list of sheets will be displayed, scroll to the bottom and choose ThisWorkbook.
• Select the option view code and copy:
• Before running the codecreate a new folderto save the file.
• Run the code by pressing the F5 key.
• If you check the folder where you saved the initial document, youwill see several files depending on the number of sheets that the document has.

to split vertically

• Select a particular column in your Excel document.
• In the list of options, specifically in the “View” tab, click on the split option.
• The division will be to the left of our selection, that is, if you select column B of the document, the division will be up to and from column A.
• Excel will give you horizontal scroll bars on both slices to navigate across the sheet.

Split the screen horizontally

• Select the row in the position where you want to create the division, for example if we select row number 5 the division will be made up to row number 4.
• Click on the view tab in the list of options and choose the split option.
• Each area of ​​the 2 createdcan be moved independently of the other , however if you make changes in one it will be reflected in the other because remember that you are editing the same document.

What is the course to follow to duplicate an excel sheet multiple times?

• Locate yourself in the Excel sheet that you want to copy.
• Select the sheet tab and press the Ctrl key,drag the sheet with the mouse to where you want to position the duplicate.
• You can also use external applications such as the so-called Optipe Data Tools Suite add-on, for that you must download it from its official site. Once downloaded, it will appear in the options tabs as “optipe”, select separate into sheets, choose the Codc field and choose the fieldsto duplicate.

Is it the same procedure for Excel 2016 and 2019?

Indeed, you must do the same procedure for both versions , because despite the fact that they are different versions, they differ only in links to email, more applications, changes or improvements; however, the operation remains practically the same.

How to know what version of Microsoft Office is installed on my PC?

• When executing the Microsoft Office program,the version will automatically appear on the front page of the program .
• Select the control panel and select programs, among the various programs that your computer contains you will get the Microsoft Excel that you have installed and its version.
• In your Excel document, choose the “file” tab, a menu will be displayed on the left, select the help option or my account to accesscomplete information related to the version of your Microsoft Office.

In conclusion, this article will help you to empty data in different sheets with the same format without having to waste time preparing and configuring information from scratch , such as: Settlements, academic qualifications, evaluation formats, among others.