ROW()-ROW($B$4)
=IF(B2="","",ROW(1:1))
Press Ctrl+!
Type in Custom...
"No."0
Cell Reference&CHAR(153)
Press Ctrl+!
Type in Custom...
[Red]@
Alt+Ctrl+V
Ctrl+Shift+*
;;;
Press Ctrl+!
Type in Custom...
"Rs."0
Press Ctrl+!
Type in Custom...
;;;"Excel"
ALT+O+A
Select Entire Data without Headers
Press....
Alt+H+L+N
Choose
Use a formula to determine which cells to format
Click on the search value, then click the cell in which you want to see the list, and press F4 three times.
ALT+A+V+V
Ctrl+E
Ctrl+~
Select Entire Data with Headers
Press....
Alt+H+L+N
Choose
Use a formula to determine which cells to format
Type...
=Cell<>"" and Press F4 3 times to freeze
Alt+H+L+H+D / Alt+A+M
Shift+F2 / Alt+V+C / Alt+R+D
Shift+F11
ALT+H+D+S
Alt+H+O+A
Alt+H+O+R
Alt+H+O+R
Alt+H+O+M
ALT+H+O+U+S / ALT+H+O+U+H
A5+A5*B5 / F5-E5
(0"pcs") + ("Rs."0)
Press Ctrl+!
Type in Custom...
(0"pcs") + ("Rs."0)
WINDOW + R + OSK
ROMAN(A1)
DGET(B3:E10,C3,B12:B13)
Type Ctrl+!
Open Font Tab
Select First st and check (Superscript)
| 1st |
| 2nd |
| 3rd |
| 4th |
| 5th |
SUBSTITUTE (C7," ","_")
IF(E5="Done",CHAR(252),(CHAR(251)))
ALT+E+I+S
CHAR(64+ROW(A3))
Abs Formula
="+92"&C5
Press Ctrl+!
Type in Custom...
0000-000-0000
0300-705-1397
C4+TIME(D4,0,0)
C4+TIME(0,D4,0)
C4+TIME(0,0,60)
IF(C4="Male","Mr. "&B4,"Ms. "&B4)
YEAR(C5)
DAY(C5)
MONTH(C5)
EOMONTH(A5,0) / EOMONTH(A5,-1)+1
COUNTIF(B6:B13,"*Mango*")
INT + =C5-D5
TEXT(B5,"DDDD")
ALT+Down Arrow