answersLogoWhite

0


Best Answer

In Excel, if you want a cell to always equal a specifc cell, use "$" -- for example, if you want the current cell to always equal A2, even when inserting rows or columns, use the formula: =A$2$

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How can you make one cell always equal another cell even if you insert a line above it in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

When you select a row and ask Excel to insert a row where is the new row inserted?

It is inserted above it.


Excel rows are inserted the selected row?

You can insert rows above or below the selected row. You select what you would like to do on the insert worksheet rows menu.


What is another way of saying - to work over and above expectations?

exceed expectations excel


Is the Range automatically selected by Excel always right?

No, the range automatically selected by Excel isn't always right. Excel doesn't know what the user wants to select, but chooses what might be appropriate, like the column of numbers above a SUM function. The user can go with what Excel has chosen, or choose their own cells.


How do you get the sum of a number of digits of the number in excel?

to go beyond or above outdo surpass another or others.


What is a 5 letter word for higher?

outdo excel


How do you insert sheet In Excel?

What i would do is make a topic,put a place to put a child's name and make some problems for them to do based on their grde level. Here's an example.Name______________ Math DoublesAnswer the problems.1. 6+6=___2. 5+5=___3. 3+3=___


What does the word Excel mean?

To excel is to do very well in something, well above average. It comes from excellent. Experts in things excel in their areas of work. The top athletes excel in their sport. Excel is also the name of the most popular spreadsheet program. It is made by Microsoft.


In excel what is the heading above the worksheet grid?

The letters in the heading above a worksheet grid are called column names.


When you have excelled during your education or at work?

You can excel in your education, when you get really good grades. You can excel in the workplace when you go above and beyond your job duties.


What does ctrl comma do in Microsoft Excel?

Ctrl-comma does not do anything in Excel. Ctrl ' copies from the cell above and Ctrl `switches to and from the formula view.


Excel-A spreadsheet is a software program that allows you to do what analyze data calculate data or chart data or all of above?

All of the above.