Defining Names and Ranges

Defining Names and Ranges

Names and Ranges

Defining names and ranges is different in Workbook Designer than it is in Edit Design Data. In Edit Design Data, you are only allowed to define names or prompts. With Workbook Designer, you can define a name or range anywhere in a worksheet.

There are different methods in which defined names can be added.

Selecting a cell, or range, and then right-clicking will open the quick menu. From the quick menu, select “Define a Range” and provide a name (no spaces are allowed in the name, use an underscore instead of a space).

You can define multiple names (like defined names for prompts). By selecting both the cell with the name of the prompt and the cell which will become the defined name and then clicking on the Insert menu, expanding the Defined Name options, choosing “From Selection,” and then selecting the option for how to create the names, the names will be automatically generated.


Another method to add defined names is to use the Name Manager. From there, you can select the New button and then fill out the required information.



    • Related Articles

    • A Look into Workbook Designer and the Different Workbooks

      A Look into Workbook Designer and the Different Workbooks The Workbook Designer interface will be covered in more detail in a later section. However, this section will briefly cover Workbook Designer to understand the different workbooks and ...
    • Understanding the Workbook Designer Interface

      Workbook Designer InterfaceWorkbook Designer contains more tools than the Edit Design Data interface. However, some of the advanced features of Edit Design Data are not available when working through Workbook Designer. The automatic formatting of ...
    • Overview of Workbook Designer

      The purpose of this article is to provide an overview of the Workbook Designer feature. How to Access the Workbook Designer The most commonly used method for accessing Workbook Designer is through the Edit Design Data feature, which can be accessed ...
    • Introduction to the Global Workbook

      The Global Workbook can be accessed through the Workbook Designer interface and is labeled as the “G” workbook. All Global Variable information in the correct workbook location is visible and available to edit in the Global Variable user interface ...
    • Tutorial 1: Passing Prompt Information Between Workbooks (Doors)

      This tutorial shows you how to configure a subassembly to pass information between the L! workbook (local prompts), and the S! workbook (subassemblies). This example expands on the overview article "Overview: Passing Prompt Information Between ...
    • Recent Articles

    • Toolbox Release Notes | Build 25.1.0221.641

      The following release notes apply to Toolbox build 25.1.0221.641 UI Fixes An issue was reportedly occurring when users utilized pop-out menus near the edge of a screen on a multi-monitor workspace. When popping out a sub-menu, it is expected for the ...
    • Toolbox Release Notes | Build 25.1.0213.641

      The following release notes apply to Toolbox build 25.1.0213.641. Stay Down Nesting Additions 3 new settings have been added to Stay Down Nesting, to resolve specific issues with routes and connectors that have been reported: Fig. 1: New options in ...
    • Toolbox Release Notes: Year of 2024

      This document will catalog all releases for Microvellum Toolbox software builds that were released in the year 2024. This encompasses builds 24.1.0104.641 to 24.1.1206.641. Toolbox Release Notes | Build 24.1.1206.641 The following release notes apply ...
    • Toolbox Release Notes | Build 25.1.0129.641

      The following release notes apply to Toolbox build 25.1.0129.641. SMA Fixes A wide variety of issues with the Solid Model Analyzer have been resolved. Multiple modifications to existing interfaces or settings have been made to improve precision and ...
    • Microvellum Foundation Library Release Notes | Build 25.0124

      The following release notes apply to Microvellum Foundation Library build 25.0124. Additions Added Century Components Waste Bins, Vanity Organizers, and Base Cabinet Organizers. 11”, 14”, 17” Signature Series Bottom Mount 34qt & 50qt. 4”, 5”, 6”, 9”, ...