Create Range Names 1 Select a range of cells in your spreadsheet (for example, in our sample, select B4B13) 2 From the Formulas tab, click Define Name 3 Notice that ExcelWill work only for public named ranges Without brackets If you want to refer a regular range or a named range declared on specific sheet, though = WorkbookNameSheetName!Range It also seems, like quotes or anything like that to manage spaces may be required only in Excel's cells, that is in UI (and may be locale specific, since on my PCOn the Formulas tab, click Define Name in the Defined Names group In the Name box, type Sales In the Refers to box, type "=OFFSET ($B$2,0,0,COUNTA ($B$B)1)", and then click OK Clear cell B2, and then type "=RAND ()*010"
Named Range In Excel How To Create Named Range In Excel