If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to prevent function range auto-modification ?
Hi,
I've discovered a feature that I find quite anoying: when I write something in a cell next to a range of cell used in any function, this range is changed automatically to include the written cell. Example: 1) Open a new workbook 2) Enter the numbers 1 in cell A1, 2 in B1 and 3 in C1 3) Enter the function "=SUM(A1:C1)" in cell F1 Now enter any number in cell D1: Excel changes the range of the SUM function in cell F1 from "A1:C1" to "A11". I didn't find any configuration option to prevent this, is there any way? Thanks, Manuel P.D. this is Excel XP on Windows 2000 Pro |
#2
|
|||
|
|||
How to prevent function range auto-modification ?
I just upgraded to XL2002 from XL97 and that's definitely
a new feature. I turned mine off through Tools Options Edit tab and unchecked "Extend list formats and formulas". HTH Jason Atlanta, GA -----Original Message----- Hi, I've discovered a feature that I find quite anoying: when I write something in a cell next to a range of cell used in any function, this range is changed automatically to include the written cell. Example: 1) Open a new workbook 2) Enter the numbers 1 in cell A1, 2 in B1 and 3 in C1 3) Enter the function "=SUM(A1:C1)" in cell F1 Now enter any number in cell D1: Excel changes the range of the SUM function in cell F1 from "A1:C1" to "A11". I didn't find any configuration option to prevent this, is there any way? Thanks, Manuel P.D. this is Excel XP on Windows 2000 Pro . |
#3
|
|||
|
|||
How to prevent function range auto-modification ?
"Jason Morin" wrote...
I just upgraded to XL2002 from XL97 and that's definitely a new feature. I turned mine off through Tools Options Edit tab and unchecked "Extend list formats and formulas". Digression: how many other new & improved features have you turned off? -- Never attach files. Snip unnecessary quoted text. Never multipost (though crossposting is usually OK). Don't change subject lines because it corrupts Google newsgroup archives. |
Thread Tools | |
Display Modes | |
|
|