Formatting a Range of Cells

This topic also belongs to the series of topics related to the application of font settings and other formatting styles on cells. Our previous topics have covered handling such features well. For example, you can refer to Changing the Font & Color of a Cell and Applying Styles on Cells topics to learn about the same features. So what is new in this topic if we have already covered these concepts? Well, the only difference between this topic and the previous ones is that we will apply formatting settings (related to fonts and other styles) on a range of cells instead of just a single cell. We hope you will still find this topic useful.

Setting Font & Style of a Range of Cells

Before we talk about formatting settings (which we have already discussed extensively in our previous topics), we should know how to create a range of cells. We can create a range of cells using the CellRange class, whose constructor takes parameters to specify the range of cells. We can specify the cell range using the Names or Row & Column Indices of the start and end cells.

Once we have created a CellRange object, we can use the overloaded versions of SetStyle, SetFont, and SetFontColor methods of Worksheet that accept a CellRange object to apply formatting settings to the specified range of cells.

Let’s check out an example to understand this basic concept.