Using a named range in a formula also makes the formula look more user-friendly. An example of a SUM formula An example of a SUM formula with a named range Insert a range in a formula Start typing your formula as necessary. With the cursor still in the formula cell, select Formulas >...
Named ranges can be used to help clarify this formula. You can insert a named range into a cell or formula using the (Insert > Name > Paste) dialog box and pressing OK. You can also use the shortcut key (F3) to display the (Insert > Name > Paste) dialog box when editing a cell...
You can quickly insert a named range to a formula that you are building in your Excel spreadsheet.What are named ranges? Using named ranges in formulas makes it easier to build and maintain formulas. Using a named range in a formula also makes the formula look more user-f...
Click "OK" to confirm your named range. Now, you can refer to the prices using the name "PriceForEach" in formulas and functions. Create a Named Range How to Define and Use Named Ranges Named ranges in Excel are powerful tools that simplify formula creation and data management. In...
Object Formula {get;set; } 属性值 类型:System.Object NamedRange控件的用 A1 样式表示法表示的公式。 备注 如果NamedRange控件包含一个常数,则此属性返回该常数。 如果NamedRange控件为空,则此属性返回一个空字符串。 如果NamedRange控件包含一个公式,则此属性会将该公式作为字符串返回,其格式将与在公式栏中显...
Object Formula {get;set; } 属性值 类型:System.Object NamedRange控件的用 A1 样式表示法表示的公式。 备注 如果NamedRange控件包含一个常数,则此属性返回该常数。 如果NamedRange控件为空,则此属性返回一个空字符串。 如果NamedRange控件包含一个公式,则此属性会将该公式作为字符串返回,其格式将与在公式栏中显...
Gets or sets the formula for the NamedRange control, using A1-style references in the language of the user. C# 复制 public object FormulaLocal { get; set; } Property Value Object The formula for the NamedRange control, using A1-style references in the language of the user. Examples The...
下面的代码示例创建一个 NamedRange,然后使用 FormulaR1C1 属性将 NamedRange 的值设置为与单元格 A1 的平方根相等,如使用 R1C1 表示法所指定的那样。此示例针对的是文档级自定义项。C# 复制 Microsoft.Office.Tools.Excel.NamedRange formulaR1C1Range; private void SetFormulaR1C1() { formulaR...
publicobjectFormulaR1C1 {get;set; } Property Value Object The formula for the object, using R1C1-style notation. Examples The following code example creates aNamedRangeand then uses theFormulaR1C1property to set the value of theNamedRangeto equal the square root of cell A1, as specified us...
Microsoft.Office.Tools.Excel.NamedRange refersToRange;privatevoidDisplayFormula(){ refersToRange =this.Controls.AddNamedRange(this.Range["C1","D2"],"refersToRange"); MessageBox.Show(refersToRange.RefersTo); refersToRange.RefersTo ="=Sheet1!$C$3"; refersToRange.Select(); MessageBox.Show(refersToRange....