Tuesday, June 28, 2022

Using named range in Excel, store a matrix in Excel, give it a name and do calculations

 Did you know you can name a range in Excel, and you can refer to it later. You can store these numbers 1 through 9 in excel. 

Select the 9 cells, then on the top left corner change it's column name range to a new name : matrix. Then click enter.

In a new cell, you can type =sum( which is the sum function, instead of drag and select the range, just type the name you give to the range : matrix. Close the parenthesis. =sum(matrix)

No comments:

Post a Comment

React UI, UI UX, Reactstrap React Bootstrap

React UI MATERIAL  Install yarn add @material-ui/icons Reactstrap FORMS. Controlled Forms. Uncontrolled Forms.  Columns, grid