How to Create Variable Names for Rows and Columns in an Excel Spreadsheet Shortcut
I forgot to mention in the video that pressing Tab will autofill the variable name once you begin typing it.
Also, Column is my spelled in step 5.
Here are the setup steps as shown in the video
1. Select a cell inside your table
2. CTRL + A or highlight the whole table manually
3. Click on the formulas tab
4. Go to defined names - create from selection
5. Check boxes for where your column and/or row names are
6. Check work by going to Formulas - Defined Names - Name Manager
Thanks again for watching!