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
Wiki User
∙ 9y ago
Wiki User
∙ 11y agoPut a dollar sign before it, to make it either a mixed or relative formula like these:
=A$3
or
=$A$3
In both cases the row number will not change when the formula is copied.
Wiki User
∙ 14y agoPut the cursor on the cell and type the new number in. You could put the cursor on the cell and press F2 to enable you to edit the number that is already there.
Wiki User
∙ 14y agoI do not understand this question. If you want a number to take up less space in a cell, then format the cell with a smaller font size.
Wiki User
∙ 12y agoDouble click on the cell with your mouse or you use F2 on your keyboard
Wiki User
∙ 13y agoYou can copy and past values.
Wiki User
∙ 13y agono
Add your answer:
Earn +20 pts
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)".
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 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.
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.
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.
Where is the formula error button in Excel 2007?
There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.
How can you lock a autoshape in Excel into place?
of course
