Home > Structure > Workbook > Videos

Excel Videos Names Macros Numbers

See how to name a range, create a dynamic named range, stop the macro warning, and convert text numbers to real numbers

view code command on right-click menu

Name a Range of Cells

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

Create a Dynamic Named Range in Excel

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

Stop the Macro Warning After Macros Deleted

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

Convert Text Numbers to Real Numbers

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

More Excel Videos

Excel Videos - Index

Copy VBA

Create UserForms

Mouse Shortcuts

Pivot Table Tips



About Debra


Last updated: November 13, 2023 1:41 PM