Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Monday, February 29, 2016 – Permalink –

Name that Range

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
Range Names in Excel


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:58 AM

Comments: Post a Comment