I've tried holding down control from the second cell and continuing to hit each cell in the order I want and then going back to the first cell, creating a name in the cell name box, then hitting enter but this hasn't worked. I'm using Excel 2011 for mac. Hoping it's something simple I'm just not doing!