Birthday Cruise Favors

create an exact copy of another sheet

Sometimes we want to copy information or format of an Excel worksheet to another, hoping that the other is copied EXACTLY the same. This would be an option:


Step 1. Go onto the Excel worksheet you want to copy. BILL 1 will call in this example.

Step 2. Right click on the tab where you will find the name of the sheet. In this case, right click on the name BILL 1. At the moment, it will display the shortcut menu, which must choose Move or Copy ( copy or move according to the example of the image).

Step 3. Once you have chosen Move or Copy option a new window will appear. It will total leaf containing your book.

must choose which position in the list you want to display your copy, ie, do you want to appear to the left or right of the original sheet? Or do you want the blade to move at the end or is located a few leaves below or further back?

Continuing with the process, select the sheet at their convenience and select the Create a copy box ( create a copy under the image).

Step 4. Once you create the copy, we just change the name ( Right clicking> rename ) or to relocate again if we consider necessary ( sustained By clicking the mouse on the road and moving left or right ).

Step 5. Ready , the sheet has been created as an exact replica of the INVOICE Original Sheet 1 ahorta and has a clone called BILL 2.

Notes:

• To add color to the tab alone: \u200b\u200b Right click the mouse> Color Palette> select desired color.
• To copy several pages simultaneously staring Press CTRL while clicking while going with the mouse cursor leaves that need to create a replica> then follow the 5 steps of this tutorial.

Posted by: Julio Rosales V .