Entering Matrix Formulas

The following is an example of how you can enter a matrix formula, without going into the details of matrix functions.

Assume you have entered 10 numbers in Columns A and B (A1:A10 and B1:B10), and would like to calculate the sum of each row in Column C.

1. Using the mouse, select the range C1:C10, in which the results are to be displayed.

2. F2 दबाएँ या सूत्र पट्टी में इनपुट लाइन पर क्लिक करें.

3. बराबर चिह्न (=) प्रविष्ट करें.

4. दायरा A1:A10 चुनें, जो योग सूत्र के प्रथम मूल्यों को रखता है.

5. न्यूमेरिकल कुंजीपट में (+) कुंजी दबाएँ

6. द्वितीय स्तम्भ के कक्षों B1:B10 में से संख्या चुनें.

7. End the input with the matrix key combination: Shift++Enter.

The matrix area is automatically protected against modifications, such as deleting rows or columns. It is, however, possible to edit any formatting, such as the cell background.