0
What is the difference between copying a range and moving a range in excel?
Wiki User
∙ 10y ago
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".
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
How does the trig function ACOS work in Excel?
In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000
What would be the percentage between 5.10 from 4.25?
what is the formula in excel for: 5.10 percentage 4.25
What is the control center in a PowerPoint in Excel?
There is no PowerPoint control center in Excel. MS PowerPoint is a presentation application. MS Excel is a spreadsheet.
Where is the x axis on excel?
The "x-axis" usually refers to the horizontal axis. In Excel, that would be relevant for graphs created with Excel.
Can you rotate text counterclockwise by entering a number between 1 degree and 180 degree on the aligment sheet in the format cells dialog box?
In Excel it is between -90 deg and +90 deg.
When copying or moving cells if data already exists in the destination cells Excel?
will not complete the copy or move procedure
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.
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.
What is the difference between Excel sheet and spread sheet?
They are the same thing, excel is Microsoft's spreadsheet programme.
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 Microsoft Excel 2003 and Microsoft Word?
Microsoft Excel is a worksheet. Microsoft Word is a word processor.
What is the difference between SQL2005 and Excel 2007?
SQL is Structured Query Language, and relates to databases. Excel is a spreadsheet application.
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.
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.
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.
