What is Range in Excel

Excel range is the worksheet object contains one or more Cells. A Range in the Excel worksheet can also contain information such as strings, numbers, shapes and charts. We can store verity of the data in the Excel Ranges.


We can format the data in the range using the built-in format commands. There are variety of commands available for formatting the ranges in the worksheet. We can format the text in the range to bold, underline and make it italic. We can change the font size, font styles and font color.

The range in the worksheet is very helpful for storing the data in a table format. A Worksheet contains rows and columns, combination of each row and column is called a Cell. And the collection of Cells is called a Range. A Range is represented with rows number and column name information. For example A1, B12, C5:E20.