• home

Gudelines to defining a Range Name in Ms Excel 2007

Range names can be quite flexible, but you need to follow a few restrictions and guidelines:
  • The name can be a maximum of 255 characters.
  • The name must begin with either a letter or the underscore character (_). For the rest of the name, you can use any combination of characters, numbers, or symbols, except spaces. For multiple-word names, separate the words by using the underscore character or by mixing case (for example, Cost_Of_Goods or CostOfGoods). Excel doesn’t dis- tinguish between uppercase and lowercase letters in range names.
  • Don’t use cell addresses (such as Q1) or any of the operator symbols (such as +, –, *, /, <, >, and &) because these could cause confusion if you use the name in a formula. 
  • To make typing easier, try to keep your names as short as possible while still retaining their meaning. TotalProfit07 is faster to type than Total_Profit_For_Fiscal_Year_2007, and it’s certainly clearer than the more cryptic TotPft07.
  • Don’t use any of Excel’s built-in names: Auto_Activate, Auto_Close, Auto_Deactivate, Auto_Open, Consolidate_Area, Criteria, Data_Form, Database, Extract, FilterDatabase, Print_Area, Print_Titles, Recorder, and Sheet_Title

Jika Anda menyukai Artikel di blog ini, Silahkan klik disini untuk berlangganan gratis via email, dengan begitu Anda akan mendapat kiriman artikel setiap ada artikel yang terbit di LintasGalaksi.blogspot.com

0 komentar:

Posting Komentar