Much less squinting over a worksheet to ensure the formula has the right cell reference. Modern Excel colorizes the formula bar and matching cell selections, making checking formulas a lot easier. We now have some handy names that we can type into formulas rather than having to select or type in cell ranges every time.Īs a quick example, if we want to add together the first and second quarter expenses, we would simply type: We then go on and do the same for Quarter2, Quarter3 and Quarter4. Now there’s a named range called ‘Quarter1’. To start we select the first three months’ worth of figures, type Quarter1 in the Name Box, and press Enter. In our sample worksheet, let’s say we want to work with our expenses per quarter, so we decide to name them Quarter1, Quarter2, etc. Quickly make a new Named Range in the Name Box It’s the same as going to Formulas | Define Name | Define Name … but a lot faster.Įxisting named ranges can be selected or new ones created with the Name Box. That name can then be used to find that data again, or in formulas instead of typing in the cell range. You can select a cell or range of cells, and give them a name. This is where the Excel Name Box gets really interesting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |