---
title: Filter Ranges in Jet Reports
description: "### How to Use \"..\" Filter Ranges Safely When working with filter ranges in Excel especially when using tools like [Jet Reports](https://globaldata365.com/jet-reports/), it's crucial to understand how Excel interprets ranges with the `..` notation.   #### Always Use Quotes for…"
url: "https://globaldata365.com/helpcenter/filter-ranges-in-jet-reports/"
updated: "2025-07-06"
category: Jet Reports
---

# Filter Ranges in Jet Reports

### How to Use ".." Filter Ranges Safely

When working with filter ranges in Excel especially when using tools like [Jet Reports](https://globaldata365.com/jet-reports/), it's crucial to understand how Excel interprets ranges with the `..` notation.

 

#### Always Use Quotes for ".." Ranges in Formulas

If you’re entering a range like `49950..59950` directly into a formula or within Excel’s function wizard, make sure to enclose it in quotation marks, like this:

  `"49950..59950"`

 

#### Why Are Quotes Important?

Without quotes, Excel doesn’t treat `49950..59950` as a simple text string. Instead, it tries to evaluate it as a reference to every cell from row **49,950 through 59,950**. Considering Excel has **16,384 columns per row**, that results in more than 163 million cells!

 

The result? Excel starts an intensive calculation that can significantly slow down your system—or even freeze it entirely. In most cases, you'll need to **manually end the Excel process** to regain control. If you're unsure how to do that, it's best to consult your IT team.

 

#### Important Note for Jet Reports Users

This behavior is not caused by Jet Reports it's a default feature of Excel. However, because Jet Reports users frequently enter value ranges using `..`, they are more likely to trigger this issue by accident.

![filter ranges in jet reports](https://globaldata365.com/wp-content/uploads/2023/12/AX024-Jet-Analytics-Quantity-on-Hand-by-Location-v2.0-300x165.webp)
Jet Analytics - Quantity on Hand by Location

#### Best Practices

- **When typing a range directly into a formula or parameter:**
  ➤ Always use quotes: `"1000..5000"`
  ✅ Excel treats this as a text string.
- **When referencing a cell that contains a range string (e.g., `A1 = 1000..5000`) in your formula:**
  ➤ You **do not** need to manually add quotes.
  ✅ Excel reads the value from the cell as a string.

 **Looking to simplify financial reporting in Excel?** [👉 Join our Jet Reports Training](https://globaldata365.com/jet-reports-training/) and learn to create real-time, dynamic reports with confidence.

#### Summary

To avoid unnecessary delays, slowdowns, or system crashes:

- Enclose ranges with `..` in quotes when entering them directly.
- Let cell references handle the quotes automatically.
- Be mindful of how Excel interprets range values.

By following these simple precautions, you can use range filters safely and efficiently—whether you're working in[Excel](https://youtu.be/ahSlvDFbEQM?si=duDZdXjxLlYDRFq0) alone or with Jet Reports.

 

#### If You Need Any Help, [Contact us](https://globaldata365.com/contact/) Now!

[wpforms id="13267"]