Excel range question

  bobbyp 11:22 11 Mar 04

I am fairly new to Excel and have a question
I have a number of worksheets which link back to a source data file. These sheets include a lot of formulaes and graphs.

My question is, if I added an extra load of lines to the source data file, is there an easy way of telling all the formulae that the range has been extended, without modifying each one individually e.g. all the ones with % now need to know there are more lines, without modifying all 15 formulae cells individually.


  y_not 17:02 11 Mar 04


  daba 23:47 11 Mar 04

All, and I mean ALL, references will be updated accordingly.

Even those that point at 'fixed' cells (as in $A$1:$C$3).

In this instance if you inserted a column at B or C, any references to $A$1:$C$3, will be automatically updated to look at $A$1:$D$3.

If you insert a column at A, you haven't changed the source data range, but you will move it, so the new references will be $B$1:$D$3.

Hope this is clear.

  Muckle 00:09 12 Mar 04

If you go to 'insert', 'name', 'define', select the range you wish to change and then update the 'Refers to:' field and OK it, you should achieve your aim.

  bobbyp 09:01 12 Mar 04

Excellent - thanks for the help. The Label Ranges will do it.

Thanks again

This thread is now locked and can not be replied to.

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…