 |
Microsoft Excel 2003 - How to Name a Range
One of the most common functions that you will use in Microsoft Excel is to name a cell. The role of naming the cell is simply to provide you with a name to remember rather than a specific cell address like B2 or B3. However, one of the cool functions that Microsoft has incorporated into Microsoft Excel is the ability to name a range of cells and utilize the range when required.
There are a number of approaches that could be undertaken to name a range however the most common technique is to use the menu bar in Microsoft Excel 2003. The first step is to create a basic sheet with some data in it. I have outlined below a small table to enter into a worksheet and the cell location to place the values.
Cell C6: Products Cell D6: Value Cell C7: Shoes Cell D7: $5.00 Cell C8: Pants Cell D8: $15.00 Cell C9: Thongs Cell D9: $23.00
The first step in naming a range is to select the range. Select using your mouse the range from C6 to D9. Once you have completed this go to the Insert menu, then choose Name, and then Define from the expanded menu.
At this point the Define Name dialog box will appear. Type in the Names in Workbook text box the name - MyProducts and then press the OK button. You will notice that in the Refers To text box that your cell range selection has dollar symbols around it. Those dollar symbols inform Microsoft Excel, that on selection of the name you must absolutely refer to those cells. You have now defined a Named Range.
The next step in this process is to use the name range. The easiest way to do this is to first select the cell A1 on your worksheet. Now, goto the Name box on your formula bar and click on the drop down arrow. In the drop down box you will see the name - MyProducts. Simply choose the name. You will now see the cell range automatically selected in your worksheet.
There are many different areas in Microsoft Excel where you would use the Name Range. The most common time is when you want to create drop down lists in your spreadsheet. We use the name range capability, so that we can place the list on a different worksheet to the one we want to reference.
Learn Microsoft Excel with one of our self-paced training courses. To find out more visit MS Excel Help Mastery course. Our team also have Microsoft Excel Cheat Sheets available for you to learn your shortcuts just visit Excel Shortcut Keystrokes.
|
 |
Microsoft Excel 2003 - How to Name a Range
One of the most common functions that you will use in Microsoft Excel is to name a cell. The role of naming the cell is simply to provide you with a name to remember rather than a specific cell address like B2 or B3. However, one of the cool functions that Microsoft has incorporated into Microsoft Excel is the ability to name a range of cells and utilize the range when required.
Train Signal Releases Training Videos for Microsoft Exchange Server 2007
Train Signal, a leading IT Training Software provider, has released over 20 hours of instructor-led training videos for Microsoft Exchange Server 2007.
LodgeNet, Petters Hospitality Partnering to Enable the Delivery of HDTV Programming to Hotel Guest Rooms
Polaroid®TM Flat Panel Displays Will Support LodgeNet SIGNETURE HDTVSM Platforms Adoption of Pro:IdiomTM Content Security Technology To Enable Delivery Of High-Definition Satellite and Video-On-Demand Entertainment To Guest Rooms.
How to Use a WYSIWYG HTML Editor to Make Stunning EBay Auction Listings.
What kind of browser are you using for online surfing? Explorer, Netscape, Firefox, Opera?? Sure, all are good programs but I want to talk about an excellent program called Netscape. If you use Netscape, do you know that you also get an amazing WYSIWYG (what you see is what you get) web design program called Netscape Composer for free? Basically you don?t need expensive HTML editors anymore. The list of commercially available HTML editor?s software is endless ? and the price tags are enormous. Most people don?t want to spend a lot of money to get started with their eBay business. Fair enough, since the goal is to make money and not to spend money. So it makes perfect sense to use a program to design auction listings which is available for f...
Triveni Digital to Streamline Opportunity-to-Order Process with WebSource CPQ and Oracle's Siebel CRM On Demand
Webcom, Inc. sales configuration tool selected to help compress the quote-to-cash cycle and increase sales effectiveness.
TelecomWeb: Microsoft's Disruptive Impact on the IP Telephony Market
A new InfoTrack market research study describes in detail the disruptive impact Microsoft is having on the market for IP Telephony (IPT) systems as well as on the market for Unified Communications (UC) applications.
New and Highly Detailed Wedding Photography Tutorial Product on Offer with a Whopping 50 Percent Commission for All Affiliates
The Wedding Photography Blueprint, due to launch at the end of July 2008, is offering a huge 50% commission all sales to anyone with a website, blog, MySpace or Facebook account or with any online marketing experience with systems such as Google Adwords.
The AEgis Technologies Group Announces the Release of the Microsoft Excel Add-in for acslXtreme
The acslXtreme Excel Simulation Interface is an add-in utility for Microsoft Excel which allows models created in acslXtreme to be controlled and analyzed using Microsoft Excel.
Programming Language Migration Path
While I was preparing some personal background information for a potential client, I was reviewing all the programming languages that I have had experience with. I list languages that I'm most experienced with on my resume.
Microsoft Great Plains as ERP and Microsoft CRM as CRM
If you have Microsoft Great Plains and support it for your company then you need to know some technical details about Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customization, additional complexity comes with migration from ctree/Pervasive to MS SQL/MSDE.What is upgrade in the language of technology? Upgrade has server and client sides.
|
