Using Named Ranges Excel

Using named ranges in Excel can increase your productivity

The standard procedure for accessing values in Excel worksheet cells or ranges of cells is by using the cell address which can sometimes be difficult but using named ranges in Excel or named cells you can perform calculations more intuitively i. e. more like a human than a computer. If we have salary data in cells B2 to B7 then we can sum the data by typing the formula ‘=sum(B2:B7)’. If we had named the range B2 to B7 as ‘salaries’ then we could add the values by typing ‘=sum(salaries)’ in any other cell in the active worksheet or another worksheet in the workbook. That’s convenient and useful! You can also imagine that if we had a range of cells containing data on expenses and another range having our income data and we had named thes ranges ‘expenses’ and ‘income’ respectively, then we could easily calculate the profit by typing in another spreadsheet cell ‘=income-expenses’. Of course, here we have assumed that our income is higher than our expenses.
A different method to  implement the use of named ranges in Excel for calculations than shown in the training video  :

  • Select your data
  • Click on ‘Insert’ in the menu bar
  • Then select ‘Name’ and next ‘define…’
  • In the ‘Define name’ window give an appropriate name as demonstrated in the Excel training video
  • Finally you can see, it’s easier to perform your calculations using a ‘name’ rather than using cell addresses or ranges in Excel

Further reading
How to Create a Named Range in Excel

Defined names

Leave a Reply

Your email address will not be published. Required fields are marked *