answersLogoWhite

0

When you copy cells in Excel, the data in the copied cells, the cell references are automatically adjusted. If the copied area includes hidden cells, these cells are also copied. To copy a selection of cells to a different worksheet, click another worksheet tab and select the upper-left cell of the paste area.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

Cells are copied using excels copy function what happens yo the data in the copied cells?

the data of copied cells is distributed to the two daughter cells during prophase


What is a function reference in Excel?

A function can reference cells or named ranges in the function.


When copying or moving cells if data already exists in the destination cells Excel?

When copying cells in Excel to a destination where data already exists, you can choose to either replace the existing data with the copied data, keep the existing data and not copy over it, or merge the copied data with the existing data. When moving cells in Excel to a destination where data already exists, the original cells will be replaced by the moved cells.


Does Excel surrounds copied cells with a moving marqee?

Yes. This effect is sometimes referred to as marching ants.


What is a function to find the number of values in cells?

In Excel is it COUNT.


What is the Excel function that adds all the numbers in a selected range of cells is the?

Sum Function


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.


Does the total function sum the numbers in the specified range and then divides the sum by the number of nonzero cells in the range?

To be technically accurate, no function does this. The answer you are looking for is the AVERAGE function. It divides by the amount of cells that have values in them, not by the amount of cells. In most situations, all of the selected cells have values in them, but there are cases when they don't.


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.


An Excel function thats contains the number of cells within a range that meet the given condition is?

The COUNTIF function can do that.


How do you average Excel times?

Times in Excel can be averaged using the AVERAGE function. So if you have a list of time in the cells from A2 to A13, the function would be: =AVERAGE(A2:A13)


What happens if you type a formula in a table column?

excel sums the cells in the column