Forum Discussion
Formulas ($ and % signs, Decimals, Cell references)
1,2,3: There are two ways to easily adjust number formats. The first is on the "Home" tool bar, the section that looks like this (except a lot smaller), toward the center of the screen. The icons are pretty self-explanatory, and by clicking on the box showing "General" you get a more extensive set of choices. Change the number of decimal places by those two marked with an arrow in the image below.
The other place you can accomplish the same is in the main menu up at the top of your screen, Format...Cells...
which takes you to this dialog box
4. You select a reference in a formula by just placing your cursor on it. Then pressing F4 will cycle through the options, the different degrees of absolute:
- Absolute in row and column $A$1
- Absolute in row but relative in column A$1
- Absolute in column but relative in row $A1
- and fully relative A1
1,2,3: There are two ways to easily adjust number formats. The first is on the "Home" tool bar, the section that looks like this (except a lot smaller), toward the center of the screen. The icons are pretty self-explanatory, and by clicking on the box showing "General" you get a more extensive set of choices. Change the number of decimal places by those two marked with an arrow in the image below.
The other place you can accomplish the same is in the main menu up at the top of your screen, Format...Cells...
which takes you to this dialog box
4. You select a reference in a formula by just placing your cursor on it. Then pressing F4 will cycle through the options, the different degrees of absolute:
- Absolute in row and column $A$1
- Absolute in row but relative in column A$1
- Absolute in column but relative in row $A1
- and fully relative A1