# Spreadsheet performance

If a spreadsheet is taking a long time to import or its performance seems slow, it may contain redundant information. You can take the following steps to increase the performance of your spreadsheet.

Excel saves the parts of each worksheet that contain data and/or formatting. However, empty cells that don’t contain data, but do contain formatting, bloat the saved file. When imported into Squirrel a bloated file will take longer to load and will perform more slowly.

To remedy this, open the file in Excel and use the key combination CTRL+END on each sheet. The cursor will move to the cell that Excel considers to be the last cell in the sheet. Usually, this will be a cell with data in it that is furthest down and to the right in the sheet, however, due to redundant formatting, this can sometimes be a cell beyond the range of the data.

Select the rows and columns outside of the data range that contain formatting information. Then, from the menu bar select:

Home > Editing > Clear > Clear All

<figure><img src="https://addons.squirrel365.io/learn-assets/uploads/2020/12/excel-clear-menu.png" alt=""><figcaption></figcaption></figure>

Repeat this for all affected sheets, save the file, and then import the workbook into Squirrel.

For more details on the clearing process see the Microsoft documentation [here](https://support.microsoft.com/en-us/office/locate-and-reset-the-last-cell-on-a-worksheet-c9e468a8-0fc3-4f69-8038-b3c1d86e99e9).


---

# 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://learn.squirrel365.io/troubleshooting/spreadsheet-performance.md?ask=<question>
```

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.