Just a few basic issues when I use formulas in Excel:
1. A $ sign sometimes appears in the cell even though the cells in the formula do not have $ signs.
2. How can you add a % sign?
3. How can you get rid of decimals?
Obviously you cannot just add or delete the above as cell results are automatic with formulas.
4. I am mostly using relative cell references (as you probably know, formulas adjust as they are copied), but want to copy a group of formulas and not have them adjust (absolute cell references). I looked this up and it said to select the reference you want to change in the formula bar and press F4, but I could not see where you select the reference. How do you do this or is there another way to do it?
Bookmarks