Excel scalar operations

The capability of dragging results from one cell to others is a very useful property of Excel and becomes even more powerful in combination with the dollar operator ( ) correctly applied within the cell reference. Referring to the previous Matlab example, if the scalar element foi,2 (cell F3) is to be subtracted from matrix A (A3 C4) in Excel, putting the dollar operator ( ) in front of the column and row reference of the source cell containing the scalar foi,2 ( F 3), prevents "dragging-over" of the source cell F3 in both column and row direction. 

---