answersLogoWhite

0

Regular numbers typed into cells will not change. Cells showing the results of formulas will change occasionally if the values that the formula works on.

If you mean a cell reference in a formula, what you do to stop it changing is use an absolute reference to the cell. So if the value you want is in cell A2 and you do not want that to change when you start to copy the formula using it into other cells, put it in as $A$2 in the formula. Then it won't change when the formula is copied.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Total number of column in Microsoft Excel?

The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.


What is the bottom number on Microsoft Excel?

The last row number for Excel 2007 is 1048576.


What is a number that can be entered into a cell on Excel?

Which of the following is a number that can be entered into a cell?


What does excel provides so that you can easily create a professional consistent worksheet appearance?

Autoformat is one thing that allows you to build consistent formats. You can also do it manually.


How does the trig function ACOS work in Excel?

In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000


Total number of formulas in Excel?

The amount of formulas that can be done in Excel is infinite.


How can you increase the number of columns in your Excel because the number of all columns is only 255?

Upgrade to Excel 2007 or higher. There is no way to increase the number of columns designed into the spreadsheet. Excel 2003 and earlier have a limit of 256 columns. Excel 2007 and higher has increased that to 16,000 columns.


How you enter account no in Excel sheet it not except?

This question is not clear. You can enter a number in Excel by clicking on a cell and typing the number from the keyboard.


Excel recognizes an entry as a value if it is a number or it begins with?

Excel recognizes an entry as a value if it is a number or it begins with one of these symbols: +, -, =, @,#, or $ Rina


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.


How do you find scientific notation on excel?

You find scientific notation in Excel under the Format - Number menu.


What is the highest cell number on Excel?

XFD1048576