Search Contextures Sites

 

Learn how to create Excel dashboards.

 

 

Excel Tutorial Videos 02

Name a Range of Cells 
Create a Dynamic Named Range in Excel  
Stop the Macro Warning After Macros Deleted 
Convert Text Numbers to Real Numbers 

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

 

Excel Tutorial Videos 01
Excel Tutorial Videos 02
Excel Tutorial Videos 03
Excel Tutorial Videos 04
Excel Tutorial Videos 05
Excel Tutorial Videos 06
Excel Tutorial Videos 07
Excel Tutorial Videos 08 
Excel Tutorial Videos 09 
Excel Tutorial Videos 10    
Excel Tutorial Videos 11   
Excel Tutorial Videos 12  

Get All the Excel News

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

Search Contextures Sites

 

 

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.

 

Last updated: October 16, 2014 7:28 PM