Place cell pointer in the row where you want to insert.
Right click your mouse.
Click Insert.
Click Entire row.

Convert select case in Visual Basic code to simple formula in Microsoft Excel
In this exercise, the value selection is from 1 to 3 only. BTW, you can make the last number of value higher (more than 3).
Before continuing this subject, I show a simple case in Visual Basic form example.
Private Sub Command1_Click()
Dim Total As Integer
Text0.SetFocus
Select [...]

Using formulas in Microsoft Excel
As you know, the formula in Microsoft Excel becomes an extremely powerful when we make a calculation in a cell. Microsoft Excel’s primary math operators are +, -, /,* and ^ for exponentiation.
When we try to make a formula in Microsoft Excel always starts with an equal sign (=).
Point to remember, [...]

Add comments to a cell
Adding comments in Microsoft Excel is easy.
Click a cell you want to add your comments.
Right-click then choose Insert Comment.
Type your comments in the comment box.
To end your comments, left-click your mouse button in any cell you like but not in the selected cell.
The typing text of your comments do not [...]

Easy autofill technique.
Autofill makes you faster when you fill data in certain cells.
By using autofill, you can fill data across rows and columns. This technique is used to complete data from a cell or cell selection. The easy way to use autofill is to select both cells by using your mouse, of course you have [...]

Edit a cell
If we type in a cell but then realize that we have made a mistake, so we have to correct our data-entry.
There are some way to correct our mistake:
You can select a cell by double clicking the cell that contains the data you want to edit then press backspace to erase our mistake [...]

Selecting Cells
Selecting a row of a cells or a cell is easy, by clicking and dragging your mouse.
By holding down SHIFT and using (right, down, up and left) arrow key can be used to select cells.
Click the first cell in the range, and then hold down SHIFT and click the last cell in the [...]

SUMIF
This function in fact resembles the SUM function, that is to add a number within a range of cells.
The word “IF” means this sum was added up with the certain conditions.
The syntax is:
SUMIF(range,criteria,sum_range)
The example below may be easier to see.

A
B
C

1
Item
Total
Stock

2
A
300
1

3
B
90
2

4
C
125
3

5
D
200
4

6
E
70
5

7

..

Try these formulas in cell C7
Result

=SUMIF(B2:B6,"=300",C2:C6)
1

=SUMIF(B2:B6,">=125",C2:C6)
8

=SUMIF(B2:B6,"<500",C2:C6)
15

=SUMIF(A2:A6,"A",C2:C6)
1

=SUMIF(A2:A6,">C",C2:C6)
9

=SUMIF(A2:A6,"<C",C2:C6)
3

AND vs. VLOOKUP
Do we have to use AND function or VLOOKUP function ?
The answer depends on the case that we have.
To see the example, I tried to make an experiment using AND and VLOOKUP funtion to solve simple case.

From this experiment I found the same result, although I used two different formula.
The formula I use [...]

IF Application
To compare 2 conditions or more and also can be used to conduct conditional tests on values and formulas.
Please see examples below how if function is used.

This example using single if
To fill up cell C3 the formula is:
=IF(B3=’M’,’MARRIED’, “NOT MARRIED’)
To fill up cell F3 the formula is:
=IF(F3>=60,’PASS’, “REMEDIAL’)
..
This example using multiple if

To fill up [...]