Friday, April 14, 2006
Range Names in Excel
From Unofficial Office Stuff
How to use names in Excel
Named ranges are one of the more powerful tools in Excel.
Jan Karel Pieterse of JKP Application Development Services has written a tutorial that will help you understand this technique.
Here are some of the chapter titles:
How To Define Range Names
How To Use Range Names
Absolute And Relative Addressing
The Context Of Names
Special Names
A Step Further: A Formula In A Defined Name
Dynamic Names
Passing Arguments To A Defined Name Formula
Bugs in Excel's Name Object
The Excel Guru's Free Tips and Hints.
Welcome
Welcome to the Excel Tips blog. Free Microsoft Excel Tips and Hints designed to increase your productivity.
Advertisement
Subscribe Me
Previous Posts
- IF statements and conditional formats in Excel
- Common errors in Excel
- Creating Sheet Tabs in Excel with the Number of th...
- Disabled Items in Excel - AKA crashed files
- Dividing a First Left Heading Title
- Help Needed
- Constructing multi conditional array formulas in E...
- SUMPRODUCT array formulas in Excel
- Urgent Request
- Resetting the last cell in Excel
My Blogs and Websites
- Spy Journal Home
- Spy Journal Archives
Personal Blog- Excel Tips Blog
- Blog Tips Blog
- Tech Tips Blog
- Urban Space Novel
- Photo Archive
- Parklife Results
- Parklife Soccer Club Website
- KROSTech LAN Parties
- Jethro Management
- Jethro Consultants
- Oz Bush Poet
Excel Links
- ---RSS Feeds---
- Unofficial Microsoft Office Stuff
- KC on Exchange and Outlook
- Office Zealot
- Automate Excel
- Colo's Excel Junk room
- Daily Dose Of Excel
- The Planning Deskbook
- Excel Pragma
- Andrew's Excel Tips
- ---No RSS Feed---
- Excel Tip
- Mailbarrow
- Experts Exchange
- AJP Excel Information
- Beyond Technology
- Contextures
- ExcelTip
- Mr Excel
- Pearson Software Consulting
- Peltier Technical Services
- John Walkenbach - J-Walk
- Vangelder (wont work in Firefox)
- VBA Express
- xlDynamic
- The Excel Nexus
- Code Net
- Better Solutions
- Excel Business Tools
- Data Pig Technologies
- VBA Express
Other Links
Copyright Notice. All documents and text contained in this web site www.spyjournal.biz and sub pages is copyright material of Jethro Management (c) 2004 unless noted as being copyright material of someone else. No public reproduction of the content on this site in any form is permitted without express written permission.
Unless otherwise expressly stated, all original material of whatever nature created by Tim Miller and included in this weblog and any related pages, including the weblog's archives, is licensed under a Creative Commons License.