Create range names from Column and Row headings

- [Instructor] To provide better documentation … for some formulas in Excel you might consider using … what's called a range name. … You can give a name to a single cell … or a group of cells, it can even be multidimensional, … across multiple columns and rows. … If you've got a lift with headings … you can actually create names in a very efficient way. … Let's first remind ourselves how we can create … a range name in a more standard way, … say I just want to give a name to these cells here. … They're related to the California data. … So the standard way to do this could be … either by way of the command that we see … on the Formulas tab up on the ribbon called Define Name. … A faster way to do this is after highlighting the data, … just to the left of the Formula bar, … we'll see the name box, now click the drop arrow … to see if there are any other range names … and there are none in this workbook. … And I'll simply type in California. … Or C-A if I prefer. … No spaces allowed here, you can use underscore, …