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.

Excelx.com is a Excel Blog by PNRao to provide latest tips of Excel and help you to Quickly Learn and up-to date with Excel Concepts. We help you to know – how to do things in Excel with Clean and Easy Excel Tips, Shortcuts, Reference, Tutorials and New and Quick Tricks and Methods.

We Provide Free Online Tutorials, Formulas, Templates, Dashboards and Macros to excel in Microsoft Excel. We cover basic to advanced concepts and share creative ideas, Excel tips and Shortcuts with Related Example Files. You Can refer verity of examples covered on latest tools and techniques in Microsoft Excel Applications.