Help
Everything Nought does, and how to reach it. If something here doesn’t match what you’re seeing, email hello@nought.app and tell me — either the app or this page is wrong, and I’d like to know which.
Getting started
Nought edits your file in place. There is no import step and no library: open a spreadsheet, change it, save it back as what it was.
1. Open a file, or start fresh
Launch Nought and open any .xlsx, .xlsm, .ods or .csv file. Or start with a blank workbook.
2. Navigate and edit
Click a cell or use the arrow keys. Start typing to replace the contents. Press ↩ to commit and move down, ⇥ to commit and move right.
3. Use formulas
Type = then a function name. Autocomplete suggests matching functions as you type; click one to insert it. Or click the fx button in the formula bar to pick a function and fill in its arguments in a guided panel.
4. Format your data
Use the toolbar for bold, italic, colours, borders and number formats. Select cells first, then apply formatting.
5. Save and export
⌘Ssaves in the original format; if the file contains something Nought cannot write back, it tells you before overwriting. Use File > Export as PDF (⇧⌘E) for a printable version with charts, or right-click a chart to export it on its own as PNG or SVG.
Formulas and charts
Entering a formula
Select a cell and type = followed by your formula, then press ↩. Autocomplete shows matching function names as you type. You can also click the fx button in the formula bar to browse and search the function library by category.
Inserting a chart
Select a data range, then click Insert in the toolbar and choose Chart. Pick a chart type in the dialog and click Insert. Charts can be moved, resized and edited after insertion.
Sorting, filtering and panes
Freezing rows and columns
Select the cell just below the rows and just right of the columns you want frozen, then open the Data menu in the toolbar (the up/down arrows) and choose Freeze Panes. You can also right-click a column header. Choose Unfreeze Panes from the same menu to release it.
Sorting and filtering
To sort, select the range first, then use the Data menu in the menu bar: Sort Ascending, Sort Descending, or Custom Sort for a multi-level sort by values, colour, dates, or a custom list. Each menu item shows the range it will act on. The same commands are in the toolbar’s Data menu (the up/down arrows).
To filter, click the funnel button in the toolbar to turn on AutoFilter, then use the dropdown arrow on any column header to filter by values or by a condition (contains, equals, greater than, between), with a search box and multi-select.
Files and formats
What Nought reads and writes
Nought reads and writes .xlsx and .xlsm (Excel, including macro-enabled), .ods (OpenDocument) and .csv files. It exports to PDF, and any chart to PNG or SVG. When you open a .xlsxfile, Nought edits it in place and saves it back — no import or export step needed.
CSV files that are not in UTF-8
Nought works out a CSV’s encoding from its contents, which matters because a .csv carries no record of how it was written. UTF-8 and UTF-16 are recognised from their byte order mark or their shape; beyond those it recognises the Windows and ISO code pages, including Hebrew and Arabic, which before 1.0.33 it could not read at all and which came through as nonsense.
If a file still opens as the wrong characters, it is a code page nothing here covers. Send it to hello@nought.app: a file that opens correctly somewhere else and not in Nought is the only thing that fixes this properly.
Choosing the format new spreadsheets are saved in
Settings > Formats sets which format the save panel offers first for a new spreadsheet — .xlsx or .ods. It does not change existing files: open an .xlsx and save it and it stays .xlsx, because a workbook quietly changing type would be worse than the setting is useful.
Very large workbooks
Nought caps how much of a very large sheet it will hold in memory, so a file with an enormous stated range cannot exhaust it. If a workbook is too big to open completely, Nought says so on opening and names what it could not show.
A workbook in that state will not save over its original, because what is in memory is only part of it. Use File > Save As to write what you can see to a new file, and your original stays whole.
What survives a round trip
Nought preserves formatting, formulas, charts, conditional formatting, data validations, merged cells, frozen panes, pivot tables and sheet structure when opening .xlsx files. Macro-enabled workbooks (.xlsm, .xltm) open too: Nought does not run VBA, but the macro code is kept unchanged when you save back as .xlsm. Power Query is not yet supported, and Nought warns you before a save would drop anything it cannot write back.
Appearance and launch
Light and dark
By default Nought follows your system appearance, but you can override it in Settings > General > Appearance and choose Follow System, Light, or Dark.
Where the window opens
Where you left it. Move the window, resize it and quit, and it comes back at that size in that place rather than at whatever size macOS picks.
What happens on launch
In Settings > General > On launch, choose Reopen last document. You can also start with a blank spreadsheet or show the Open dialog.
Shortcuts
Navigation
- Move one cell
- Arrow keys
- Move right / left
- ⇥ / ⇧⇥
- Move down / up, committing the edit
- ↩ / ⇧↩
- Jump to cell A1
- ⌘Home
- Jump to the last used cell
- End
- Jump to the edge of the data region
- ⌘Arrow
- Scroll one screen
- Page Down / Page Up
- Click the cell reference box, type a ref, press ↩
- Name box
Editing
- Replace the cell contents
- Start typing
- Edit the selected cell
- F2
- Cancel editing
- ⎋
- Clear the selected cells
- ⌫
- Delete the selected rows
- ⌘⌫
- Fill down / fill right
- ⌘D / ⌘R
- Fill down to the end of the data
- Double-click the fill handle
- Merge cells
- ⇧⌘M
- Cycle absolute and relative references while editing
- F4
- Toggle a checkbox cell
- Space
- Undo
- ⌘Z
- Redo
- ⇧⌘Z
Selection
- Extend the selection one cell
- ⇧Arrow
- Extend the selection to the clicked cell
- ⇧Click
- Select all cells
- ⌘A
- Add another block to the selection
- ⌘Click
- Select the whole row
- Click a row header
- Select the whole column
- Click a column header
Clipboard
- Copy, showing marching ants
- ⌘C
- Cut
- ⌘X
- Paste, with formatting and formula adjustment
- ⌘V
- Paste Special
- ⇧⌘V
- Clear the marching ants without pasting
- Esc
Formatting
- Bold
- ⌘B
- Italic
- ⌘I
- Underline
- ⌘U
Inserting
- Insert a chart
- ⌥⌘C
- Insert a link
- ⌘K
- Today's date / the current time
- ⌘; / ⇧⌘;
Data
- Turn AutoFilter on or off
- ⇧⌘L
- Format as Table
- ⌘T
Columns and rows
- Insert a row above / a column left
- ⇧⌘R / ⇧⌘C
- Auto-fit the column to its content
- Double-click a column border
- Resize the column by hand
- Drag a column border
- Insert or delete rows and columns
- Right-click
View
- Zoom in / out
- ⌘+ / ⌘-
- Reset the zoom to 100%
- ⌘0
- Zoom from 25% to 400%
- Pinch or ⌥scroll
- Find. The toggle in the Find bar shows Replace
- ⌘F
- Show formulas instead of values
- ⌃`
- Show or hide the inspector
- ⌥⌘I
Sheets and files
- Previous / next sheet
- ⌘PageUp / ⌘PageDown
- Export as PDF
- ⇧⌘E
The toolbar reaches most of the same places with the mouse, and the Data menu in the menu bar names the range each command will act on before you run it.
Questions
Does Nought need the internet?
No. Everything runs locally on your Mac. There is no account, no login, no sync and no telemetry. The only traffic Nought is involved in is Apple’s own purchase check, made by the system when you open the Licence tab or buy.
Is Nought really free?
Nought is free to download and fully functional for 14 days. After that it becomes read only until you buy it: your files still open, scroll and print, but editing and saving stop. The purchase is $9.99 once, not a subscription, and it is yours for good. Anyone who had Nought before version 1.0.28 keeps it free permanently.
What does it run on?
macOS 14 (Sonoma) or later. Nought is a universal binary: native on Apple Silicon (M1 through M4) and on Intel Macs.
Is Nought signed and notarised?
Yes. Nought is code-signed with a Developer ID certificate and notarised by Apple. It launches without any Gatekeeper warnings.
Something's wrong, or missing
Use the feedback form, or email hello@nought.app. Every piece of feedback is read and shapes what gets built next.
For a bug report it helps to include your macOS version, the Nought version (Nought > About Nought), a diagnostics file (Help > Save Diagnostics), and the file you were working with if you can share it.
See also what’s new, the feature list, and the privacy policy.