See how to name a range, create a dynamic named range, stop the macro warning, and convert text numbers to real numbers
In Excel, you can create names that refer to a single cell, a group of cells on the worksheet, a specific value, or a formula. After you define Excel names, you can use the names in a formula, instead of using a constant value or cell references. For example, a cell that contains the tax rate could be named SalesTax. Then, other cells could multiply sales amounts by the named range, SalesTax.
For Excel names that refer to a cell or a range of cells, you can use the names to quickly select the named range, and that makes navigation easier. Just select a range name from a drop down list, and you'll immediately go to that range.
For written instructions for this Excel tutorial, see: Naming a Range
When you create a named range in Excel, it doesn't automatically include new items. If you plan to add new items to a list, you can use a dynamic formula to define an Excel named range. Then, as new items are added to the list, the named range will automatically expand to include them.
For written instructions for this Excel tutorial, see: Create a Dynamic Named Range
If you open an Excel file, you might see a message that asks if you want to "Enable or Disable a Macro". However, you might be confident that there are no Excel macros in this workbook.
This message appears if an Excel macro has been added and then removed, leaving an empty module. An empty module will trigger the macro warning, even though all the macros have been removed from the module..
In this video you'll see how to find the cause of the problem message, and remove the problem modules.
For written instructions for this Excel tutorial, see: Macro Warning
When you copy data from another program, such as Microsoft Access, or from a text file, Excel may treat the numbers as text. If you perform calculations with these numbers, the calculations will be incorrect, such as a column of "numbers" that adds up to zero.
This video shows one of the methods that you can use to convert the text "numbers" to real numbers. You'll use the Paste Special command to multiply the text numbers by zero. That will change them to real numbers, that you can use in calculations.
For written instructions for this Excel tutorial, and other methods for converting text numbers to real numbers, see: Convert Numbers
For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.
Search Contextures Sites
Last updated: February 28, 2017 3:01 PM
Contextures RSS Feed