How to Open a Database Record in Notion
Windows: Click row, or Enter with row focused
Mac: Click row, or Enter with row focused
Clicking anywhere on a database row (outside of a specific editable cell), or pressing Enter with a row focused via keyboard navigation, opens that row as its own full Notion page — this is the single most important thing to understand about how Notion databases actually work under the hood.
**Every row is a real page**: Unlike a spreadsheet row, which is just a line of cell values, a Notion database row is a complete page object with its own URL, its own permissions, and the ability to hold any freeform block content — paragraphs, images, embedded sub-databases, anything a normal page can hold — beneath the structured property values shown in the table. The property columns you see in table view (status, due date, assignee) are just the page's properties displayed as columns; the page itself can contain far more than what's visible in the table row.
**Two ways to view a row**: Clicking a row typically opens it as a full-page view by default, replacing your current view entirely, while some Notion configurations or a small expand icon that appears on hover instead open the row in a side-peek panel that overlays the current view without navigating away from it — the side-peek is often faster for quickly checking or editing one record before returning to the table, since you don't lose your place in the underlying view.
**Editing properties from within the opened record**: Once a row is open as its own page, its properties appear at the top in the same editable format as they do in the table's cells — editing a property value here updates the exact same underlying data reflected back in the table view, since there's only ever one copy of that data regardless of which view or page you're editing it from.
**Related shortcuts**: Arrow keys and Tab move the focused cell around the table without opening a row, useful for quickly scanning or editing several property values in sequence without the extra step of opening and closing each row as a full page. Ctrl+Enter creates an entirely new row rather than opening an existing one.
**Common mistake**: expecting a database row to behave like a compact edit form the way a typical spreadsheet or lightweight CRM record might — since a Notion database row is a genuine page, closing out of an opened record and returning to table view is functionally the same as navigating back from any other Notion page, and any content you added beneath the properties (notes, sub-tasks, images) persists as part of that page just like it would on any other page in the workspace.
**Why this matters for how you structure a database**: because every row can hold substantial freeform content beyond its properties, a Notion database works well not just as a simple structured list (like a spreadsheet) but as a genuine collection of related pages — a project tracker where each task row is also a full page containing the task's detailed notes, a content calendar where each row is also the full draft of that piece of content, a CRM where each contact row is also a page holding meeting notes and call history for that specific person.