answersLogoWhite

0

If you mean fix in the sense of have it so that the cell reference cannot change when it is copied, then you do it by making the cell reference absolute. That is done by putting a dollar sign before the column reference and a dollar sign before the row reference. So in the following formula A3 has been made into an absolute reference:

=$A$3*B3

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

What is the excel formula symbol for any number?

1()


What are the functions of cells in Excel?

In effect a cell in Excel is a box where either text, number or formula can be placed.


Is there a limit to the number of items you can put in an Excel formula?

Yes. Excel 2003 and earlier limit is 254. Excel 2007 limit is 16,000.


What happens when you change a number within a sum formula in Microsoft Excel?

It can change a total that the formula results in.


How do you use the rounded the the nearest hundredth formula?

The formula, in Excel and similar spreadsheets, is "=round(number,2)".


What do you have to put in a cell to denote an equation in Excel?

In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.


How do I add round to a formula in Excel to show no decimal places in Excel?

There is a function called ROUND which you can use to round to zero decimal places. If your number was in cell A2, the formula would be:=ROUND(A2,0)


What is the mortgage constant formula in Excel?

The mortgage constant formula in Excel is PMT(rate, nper, pv) / pv, where rate is the interest rate, nper is the number of periods, and pv is the present value of the loan.


How can you lock a autoshape in Excel into place?

of course


How do you make a copyright symbol in Excel?

With Num Lock on, hold down the Alt key and type 0169 on the number pad.


The excel formula for raising a number in cell B1 to the power in cell C1 is?

=b1^c1


What is cell in Microsoft office excel?

A cell is a rectangle that can hold a number, text, formula etc.