answersLogoWhite

0

I am not sure what you are asking, but my best guess is that the question should be "How do you create a formula you can drag to other cells without changing the original cells in the forumula?"

The answer to the new question is: Use absolute cell references. Instead of using =SUM(A1:A23) write =SUM($A$1:$A$23). When you move the formula with absolute cell references, it does not change.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

A way of showing your data in pictorial form?

If you have written a formula you can drag it down or across other cells this is known as


What is the term for all of the cells that go across the spreadsheet horizontally?

The cells that go across the spreadsheet horizontally is called a row of cells.


What are the cells that go across a spreadsheet called?

A row.


What are cell references in a formula called?

Cell references in a formula are called "dependencies." They represent the cells that the formula depends on to calculate a result. Tracking dependencies helps ensure that the formula is accurately resolving based on the values in the referenced cells.


What reference to use to copy a formula across a range of cells and have the formula automatically update the cell row and column?

relative cell reference


What is the movement called when a call does not use energy to move particles across the cells membrane?

It is called passive diffusion.


What allows you to check both the cells being referenced in a formula and the formulas that reference those cells?

You use a facility called formula auditing. You can then use Trace Precedents to see what cells are referenced by a formula. You use Trace Dependents to see which cells use the active cell. You can also press Ctrl and the [ key to trace precendents and Ctrl and the ] key to trace dependents.


Which term describes describes the difference in the concentration of a substance across a cells membrane?

This is called the osmotic gradient.


Cells in the nervous system communicate to each other across gaps called?

Cells in the nervous system communicate to each other across gaps called synapses. At these synapses, signals are passed between neurons using chemical messengers called neurotransmitters. This allows for the transmission of information throughout the nervous system.


What are the vertical columns called and how are the elements of each row relate?

The verticals are called , just as you questioned, columns; they are designated by letters. the relation between cells is according to formula that apply to values in the cells.


What is relative reference?

if you move or copy the formula to another cell, the cells referred formula will changed. Excel adjusts the cell references relative to the new cell in which the formula is pasted. this is called relative referencing.


An easy way to verify that a formula references the cells that you want it to reference is to use Excel's?

Range finder. Double clicking on the formula activates the range finder and you can see what cells are in the formula. This can help you see if the correct cells are in the formula.