Okay, so you created a spreadsheet. To make it easier for your fellow coworkers to use, you implemented range names. And it all works great, that is until you need to change the actual range.
Look at this example. I had created range call Class which spanned across 16 cells representing 16 classes being offered. It worked great until my boss informs me that my school will now be offering 20 classes.
You can download the Excel file here: ClassChoice
How do you change the range to include classes 17-20?
In the Formulas tab of the Ribbon, you will find an icon called Name Manager
Highlight the named range you are working with – (in our case – Class)
Double click
Click on the little box to the right of the Refers to: box
Now highlight the new range
Click OK and OK. Now your range should contain your new cells.
Horizontal data is always a struggle to manage. I always recommend getting your information into a table object as much as possible. Great lesson though Ben.