# Reset Reset option allows you to remove or revert any changes that have been made to a particular cell or range of cells, and restore them to their original state. Plan provides various reset options such as Reset formats, Reset value, Reset notes and Reset all. * Reset formats: This option removes any formatting that has been applied to the cells, such as font color, font size, and cell borders. * Reset value: This option resets any changes to the cell values. * Reset notes: This option deletes all the notes added to the report. * Reset header order: This option restores the ordering of header categories. * Reset row order: This option reverts to the original ordering of row categories. * Reset all: This option removes all the changes to the report including formatting, data edits, charts, filtering etc., and restores it to the original state. In the 'Home' tab of the toolbar, select the 'Reset' icon from the 'Actions' section. You can see that, except for the Reset Formats and Reset Notes options, all other options are disabled. To enable them, you need to select one or more cells with formats applied or edited values.

### **1. Reset formats** In the below example, you can see some cells formatted with background and font color. Select one or more cells with formatting applied. Click 'Reset formats' to remove the format.

The formatting has been reset.

{% hint style="info" %} Reset format is not applicable for conditional formatting, semantic formatting and the other formatting options available in 'Display settings'. {% endhint %} To reset formatting for the entire table, select the entire table (Ctrl + A) and reset all formatting.

Reset Formats by selecting the entire table

### **2. Reset value** In the below example, you can see that two values are edited in '2021 Actuals'. Select the cells with edited values. Click 'Reset value' to restore the value.

The cells have been restored to their original values.

### 3. Reset notes In the below example, you can see that there are several notes added to the report. Click on 'Reset notes' to remove all the notes.

In case you want to delete only selected notes and not all the notes, use the delete icon corresponding to the notes when you hover over them as shown in the image below

All the notes have been removed.

### 4. Reset Header order Reset Header Order option helps to re-order columns. If you have re-ordered the fields for analysis, you can easily revert to the original sequence using the ‘Reset Header order’ option. Here March column is re-ordered.

The columns after Reset Header order.

### 5. Reset Row order If you have re-ordered the rows in your reports, you can use this option to quickly restore the original order as configured in your data model. Note that sort cannot be used if the row order has been modified - you can apply this option if you need to revert to sorting. Notice how the product names are re-arranged when the Reset Row order option is clicked.

In the next section, we'll start with [adding business logic and formula](https://github.com/lumelinc/PowerTableDocs/blob/main/working-with-inforiver/4.-adding-business-logic-and-formulae). --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.fabricplan.com/planning/working-with-lumel-epm/3.-basic-interactions/actions/reset.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.