This section provides different ways to create named ranges in spreadsheets. 1  Select the cell range and click to open the Define Names window. 2  Enter the name for the range in the Name field.  Click OK to close the window.