Normally, most of us may create the names one by one, but, if you are familiar with Excel, with its Create from Selection feature, you can create the names by the row and column headers at once Create multiple names from selection with Create from Selection feature WebExcel isn't the same as client Excel (as you've noted), so some functionality isn't there (yet) The name box is one of those things You cannot define range names in web excel But you can press controlg to goto names How to use the OFFSET formula with a defined name To do this, follow these steps, as appropriate for the version of Excel that you are running Microsoft Office Excel 07, Microsoft Excel 10 and Microsoft Excel 13 In a new worksheet, enter the following data
Excel Names And Named Ranges How To Define And Use In Formulas