> For the complete documentation index, see [llms.txt](https://docs.roboteasy.tech/studio-en/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roboteasy.tech/studio-en/studio/objetos/excel/colorir-celulas/selecionar-range.md).

# Select Range

Object to select a range of cells to be colored.

## Settings 

![](https://1031980850-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRKcZBCSfHjT8BRPnSe%2F-MWV0my2gh3JDpZHo7Uc%2F-MWVgJMyOC9mJavIt1Jn%2Fimage.png?alt=media\&token=8daacb00-93a0-412f-849f-0cc10d8a9a05)

| Field              | Descriptive                                                                                                                                 |
| ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------- |
| Title              | Object Title                                                                                                                                |
| Select Main Object | Option to select an Excel sheet                                                                                                             |
| Background         | Opção para selecionar a cor de fundo da célula - Option to select the cell's background color                                               |
| Font               | Option to select the cell's font color                                                                                                      |
| Select Range       | Allows you to enter a range of cells                                                                                                        |
| Starting Column    | Initial column of the cell range that will be colored                                                                                       |
| Final Column       | Final column of the cell range that will be colored. If none is set, the last column of the spreadsheet will be considered as the final one |
| Starting Row       | Initial row of the cell range that will be colored                                                                                          |
| Final Row          | Final row of the cell range that will be colored. If none is set, the last row of the spreadsheet will be considered as the final one       |

## Example

To colorize the cells of an Excel spreadsheet, you can select a range:

1 - Select the "**Open Excel**" object from the "**Excel**" menu and drag it to your working area.

* First you must define a unique name for the object in the "Object Identifier Name" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.

2 - Then select the **"Select Sheet**" object from the **"Excel**" menu, select the main object defined when opening the Excel file and then define the name of the sheet you wish to select.

3 - Then you must select the **"Colorize Cells"** object in the "**Excel"** menu, select the main object, select the color for the cell's background and the color of the font to be used and click on the "**Select Range**" option. Finally, inform the columns and rows corresponding to the cells you wish to colorize.