Large workbooks have two enemies: formulas full of cryptic references, and navigation that costs thirty seconds per trip. RixSheets answers both with two quiet tools — the Name Manager, which gives ranges real names, and Go To with its Special mode, which jumps you to exactly the cells you care about. Around them sit the everyday aids: cell notes, cell warnings, format painter, the symbol dialog and an edit journal that records what changed.
Name Manager: ranges with real names
A named range is a label attached to a reference — monthly_units for B2:B200, vat_rate for the cell holding 0.2, regions for the master list on a setup sheet. The Name Manager is where they live:
- Select the range or cell you want to name.
- Open Formulas, Name Manager and create a new name — letters and underscores, no spaces.
- Confirm the reference the name points to; adjust it if the selection was approximate.
- Write formulas against the name: =SUM(monthly_units), =B10*vat_rate, or a SUMIFS keyed on the regions list.
- When the layout changes, edit the name's reference once in the Name Manager — every formula using it follows.
The payoff compounds: formulas read like sentences, constants live in one named place, and a structure change is one edit instead of a find-and-replace across forty cells. Names also make data validation lists and lookup tables self-documenting.
Names earn their keep in a second, less obvious way: they scope intent. A workbook where =SUM(monthly_units) appears in six sheets is a workbook whose meaning survives personnel changes — the next person reads the name and knows what the number claims to be. Keep a small convention and the workbook documents itself: rates end in _rate, lists get plural names such as regions, and anything a formula hard-codes twice should have been a named cell instead.
Go To and Go To Special
Press Ctrl+G or use Go To on the Home tab, type an address — E947, or monthly_units — and you are there. In a 50,000-row sheet this alone justifies the shortcut.
Go To Special goes further: it selects every cell of a chosen kind in the current selection or sheet:
| Selection | What you get | Typical follow-up |
|---|---|---|
| Blanks | All empty cells in the range | Fill them, flag them, delete their rows |
| Formulas | Every formula cell | Lock them before protecting the sheet |
| Constants | Hard-coded values only | Find numbers that should be formulas |
| Notes | Cells carrying notes | Review annotations before sharing |
Select-by-kind turns tedious audits into two clicks: select the report range, Go To Special, Formulas, and apply locked formatting from the Format Cells dialog in one pass.
The blanks selection deserves its own mention because it answers a question asked constantly in shared workbooks: what is missing? Select a required-columns range, choose Blanks, and every gap gets selected at once — add a fill color to see them, or type a value and press the fill-down key combination to complete all of them in one move.
Notes, warnings and the edit journal
- Cell notes attach comments to cells without touching the data — why a number was adjusted, who approved an override. Cells with notes are findable through Go To Special.
- Cell warnings flag suspicious values, so an outlier in a column of thousands surfaces instead of hiding.
- Format painter copies formatting from one cell to another — set up a model cell once, paint the rest of the column.
- Symbol dialog and icon catalog insert the characters and icons plain typing cannot reach — currency signs, arrows, check marks for status columns.
- Edit journal records recent changes to the workbook, so after a session in a shared file you can see what moved before trusting the numbers.
A navigation habit worth building
Open an inherited workbook: check the edit journal first, then the Name Manager to see what the author named, then use Go To Special to find the formula cells and the notes. Three moves, under a minute, and you know the shape of the file before editing anything.
The same habit scales up to the weekly reality of most offices: files arrive by email, each one the previous person's afternoon of improvisation, and the difference between a five-minute review and a five-hour archaeology is whether the author used these tools. When you are the author, work the same list in reverse — name what you reuse, note what you decided, lock what must not move — and the file you send is one a stranger can trust.
The everyday companions
The Name Manager and Go To sit at the center of a cluster of small tools that make large workbooks livable:
- Cell notes attach context without touching data — why an override happened, who signed off, what a number excludes.
- Cell warnings surface suspicious values automatically, so the outlier in column F is a flag rather than a discovery next quarter.
- Format painter propagates a well-formatted model cell across a column in one stroke.
- Symbol dialog and icon catalog cover the characters and markers plain keys cannot type — currency symbols, arrows, check marks, the odd mathematical operator.
- Clipboard as TSV pastes a selection into email, chat or another table with columns intact, which is how spreadsheet answers actually travel between tools.
Individually these are conveniences; together they are the reason a 60,000-row workbook stays navigable by one person on a Tuesday afternoon.
If the formulas themselves look like a foreign language, the AI chat panel can explain any of them, and the formula guide covers the engine underneath.
What to explore next
- Formulas and functions — put those named ranges to work.
- Format Cells dialog — lock formula cells visually and literally.
- RixSheets AI chat panel — ask questions about an unfamiliar workbook.
- Pivot tables in RixSheets — summarize what Go To Special helped you find.