An array is just a list or range of values, but an Array Formula is a special type of formula that must be entered by pressing Ctrl+ Shift+ Enter. The result may fit in a single cell or it may be an array. Therefore, if you want to remove an array formula from a range of cells you need to highlight the whole cell range, and then press the delete key.In Excel, an Array Formula allows you to do powerful calculations on one or more value sets. You must delete the formula from all of the cells that it occupies.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |