![]() Excel can create names automatically (ctrl + shift + F3) Excel will select the range on the worksheet. To quickly test the new range, choose the new name in the dropdown next to the name box. When you press return, the name is created: ![]() Just select a range of cells, and type a name into the name box. Video: How to create a named range Creating a named range is easyĬreating a named range is fast and easy. = MAX (data ) // max value = MIN (data ) // min value = COUNT (data ) // total values = AVERAGE (data ) // min value
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |