Rules For Naming Cells in Microsoft Excel

Microsoft Excel is one of the major applications you already have in your career to learn to work for this reason that I say, c & 39; is that over 90% of businesses with Microsoft Excel on a day-to-day not namely, the base of Microsoft Excel can not really & 39; on the outside. One of the greatest challenges facing us in working with Microsoft Excel, the cell d & 39; addresses. L & 39; use of the designation default column A to Z, then AA-IV is truly brilliant, but is really & 39; lead to a multitude of problems for people with large table. Let& 39;s try to remember that every cell in a table means that more than 20000 cells.
Well, if you think & 39; that it is difficult, try it with an imaging it must be a simple way and it is.
Absolutely S & 39; is the appointment of & 39; one of your cells in the spreadsheet. So & 39; that is what makes the transition, & 39; for the most part, the designation of & 39; a cell containing & 39; address of a cell & 39; as a normal AA543 Names such as & 39; interest rates or the total. The interesting part of the cell is a name that you made on its name in the forms, rather than the & 39; address of the cell. Naming a cell makes life a lot easier in Microsoft Excel, simply because we are & 39; as human beings are capable of spreading on more descriptive names such as & 39; interest rates or the overall amount that we can with a standard cell, however, there are some very strict rules, we must follow.
Rule 1 - the name Must Not Exceed 255 Characters
The first rule that we must respect them, c & 39; is that if you have the name & 39; a cell, the cell name must not exceed 255 characters. There is another aspect of what you need to know also, and that is that if & 39; on behalf of more than 253 characters, it will be replaced by the name & 39; n is no longer in the Name field & quot; on & quot; Formula bar & 39; tools. In fact, if you want to follow this basic principle, that your name should not exceed 30 characters, in general, we try to limit them between 10 and 20 characters, given that most of the entry and & 39; your formulas and functions can also be difficult to Find debt.
Rule 2 - Cell names are not allowed to contain Spaces
Cell names in Microsoft Excel not contain d & 39; space. There are two ways to view them as acceptable to overcome this problem. A unique opportunity, the distinction words in the name of the letter at the beginning of each word, as in the capitals of
TrialBalance
An other form of the name of a cell & 39;, it is allowed & 39; use Unterstrichs
as Trial Balance
Either technique is quite acceptable. You will find, however, that & 39; use of the name and, where we have limits, that & 39; it can be difficult to distinguish, with an underline border. In this case, it is preferable that the first name standard.
Rule 3 - Microsoft Excel makes no distinction between a letter and a case Capital Lower Austria One
Microsoft cells Excel names are not among capitalized means that the capital of a & 39; C is exactly the same as lowercase letter c, c & 39; is one reason why we use the first name standard, as a general rule, the rule 2.
4 -- Cell Must Be Unique name and the number should not Resemble, Cell address Or reserve Word
Microsoft Excel are very strict and that & 39; we do not have the following names in cell No.
-Cell & 39; in the industry -- No mathematical symbols such as + - * / & lt; & gt; & amp; - the names may not be similar to a phone number, address or L & 39; the cell reserved word A keyword is a text used for the functions and formulas. You can, for example, & 39; n is not regarded as a cell with the name of SUM, as & 39; is already the case in the civil SUM.
Rule 5 - Cell May Only the names that contain Names cells can Characters
When After that the following characters
-Letter characters from A to Z - many characters from 0 to 9 - Non-Uniform characters such as. ?
Rule 6 - Cell A name must begin with a letter, a backslash (), or an underscore ( ), you can
Whilst inconsistent numbers and characters such as a decimal point and the names of all cells must match in a letter, a backslash (), or an underscore ( )
So How do we give a name to a cell?
The easier to get the name of a cell & 39; is to select the first cell, and then, if you prefer, simply click on the cell in the Name box formula Bar, type in the name you want, then press Enter. What you will see, c & 39; is that whenever you click on the cell with the cell name as Microsoft Excel, the replacement of the cell d & 39; address, the name, you have the cell.
Naming Cell is a really d & 39; acquire skills useful to learn, especially if you start creating spreadsheets complex, as it is very easy to forget & 39; d l & 39; address of the cell contains Data for each piece. Naming & 39; cells means that it becomes easier to write your d & 39; formulas that relate to the cells in the right column information.
Chris Le Roy has Microsoft Excel 2003 Basic Cheatsheet help you with Microsoft Excel. Click here to learn more about Naming Cells or certificate at the & 39; use Microsoft Excel, in just 16 hours, simply extract Chris & 39; course of television, where you can earn Microsoft Excel, quotas issued by his company, leaving the house without a home - http://www.1 -on-1.biz/Products/MSEXCEL / & quot; & gt; Microsoft Excel Spreadsheet training. Http: / / www.1-on-1.biz/tipsonmicrosoftexcel/tipsonMicrosoftExcel.asp& quot; & gt; tricks for Microsoft Excel are also available. megan jani



Bookmark it: