Excel 365 2016 2013 2010 2007

Modify cell data

You can edit data in cells this in several ways:

Basic Formula operators

There are several operators that could be used in formulas.

Entering decimal points automatically

If you need to enter lots of numbers with a fixed number of decimal places, Excel has a useful tool:

How to avoid misleading numbers

Applying a number format to a cell doesn't change the value, but only how the value appears in the worksheet. Formatting can play a joke with you, e.g., sum of values seems incorrect because Excel displays a limited number of decimal places and their sum is not equal to the real sum.

Changing moving direction of the cell pointer after entering data

Excel automatically moves the cell pointer to the next cell down when you press the Enter key after entering data into a cell, but you can change this behaviour to move it up, down, left, right and even stay on.

Using the formula bar as a calculator

If you simply need to perform a calculation, you can use the Formula bar as a calculator.

Referencing cells outside the worksheet

Formulas can refer to cells in other worksheets-and the worksheets don't even have to be in the same workbook. Excel uses a special type of notation to handle these types of references.

Shortcut key to switch between relative, absolute and mixed references

You can enter nonrelative references (absolute or mixed) manually by inserting dollar signs in the appropriate positions, or you can use a handy shortcut - F4 key.

Using Arrows in a Chart

Expressiveness of business graphics sometimes determines the success or failure of the presentation and you can achieve better perception of the audience by using in charts intuitively obvious representation of data by arrows.