Excel Define Group Of Cells

The information in this article applies to excel versions 2019 2016 2013 2010 excel online and excel for mac.

Excel define group of cells. Local worksheet level scope. Open up the example workbook. Group and ungroup command keyboard shortcut in excel group.

Click group auto outline. On the formulas tab in the define names group click the define name button. In the new name dialog box specify three things.

If the name total sales has a scope of sheet 1 of a workbook excel will not recognize the name on sheet 2 sheet 3 or any other sheet in the workbook this makes it possible to define the same name for use on multiple worksheets as long as the scope for each name is. Define and use names in formulas. In the scope dropdown set the name scope workbook by default.

In the name box type the range name. Click into any cell then go to the data tab in the ribbon. Contiguous and non contiguous ranges a contiguous range of cells is a group of highlighted cells that are adjacent to each other such as the range c1 to c5 shown in the image above.

Create a named range in excel. Use the name manager in excel. To select non contiguous cells use the ctrl key when selecting them.

A name with a worksheet level scope is valid only for the worksheet for which it was defined. Another way to make a named range in excel is this. The cells don t have to be contiguous.