Excel: Define range - how to select specific cells

In the Excel spreadsheet program, you have the option to define a range. You define a range by assigning a name to it. A range can contain only one cell or several cells. Once you have defined your range using names, you can manage it more easily.

How to define a range in Excel

If you want to define a specific range in Excel, then this is possible with the help of assigning a name. These ranges can consist of one or more cells. Once you have assigned a name to a range, you have options to manage it more easily. You can name a single cell by selecting it. You will then see a name field at the top. Here you can now enter your own name and confirm it with the Enter key. For multiple cells, however, you must proceed differently.

1. Mark all cells that you want to combine into one range. Be sure to include the row or column range headers as well.
2. Then go to "Formulas" and now to the "Create from selection" option.
3. In the "Create names from selection" area, you can activate one of the checkboxes. Here you have the options "Top row", "Left column", "Bottom row" and "Right column" to choose from. This specifies which label will be used for the name afterwards.
4. Confirm the selection with "Ok".