How to Copy Sheet in Excel

By

In this blog post, we will see how we can copy sheet in excel. To explain in detail, we will open new excel file which have 03 worksheets in it.




There are two methods by which we can copy the sheets:

1. By using Format command
2. By using Mouse Right Click



1. By using Format command:

In this method we use format command to copy the selected sheet. Following steps will give you clear idea about how we can copy the sheet in excel.

1. Select the sheet which we want to copy. (In this case “Sheet1”).



2. Go to “Home Tab”. Select format command under “Cells group”. Select option “Move or Copy Sheet”.



3. “Move or Copy” dialog box will open. Select the sheet in this dialog box before which we want to copy selected sheet. For example if we want to copy selected sheet before sheet3 then select “Sheet3” and Check the checkbox for “Create a Copy”.



4. We can see Selected Sheet (i.e. Sheet1) is copied before “Sheet3”.



5. Select “Move to end” option if we want to copy the selected sheet at the end of all sheets and Check the checkbox for “Create a Copy”.



6. We can see that selected sheet “Sheet1” is copied to end.




2. By Using Mouse Right Click:

1. Place the cursor on the sheet which we want to copy. (Sheet1 in our case). Press Mouse Right Click button. Select “Move or Copy” option from the list of appeared options.



2. “Move or Copy” dialog box will open. Select the sheet in this dialog box before which we want to copy selected sheet. For example if we want to copy selected sheet before sheet3 then select “Sheet3” and Check the checkbox for “Create a Copy”.


3. We can see Selected Sheet (i.e. Sheet1) is copied before “Sheet3”.



4. Select “Move to end” option if we want to copy the selected sheet at the end of all sheets and Check the checkbox for “Create a Copy”.



5. We can see that selected sheet “Sheet1” is copied to end.



If you have any queries on this topic then you can write in comment box below.
Microsoft Certified Excel Expert, Enthusiastic to teach excel tricks and basic excel concepts which will help to save time and efforts in our daily office work.

Comments

Post a Comment

Related Topics..

Fill Up, Down, Right & Left in Excel

By
Image
Excel has many great tricks which can help us to save our time while working on big data. In this blog post we are going to see one of those tricks where we can fill the data to the upwards of the selected cells, to the downwards of the selected cells, to the right of the selected cells and to the left of the selected cells. There are many situations where we may need to copy the data from selected cell to the upward, downward, left and right cells. But how can we do so?? In excel we can do so with the help of “Fill” command. This command we can found in: Home Tab --> Editing Group --> Fill Command. Let’s take an example. We have inserted a text “Tejraj” in a cell “D5”. Now we will see how to fill this text from cell D5 to Up, Down, Right & Left. Fill Down: 1. Let’s assume that we have to fill the data from cells D5 to D10. For this, select the Cell Range D5:D10. Keep in mind that the data from 1st cell of the selected Cell Range will fill down in entire selection. 2. Select ...
Read more

Select all cells highlighted with specific color at a time

By
Image
Many times we apply colors to cells in excel sheet which will help us to identify important cells just by looking at the data. But what if we use multiple colors to highlight data and later on want to select all the cells which are highlighted with specific color only???  YouTube Video: For example, we have listed some values in excel sheet and highlighted few cells with red color and few cells with yellow color. Now, we want to select all cells which are highlighted with only yellow color at a time. But how????  Don't worry... We will provide you a fantastic solution for this!! Follow below steps:  1. Select entire data. 2. Press Ctrl + F. "Find and Replace" window will appear. 3. Click on Options button. 4. "Find and Replace" window will expand with some additional options. Click on Format button. 5. "Find Format" window will appear. Click on Fill tab and select yellow color. You will s...
Read more

Title Bar in Excel

By
Image
Title Bar is the bar holding title of the excel file. But apart from showing title, it also contains many other important functionalities. so let's get familiar with Title Bar in this blog post. Title Bar is divided in 03 parts: 1. Quick Access Toolbar 2. File Name 3. Minimize, Maximize/Restore, Close buttons Let’s see in detail about this. Quick Access Toolbar:  The commands which we are using frequently can be added to Quick Access Toolbar. Following steps will help you to add desired commands here. 1. Right click on the desired command. (In below screenshot we have selected “ Format Painter ” as a desired command) 2. Select option “Add to Quick Access Toolbar”. 3. Now, you will see “ Format Painter ” command is added in the Quick Access Toolbar. 4. To remove desired command from Quick Access Toolbar, just right click on the command and then select option “Remove from Quick Access Toolbar”. 5. No...
Read more

Bold, Italic and Underline Commands from Font Group

By
Image
Bold, Italic and Underline… These three commands are very basic but very important and frequently used in excel. These commands can be found under Font Group. YouTube Video: Let us have detailed description about these commands..!                                              Bold : If we want to change our text into Bold format, then we can use this command. Keyboard shortcut to use this command is Ctrl+B. In below image we have inserted a sample text in cell A1. If we click on the Bold icon from font group or use keyboard shortcut Ctrl+B, then the text from cell A1 will convert into Bold as shown in below image. Italic : If we want to convert our text into Italic format, then we can use this command. Keyboard shortcut to use this command is Ctrl+I. In below image we have inserted a sample text in cell A1. If we click on the Italic icon...
Read more

