In this 5-minute tutorial, we learn about defining Range and Table in Microsoft Excel. Range in Excel refers to a group of cells that are selected together. This group of cells can be contiguous or non-contiguous. A range can be defined in different ways. Table in Excel is a structured range of cells that includes column headers, data rows, and a footer row for totals. When you format a range of cells as a table, Excel automatically applies a variety of formatting options, such as banded rows, filtering controls, and sorting options.