<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=371557583225568&amp;ev=PageView&amp;noscript=1">

Excel Tip & Trick: Named Range

Excel Tip & Trick: Named Range

Steps to create a Named Range:

A named range is a selection of cells that are highlighted and given a name in the name box

Step 1: Input the range of numbers or data list on a separate sheet in the workbook

Step 2: Select the range of cells that you wish to name

Step 3: Click in the Name Box (left of the formula bar) and enter a name with no spaces (you can use _ to separate words) and push "Enter" to set the named range

Once created, you can use this range name in any formula within the workbook and if you input another account into the named range, it will automatically update the workbook, in all places where it is used.

Example of a Named Rage called 'Texas_Cities' Defined by Cells A1:A7

For more Tips and Tricks visit www.biznetsoftware.com/video

About BizNet Software

BizNet Software, Inc. is a market leader for Microsoft Excel in-memory, cloud-enabled reporting and business intelligence. Founded in 1996 to take the mystery out of databases, BizNet focuses on Microsoft Excel reporting solutions guided by financial and business professionals with a real-world understanding of corporate financial, operational and technical requirements. The BizNet Excel Suite is the most innovative and intuitive reporting solution on the market. It creates a user-friendly, drag and drop environment with real time access to the most accurate and current data. Built upon fundamental business disciplines and controls, BizNet solutions make it easy for Microsoft Excel users to connect, analyze, and share real time information. BizNet Software is endorsed by more than 200 partners, 15 software publishers, and currently has 20,000+ users in more than 2,100 companies in 30 different countries.

Microsoft® and Excel® are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. For more information, visit http://www.biznetsoftware.com or call .