Insert Multiple Rows in Excel Based On Cell Value

By
Image
In this blog post we will learn to Insert Multiple Rows in excel based on cell value with the help of VBA Code. For this we have prepared dummy data as shown in below image. In this data we have listed few “Products”, their “Quantities” and their “Unit Price”. Now we want to insert multiple rows based on their “Quantities”. For example, “Product 1” has 04 quantities so we have to add 04 rows below the Product 1, “Product 2” has 02 quantities so we have to add 02 rows below the Product 2 and so on. To avoid wasting our time by manually inserting rows one by one, we can use VBA code which will do our work within seconds. To do this, just follow the below steps: 1. Add “Developer Tab” on the Ribbon if it is not already added. If you are not aware about how to add Developer Tab on the Ribbon then click here . Once added on the Ribbon, “Developer Tab” will looks like as highlighted with red in below image. 2. Now, click on the “Visual Basic” command as highlighted in below image. 3. Once ...
Read more

Text Orientation in Excel

By
Image
Whenever we want to adjust our text in a narrow cell, we can use Orientation command in excel. With the help of this command, we can rotate the text clockwise, counterclockwise, upward downward etc.  YouTube Video We can found this command in Alignment group under Home tab. If click on the orientation command icon. You will see a dialogue box with below options appear on your screen. There are 05 options we can see in the above dialogue box. 1. Angle Counterclockwise 2. Angle Clockwise 3. Vertical Text 4. Rotate Text Up 5. Rotate Text Down So let's see how to use this command.  First select the text where we want to apply the orientation. As an example, we have inserted a text "Excel Tricks with Tejraj" in a cell and we will apply all these orientation styles to these text: 1. Angle Counterclockwise: This option will help us to rotate the text counterclockwise within a cell. Select the text to which we want to apply Orientation st...
Read more

PI Function in Excel

By
Image
In this blog post we will learn to about PI function in excel. PI function will return value of Pi which is mathematical constant which has value of 3.14. The PI function in excel return the value of Pi accurate to 15 digits. Importance of PI Function? Pi can be used to solve many mathematical problems. So if you are thinking to solve some mathematical problems for example to “calculate area of circle” or to “calculate the circumference of circle” (these are just few examples) then you can use the PI function effectively. Where to find PI function on Excel Screen: PI function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. PI function is highlighted in blue in below image. Once we click on PI option as highlighted above, we will get the function argument dialog box as shown ...
Read more

Excel Shortcuts Ctrl A to Ctrl Z

By
Image
Use of keyboard shortcuts while working in excel will be a great help for us. It will save a lot of time. In this post we are going to see Excel Keyboard Shortcuts for alphabets A to Z while using Ctrl key. Below table will give you a brief idea for each shortcut and its functionality: Now, we will see in detail how each of above listed shortcut combinations will work: Ctrl + A :  It will select all content present on the worksheet. If active cell is in the table then it will select entire table. Ctrl + B :  It will convert selected text into Bold . Ctrl + C : It will copy the selected content. The content which is copied can be seen in the Clipboard. Ctrl + D :  It will fill down the content from upper cell. For example we have inserted a number “1” in the cell A1. If we select the cell range from A1:A5 and press Ctrl + D, then this number “1” will automatically fill down in the entire cell range . ...
Read more

Inserting Image into Shapes in Excel

By
Image
We have already learned about Inserting Shapes as well as Inserting Images in excel. Now, in this blog post we will learn about inserting images in shapes in excel. We will learn to insert an image (which is logo of our website “ Excel Tricks with Tejraj ”) into various shapes. First we will insert the shape in excel and then we will insert the logo into inserted shape. Insert Image in Oval Shape: First, click on “Insert” tab and then click on “Shapes” command. Once we click on “Shapes” command, we can see various shapes available in excel. Out of these, you can select any shape as per your choice. In this case, we want to select the “Oval” shape. If you are not aware about the names of these shapes, then you can just place the mouse cursor on any shape which will automatically show the name of that shape. Once we click on the “Oval” shape, the shape of mouse cursor will change from doctor symbol to plus symbol. As soon as the mouse cursor symbol changes to plus symbol, we can draw ...
Read more

Conditional Formatting:Highlighting Above Average and Below Average Values

By
Image
This blog post is continuation to our series of posts on “Conditional Formatting”. In this blog post, we will learn about highlighting values which are “Above Average” and “Below Average” of the selected values. To learn this post in an easy way, I have randomly listed few numbers as shown in below image. We will learn how to highlight the numbers which are above the average of all the selected numbers and which are below the average of all the selected numbers. For your easy understanding I have already calculated average value of all these numbers numbers (Which is 65). This will help us to easily cross check our output. Highlighting Above Average Values: Select all the values from which we wish to highlight the “Above Average Values”. Go to Conditional Formatting (which is available in Home Tab under Styles group) and select “Above Average” option as shown in below image. “Above Average” dialog box will appear on screen. Select the Formatting style from available list and hit OK but...
Read more