0
In Excel how do you copy the same cell IE - D15 from multiple tabs to one tab?
Wiki User
∙ 14y ago
You cannot actually copy something from several sheets at the same time. You can only copy them one at a time. However, if you want to total them, then you could use the formula like this in the new worksheet. Assuming, for example, that the others are Sheet1, Sheet2, Sheet3 and Sheet 4, and you want a total in Sheet5, then in Sheet5 you could have:
=SUM(Sheet1:Sheet4!D15)
To do average or Min or Max, just replace SUM with the appropriate function.
If you want to actually display them then you would have to do something like the following in different cells:
=Sheet1!D15
=Sheet2!D15
This will show the values from the other cells on the sheet you put those formulas in.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Can an Excel user paste a range of cells in the same worksheet the cells were copied?
Yes. You simply copy the cells, then highlight the upper left most cell of the desired destination (do not highlight multiple cells) and then paste.
Is copy and paste same as drag and drop in excel?
no
What is replicate mean in Excel?
It means to copy something.
What happens in Excel when you clear a cell?
Same as deleting its content.
When you enter a formula in a cell Excel assigns the cell the same format as the cell reference in the formula?
first
What is the easiest way to copy data into the cells adjacent to the original?
A quick way to copy data to adjacent cells is to use the Fill Handle (small square in bottom right corner of the cell). Just click and drag the handle to the number of cells you choose (in the same row or column). When you release the mouse button, Excel will copy the contents of the original cell to the cell range you have highlighted with the mouse.
IN Excel Why control enter when just enter works?
Control Enter can do a few special things. It will stay in the same cell after you've pressed it instead of moving to another cell. This can be useful if you keep wanting to change the value in the same cell. A really good thing it can do is enter data into multiple cells. If you select a group of cells and type something into the active cell and then press Control Enter, it will enter what you type into the selected cells. You can use that to put the same value into a load of cells at once. You can also use it to enter formulas that you would normally enter into one cell and then copy to the other cells.
How do you copy a cell to a range of cells. For example copy a value in A1 from A2 - A2000?
By Copy and Paste If you highlight the cells which need the same value, copy from Cell (A1) and then highlight all the cells which need the same value and Click paste Voila!
Does the sizing handle allow you to copy a formula from 1 cell to another cell?
If the formula is something like AVERAGE, SUM, etc., then it will copy it to another cell. However, when using the sizing handle after just entering the formula alone, Excel will automatically fill in the answer. The formula is copied along with it, though. However, if the formula is in reference to the content of another cell, this will not happen. The formula changes if the formula uses the content of another cell. To keep it exactly the same to copy it down, you have to make the cell number in the formula an absolute value so it will not change.
Does mitosis have the same chromosome number as the parent cell?
yes. the chromosomes make an exact copy of themselves to give to the daughter cell. as the cell starts to split, the copy moves into the daughter cell.
Data from Word can be copied to an Excel worksheet?
Yes you can copy data from Word to Excel. If it is in a table, it is very good as it will transfer the data direct into cells in the same way.
In excel how do you underline the characters in a cell and not the entire cell?
If this is an Excel question, you can underline words the same as in MS Word - use the 'U' icon or 'Format-font-underline'. The format is called 'underline.'
