answersLogoWhite

0

If you have a value in, for instance, cell A1 then if, for instance, you put =A1 in cell B1 then cell B1 will now contain a duplicate of cell A1.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

How do you switch off an excel function that automatically rewrite another word. For example I wrote system. When you hit space it automatically turns into a period?

I do not no but JulietRDean rocks.


How do you recover Excel files after a freeze?

You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.You may just have to go to the last saved version. Another possibility is that when you re-open Excel, it may automatically recover a more up to date version of the file for you.


How do i copy data from one excel sheet to another automatically?

To automatically copy data from one Excel sheet to another, you can use formulas or Excel's built-in features. For example, you can use the =Sheet1!A1 formula in the target sheet to reference a specific cell from the source sheet, allowing it to update dynamically. Alternatively, you can utilize Excel's Power Query feature to import and transform data from one sheet to another automatically. For more complex automation, consider using VBA macros to copy data based on specific conditions or triggers.


How do you eliminate duplicate addresses on a list in excel?

highlight it then press delete


When a formula is copied and pasted from one cell to another Excel automatically changes the cell addresses to reflect the destination location?

relative


Is linked data always automatically updated if linked to another workbook in excel?

specify that the cell address currntly in the edit line will change if copied to another cell


What is an item that can be automatically updated within Excel?

formula


In Microsoft Excel is data pasted using past link always updated automatically?

Normally it will update automatically. If it is linked into another document, it may have to wait until it is that document is opened before updating.


What does Excel automatically do with formulas?

It automatically calculates them and displays the value in the cell if you have auto-calculation turned on.


What is duplication of worksheet in Microsoft Excel?

A duplicate is a copy. So if you make a duplicate, you copy the original, whether you do it by hand, on a computer, or on a photocopy machine.


How do you ignore cells containing letters when averaging in Excel?

Excel will automatically ignore cells with letters when averaging.Excel will automatically ignore cells with letters when averaging.Excel will automatically ignore cells with letters when averaging.Excel will automatically ignore cells with letters when averaging.Excel will automatically ignore cells with letters when averaging.Excel will automatically ignore cells with letters when averaging.Excel will automatically ignore cells with letters when averaging.Excel will automatically ignore cells with letters when averaging.Excel will automatically ignore cells with letters when averaging.Excel will automatically ignore cells with letters when averaging.Excel will automatically ignore cells with letters when averaging.


Does excel automatically create an empty row in a table?

YES