Similarly, give names to other product range. The first range is named pen and second is named as apr. I want to check the total sales of a particular product for a month and for the entire year.įirst, I’ll create names for a range of data. For example, I have a monthly sales data for each product in my Excel workbook. If you wish to add two words then use an underscore (_) or hyphen (-). Note: The Name of a cell or Range should be a single word. In a range, you will have multiple cells or a group of cells. Naming a range is very similar to naming a cell. You can now use the name in a formula etc. Excel will identify the cell with its name now. Now, the cell A2 (before) has a new name called student. Pressing the Enter key confirms the change and Excel will store the new name. Enter a name in the named box and press the Enter key. To create a named cell, simply select the cell (or set focus on the cell) you want to name and click the Name Box (before the formula box). You can name each cell according to your requirement. By default, cells have names, such as A1, A2 etc., which mean Column A, Row 1 and so on. Here in this post I’ll show you how to create Named Cells and Named Range in Excel and use the names in formulas or even use it for data validation. However, named cells have other useful benefits. Giving a meaningful name to a cell or a range helps understand the data or the set of data it holds. In Excel, you can name a cell or a range of cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |