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

Developer tools dev tools, developer efficiency hacks

Plugins :  sublime plugin for sublime editor, extensions for vscode.  VSCode (VS Code) basics: Drag file to text editing panel to preview, e...