To write same thing on multiple cells
1. Select a range of cells say from A1 to A10
2. Write whatever you want to write
3. Press Ctrl+Enter
If what you want to write is already there in a cell and you want to copy it in cells adjacent to it
1. Select the cells where you want the text
2. Select the cell which has the required text
3. Press F2
4. Press Ctrl+Enter
To copy a cell contents on the cell to the right,
1. Select the range of cells
2. Press Ctrl+R
To copy a cell contents on the adjacent cells below,
1. Select the range of cells
2. Press Ctrl+D
To write a fraction
1. Write 0 followed by a space and the fraction with the slash
2. Press Enter
Use TAB or Enter to move in a selected range of cells
To edit contents of cell Press F2 and it takes you in the cell
To convert a formula into its numerical value
1. Go in the cell
2. Press F2
3. Select the formula or part of the formula which you want converted
4. Press F9
5. Press Enter
This method loses the formula while retaining the calculated value.
To compare values in two cells
1. Use expression like =A1=B1, =A1>B1, =A1<B1
2. It returns either True or False
Table of Operators in Excel
And and Or in Excel
=OR(A1=100, A1=200) returns TRUE if either of A1=100 or A1=200 holds else FALSE
=AND(A1<100, A2>200) returns TRUE if both A1<100 and A2>200 holds else FALSE
Operator Precedence in Excel
Calculating Formulas
If calculation mode (Formulas>Calculation>Calculation Options) is set manual then:
Press F9 to recalculate the sheet
No comments:
Post a Comment