Getting Started
Click any cell and start typing to enter data. Press Enter to confirm and move down, or Tab to move right. Double-click or press F2 to edit an existing cell.
Formulas
Start with = to write a formula. Examples:
=SUM(A1:A10) — Add up a range=AVERAGE(B1:B5) — Average of cells=TODAY() — Current date=NOW() — Current date & time=IF(A1>10, "High", "Low") — Conditional logic=VLOOKUP(A1, B1:C10, 2) — Lookup values
Quick Formulas: Select a range of cells, right-click, and choose Quick Formula to instantly apply SUM, AVERAGE, COUNT, etc. Then click any cell to place the result.
Click to reference: While typing a formula, click any cell to insert its reference automatically.
Dates & Deadlines
Right-click a cell to access date features:
- Insert Today's Date — Inserts
=TODAY() which always shows the current date
- Pick a Date... — Opens a calendar to choose a specific date
- Toggle Deadline — Marks a date cell as a deadline. The cell will change color automatically:
2+ weeks
1-2 weeks
6-7 days
3-5 days
1-2 days
Today
Overdue
You'll also get browser notifications when a deadline is within 2 days or overdue. Make sure to allow notifications when prompted.
Saving & Opening Files
- Save (Ctrl+S) — Downloads a
.qx file (native format, keeps all formatting & formulas)
- Open (Ctrl+O) — Open
.qx, .csv, .xlsx, or .xls files
- Export CSV — Download as CSV (current sheet only)
- Export Excel — Download as
.xlsx with formulas preserved
Your work is also auto-saved to your browser, so it persists between sessions.
Install as Desktop App
You can install Anomaly Quantix as a standalone app so files open directly in it:
- Open this site in Chrome or Edge
- Click the install icon in the address bar (or Menu → "Install Anomaly Quantix")
- Once installed, right-click any
.qx file → Open with → Anomaly Quantix
- To make it the default: right-click a
.qx file → Properties → Opens with: Change → select Anomaly Quantix
Auto-Fill
Select a cell and notice the small square handle at the bottom-right corner. Drag it down or right to auto-fill adjacent cells.
- Numbers: Detects patterns — 1, 2, 3 continues as 4, 5, 6. Also works with 2, 4, 6 → 8, 10, 12
- Text: Copies the value to each cell
- Formulas: Adjusts cell references automatically —
=A1+B1 becomes =A2+B2 when dragged down
- Dates: Increments by one day
- Day/Month names: Mon, Tue, Wed... or Jan, Feb, Mar... continues the sequence
Column Filters
Click the Filter button in the toolbar to enable filter mode.
- Small dropdown arrows appear on each column header
- Click an arrow to see all unique values in that column with checkboxes
- Uncheck values to hide rows containing them
- Click Clear in the dropdown to remove the filter for that column
- Click the Filter button again to turn off all filters
Cell Comments
Add notes to any cell without changing its value:
- Right-click a cell → Add Comment...
- Cells with comments show a small red triangle in the top-right corner
- Hover over the cell to read the comment
- Right-click again to Edit Comment or Delete Comment
- Comments are saved with your file
Print
Click the Print button in the top bar to print your spreadsheet.
- The toolbar, formula bar, and other UI elements are automatically hidden
- Cells are printed with a clean white background and black text
- The file name is shown as the page header
- You can also Save as PDF from the print dialog
- Tip: To remove the URL and date from the top/bottom of printed pages, uncheck "Headers and footers" in the print dialog under More settings
Hide Rows & Columns
- Right-click a cell → Hide Row or Hide Column
- A double line indicator shows where rows or columns are hidden
- To unhide: right-click a cell next to the hidden area → Unhide Adjacent Rows or Unhide Adjacent Columns
Drag & Drop
Move a row:
- Click and hold on a row number (left side)
- Drag up or down to the target position
- Release to drop — the row and all its data will be moved
Move a block of cells:
- Select a range of cells (click and drag, or Shift+Click)
- Click inside the selected range and drag to a new position
- A dashed outline shows where the block will land
- Release to drop — all data, formatting, and formulas move together
Theme Toggle
Click the sun/moon icon in the toolbar to switch between dark and light mode. Your preference is saved automatically.
Autocomplete
When typing in a cell, the app suggests matching values from the same column:
- Type 2 or more characters to see suggestions
- Use ↑ ↓ arrow keys to navigate suggestions
- Press Tab or Enter to accept a suggestion
- Press Escape to dismiss
Multi-Select
Select scattered cells for formulas:
- Hold Ctrl and click individual cells to select multiple
- Right-click → Quick Formula to apply SUM, AVERAGE, etc. across all selected cells
- Click a cell to place the result
Charts
Create visual charts from your data:
- Select your data range, then click Chart in the toolbar
- Choose chart type: Bar, Line, or Pie
- Set the data range and title
- Place at cells (e.g.
D1:I12) to anchor the chart to the grid, or leave empty for a floating chart
- Floating charts can be dragged and resized
- Click ↻ to refresh chart data, × to remove
Other Features
- Formatting: Bold, italic, underline, text/fill colors, alignment
- Cell merging: Select cells and use the merge button in the toolbar
- Conditional formatting: Right-click → Conditional Format to highlight cells by rules
- Data validation: Right-click → Data Validation for dropdowns or number ranges
- Find & Replace: Ctrl+F to find, Ctrl+H to replace
- Sort: Right-click a column → Sort A→Z or Z→A
- Freeze panes: Right-click → Freeze Above & Left
- Multiple sheets: Click + at the bottom to add sheets, double-click to rename
- Smart Format: Auto-detects and formats your data (numbers, dates, currencies)
- Templates: Pre-built spreadsheet layouts to get started quickly
