Home » Forums » Open Source Learning Center » Question and Answer

Named ranges

Submitted by sally on 12 July, 2012 - 12:59

Hello
I have two named ranges, income is the named range for column A and expenses is the named range in column B. Both ranges extend from A3:A30000 and B3:B30000 this gives plenty of cells for data entry, but I need to now how I can get the formula =income-expenses to auto fill/copy down column C3:C30000 so that when data is entered in to columns A and B C auto calculates.

‹ SPREADSHEET SHARING Trouble with Edit Function in Excel 2003 ›
»
Almir's picture

Named ranges

Submitted by Almir on 23 October, 2012 - 22:21.

Instead of named ranges you could convert table to Data Table. When you add new data formulas will automatically adjust.

»
Nick's picture

if you change the range names

Submitted by Nick on 12 July, 2012 - 15:32.

if you change the range names so that you reference the entire column, you can simply enter the formula in every cell:

=income-expenses

»

Named ranges

Submitted by Anonymous on 12 July, 2012 - 15:46.

Good day Nick
Not really sure of what you mean, Do I have to name all the cells in a column as the named range and not just a selection as I have. And how do I automatically get the formula to populate all the cells in a rage. Is a matter of highlighting the range and then entering the formula in the formula bar

»