Range Name Syntax

Name syntax rules: The Name string must begin with a text character, not a number, and consists of adjacent characters. Two words can be joined with an underscore (_). For example, to enter the Name "Excel Book", you should type Excel_Book. You cannot...

5:48 AM | 0 comments | Read More

Deleting a Range Name

Why it is highly recommended to delete unnecessary range Names: Large numbers of range Names makes it more difficult to locate a specific Name. Range Names create references and unwanted links. To find unnecessary/unwanted range Names: 1. Select...

5:47 AM | 0 comments | Read More

Defining a Range Name

To define a range Name, use one of the following two techniques: Type the text directly into the Name box Select cell A1. In the Name box, type the text, and then press <Enter>. Define a Name using the Define Name dialog box 1. Select cell...

5:47 AM | 0 comments | Read More

Array Formulas

Understanding Arrays For those who do not have a background in programming or mathematics, the expression Array may not be familiar. So what exactly is an Array? For our purposes, an Array is simply a set of values which can be stored in a formula,...

5:42 AM | 2 comments | Read More

Printing Formula Syntax

To print the formula syntax for a range of cells: Display the formula syntax by pressing <Ctrl+‘> (the key to the left of  the number 1). Print the desired area....

5:38 AM | 0 comments | Read More

Adding a Comment to a Formula

To add a Comment to a formula: At the end of the formula, add a + (plus) sign. Type the letter N, and, in parentheses, type your Comment in quotation marks. Example: =CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio") ...

5:37 AM | 0 comments | Read More

Pasting Values

To paste the calculated value of a single formula into a cell (thus overwriting the formula): Press <F2> to edit and then <F9> to calculate. To paste the calculated value of a single formula into the cell below the cell containing the formula:...

5:35 AM | 0 comments | Read More