Open the workbook with the data you want to copy
Your worksheet needs to be at the top of your screen, and the one you are trying to copy must be below it (underneath) it. When you open the workbook, it will be at the top of your screen. then go to “File” and “Page Setup”. Then you select what sheet you want to copy data from, and then enter a name for it. After that, on your worksheet below this new file name, click on “File” and “Page setup”, where you can select which sheet is the source for your copied data (this is important!).
Next, click once on your worksheet to highlight it, then on the “Home” tab, click “Cut” (or press Ctrl-X). Then highlight the sheet with your source data and click “Paste” (or press Ctrl-V). Finally, click once in a cell where you want to start entering your copied data.
Select the sheet you want to copy the data from – this is called the source sheet
In this example, we have “people” as the source sheet, but it can be any sheet you want to copy from. 1. Click on the “people” sheet and make sure it’s selected by clicking on it once. You can also select the sheet by using your keyboard arrow keys (left and right to go up and down).
2. Now go to “Data” at the top menu, then click on “Copy”. A new window will pop up showing you what data is being copied from this source sheet to a different destination sheet that we’ll create next.
3. Click on the “A1” cell in the “destination” sheet. This is where we’re going to paste all that data from the source sheet.
4. Click “OK” to copy over all this data from the source sheet to your new destination sheet.
Click on the tab at the bottom of the worksheet that says “Formulas”
This will open up another window of your worksheet that shows all the formulas of that sheet. This way, you won’t miss any information. Make sure you can see the “Formulas” tab at the bottom of your screen.
Title:Click on the tab at the bottom of the worksheet that says “Formulas” [ARTICLE END]
BTW, I took this class specifically to answer your question—and I want to thank you for creating it! It’s very helpful!
Title:How can I do this? [ANSWER BELOW]
How can I do this? The text in the cell below is supposed to be highlighted. See response below. Thanks in advance.
I have this part, but how do I get it to do the same thing when there are 5 or more names in the cell? I want it to highlight the entire cell.
In the Formula bar, type in “=copy” and hit enter
This will copy all the data from your “source sheet” into a new sheet called “detailed info”, as you can see in picture 3. [NOTE: You can copy the whole data of a sheet into one single sheet, if you want to save it for later use. It will look like this in your worksheet:]
Source-sheet: Add the name of your source sheet in square brackets (see picture 3!). [e.g. “=Copy of sheet2”]
Targetsheet: Name of the new sheet – make sure to include the name of your source sheet in brackets too. [e.g., “=Copy of Sheet2”]
After saving, you will see a new sheet called “detailed info” as you can see in picture 4. Go to your “detailed info” sheet and you can now easily transfer the data from your “source sheet” by entering the formula =importrange(“sheet2!$A$1;sheet2!$D$7”) and hit enter. It is important, that the left side of your formula contains the name of your source sheet ($A$1), the right side is the relative column number you want to copy (i.e. “D”) and inbetween you enter the range (e.g., “sheet2!$D$7”).
A small dialog box will appear – in it, make sure that ” destination” is selected and that “A1” is highlighted in the box below it
This is called “the formula bar” and all the cells you highlighted, will be copied over to the specified sheet. To copy 4 cells, highlight them first in the formula bar, then hit CTRL+C to copy, then CTRL+V to paste them into a new sheet. To copy only 2 cells, highlight the first cell with your cursor, then hit CTRL+C. Then move your cursor over to where you want to paste, and hit CTRL+V. [NOTE: To copy & paste the whole range of a column or row which is highlighted, hit CTRL+C first, then navigate the highlighted area in the formula bar, and CTRL+V on the sheet where you want the range to be]
If you need to copy rows or columns from different sheets, then select them in the formula bar, then hit CTRL+SHIFT+C for columns or CTRL+SHIFT+R for rows. This will copy them exactly like if you copied a cell that was highlighted. You can then paste them in another sheet as normal. [NOTE: To copy a range of cells, then edit the first cell in the range, and paste it in another sheet]