answersLogoWhite

0

Usually, in computer science, "moving" is equivalent to "copying" something, then deleting the original. In other words, after copying something, you have two copies of the thing you copy; if you move something, only one, at the new place. However, specifically in Excel (and probably other spreadsheet programs as well), when you move a cell or a range, any formulae that refer to the cell (or to one of the cells in the range) will be updated; thus, in this sense, moving is no longer equivalent to "copy, then delete the original". For example: Cell B1 has the formula "=A1*10". If you move the contents of cell A1 to A5 (you can do this in several ways; one is by selecting the cell, and dragging the border), then the formula in B1 will change to "=A5*10".

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

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.


What is replicating a formula in Excel?

Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.


What is the difference between Excel sheet and spread sheet?

They are the same thing, excel is Microsoft's spreadsheet programme.


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

It will give you a warning and ask if you want to replace the contents of the destination cells. You can then choose whether to do so or not.


Why won't the copy and paste work in Microsoft Excel?

Copy and paste does work in Excel. There are in fact many ways of copying and pasting in Excel, using the mouse, menus or keyboard. You may have a specific problem, so it may depend on what you are copying and how you are doing it.


What is the difference between the way Access saves a record and the way Excel saves a row in a work sheet?

the difference between the way Access saves a record and the way Excel saves a row in a worksheet. Answer


What is the difference between MS Excel to Paint?

MS Excel is a spreadsheet; MS Paint is a basic graphics editing program.


What is the difference between SQL2005 and Excel 2007?

SQL is Structured Query Language, and relates to databases. Excel is a spreadsheet application.


What is the difference between excel and a word window?

Excel is a spreadsheet program that is marketed by Microsoft. Word is a word processing program that is marketed by the same company.


How do you use cut and copy function in Microsoft Excel?

Cut is for moving things and copy is for copying. You can copy in many ways in Excel. See the related question below. Cut can also be done a lot of ways, like using the Ctrl-X key combination, the Cut icon, Alt-E-T, using the shortcut menus, and other ways.Cut is for moving things and copy is for copying. You can copy in many ways in Excel. See the related question below. Cut can also be done a lot of ways, like using the Ctrl-X key combination, the Cut icon, Alt-E-T, using the shortcut menus, and other ways.Cut is for moving things and copy is for copying. You can copy in many ways in Excel. See the related question below. Cut can also be done a lot of ways, like using the Ctrl-X key combination, the Cut icon, Alt-E-T, using the shortcut menus, and other ways.Cut is for moving things and copy is for copying. You can copy in many ways in Excel. See the related question below. Cut can also be done a lot of ways, like using the Ctrl-X key combination, the Cut icon, Alt-E-T, using the shortcut menus, and other ways.Cut is for moving things and copy is for copying. You can copy in many ways in Excel. See the related question below. Cut can also be done a lot of ways, like using the Ctrl-X key combination, the Cut icon, Alt-E-T, using the shortcut menus, and other ways.Cut is for moving things and copy is for copying. You can copy in many ways in Excel. See the related question below. Cut can also be done a lot of ways, like using the Ctrl-X key combination, the Cut icon, Alt-E-T, using the shortcut menus, and other ways.Cut is for moving things and copy is for copying. You can copy in many ways in Excel. See the related question below. Cut can also be done a lot of ways, like using the Ctrl-X key combination, the Cut icon, Alt-E-T, using the shortcut menus, and other ways.Cut is for moving things and copy is for copying. You can copy in many ways in Excel. See the related question below. Cut can also be done a lot of ways, like using the Ctrl-X key combination, the Cut icon, Alt-E-T, using the shortcut menus, and other ways.Cut is for moving things and copy is for copying. You can copy in many ways in Excel. See the related question below. Cut can also be done a lot of ways, like using the Ctrl-X key combination, the Cut icon, Alt-E-T, using the shortcut menus, and other ways.Cut is for moving things and copy is for copying. You can copy in many ways in Excel. See the related question below. Cut can also be done a lot of ways, like using the Ctrl-X key combination, the Cut icon, Alt-E-T, using the shortcut menus, and other ways.Cut is for moving things and copy is for copying. You can copy in many ways in Excel. See the related question below. Cut can also be done a lot of ways, like using the Ctrl-X key combination, the Cut icon, Alt-E-T, using the shortcut menus, and other ways.


Is the difference between -20 and -10 equal to 10 or to -10 and why?

You can get the difference on your calculator, or in Excel. In Excel, the expression would be: = -10 - (-20) As to the "why", look at the numbers on a number line. That should help you visualize the situation.


What is the difference between saving an Excel file in xls or xlt?

The extension xls is a spreadsheet and xlt is a template. A template is a pre-designed layout for an Excel spreadsheet.