Add and edit tables

A table is a small workspace living inside your note: rows, columns and cells that hold both text and numbers. In this guide you can learn step by step how to add a table to a note, how cells and addresses work, how to manage rows and columns, format numbers, and sort and filter.

Available on all plans
Tables are part of the block editor in Notes. Available on every plan, including Free.
FreeProBusinessEnterprise


A table is a small workspace living inside your note: rows, columns and cells where you can type both text and numbers. A shopping breakdown, an expense list, a score sheet... It earns its keep anywhere numbers need to sit side by side. In this guide you will get to know tables: adding one to a note, how cells work, managing rows and columns, formatting numbers, sorting and filtering. Making the table do the math for you is covered separately in our Calculate with formulas in tables guide.


1
Add a table to your note
On an empty line in your note, type /. A list of blocks you can add appears; pick Table from it. Typing /table or /sheet in the search gets you there too.
When you pick Table, a small square grid opens. Choose how many columns and rows you want; the label underneath shows the size, like "3 × 4". The moment you click, the table is added at that size. Don't worry about picking too few or too many; you can always change the size later.
A1fx
A
B
C
1
2
3
4
/
Image
File
Web bookmark
YouTube
Table
Table
3 × 4
"Table" in the block menu, the size picker, and the empty table added to your note
2
Cells and addresses
Across the top of the table you'll see letters (A, B, C…) and numbers (1, 2, 3…) down the left side. Think of it like the seat number on a cinema ticket: combine which column and which row you're in, and you get the cell's address.
So the first row of the leftmost column is A1, and the second row of the column to its right is B2. When you click a cell, you'll also see its address in the formula bar above the table; you can type and edit the cell's content there as well.
This address logic will come in handy once you start making the table do the math: addresses are how you tell the table which cells to calculate with.
A1fxGroceries
A
B
C
1
Groceries
25
2
Fuel
40
3
Coffee
8
The selected cell's address (A1) and its content, shown in the formula bar
3
Add and delete rows and columns
The size you picked in the grid selector isn't binding. Hover over a column header and a small arrow appears on its right; click it and the menu that opens gives you Insert column left, Insert column right, Delete column and Clear column.
The same goes for rows: right-click a row number and the menu offers Insert row above, Insert row below, Delete row and Clear row. Deleting removes the row or column entirely; clearing leaves it in place and only empties its contents.
B1fx25
A
B
1
Groceries
25
2
Fuel
40
3
Coffee
8
Sort 1→9
Sort 9→1
Filter…
Insert column left
Insert column right
Delete column
Clear column
The column menu, opened from the arrow in the column header
A2fxFuel
A
B
1
Groceries
25
2
Fuel
40
3
Coffee
8
Insert row above
Insert row below
Delete row
Clear row
The row menu, opened by right-clicking the row number
4
Format your numbers
The toolbar sitting along the top edge of the table is where you make the table your own. Turn your numbers into currency with the banknote icon, into percentages with %, and pick how they should be displayed (Automatic, Number, Currency, Percent) from the 123 icon.
With the Bold, italic, text color and bucket (Fill color) icons you can make important rows stand out. Formatting only changes how things look; the number in the cell stays exactly as typed.
% ,0 ,00 123 B I S A Σ
B1fx25
A
B
C
1
Groceries
$25.00
2
Fuel
$40.00
3
Coffee
$8.00
The toolbar · with the numbers formatted as currency
5
Sort and filter
The bigger a table gets, the harder it is to read; that's exactly where sorting and filtering come in. They live in the same place: hover over a column header and click the small arrow that appears on its right.
Sorting greets you at the top of the menu. The labels adapt to what's in the column: a column full of numbers shows Sort 1→9 and Sort 9→1, a column of text shows Sort A→Z and Sort Z→A. Getting the biggest expense to the top is one click. And rest easy: cells never move one by one, the whole row travels together; empty cells always sink to the bottom.
When you only want to see certain rows, pick Filter… from the menu. Two paths open up: Filter by condition lets you set a rule (contains, greater than, between and so on), while Filter by values lays out the column's values as a checkable list. Type what you're after into the Search values… box, tap Select all to tick everything at once, untick (Blanks) to hide empty rows. Apply runs the filter; Clear unticks the list. And when you're done with a filter altogether, the column menu gains Clear filter and Clear all filters, which return the table to how it was.
A1fxFuel
A
B
1
Fuel
40
2
Groceries
25
3
Coffee
8
Sort A→Z
Sort Z→A
Filter…
Insert column left
Insert column right
Delete column
Clear column
The sort and filter menu, opened from the arrow in the column header
Sort A→Z
Sort Z→A
Filter by condition
Filter by values
Search values…
(Blanks)4
ApplyCancel
The filter panel that opens when you pick Filter… from the menu
A table is a block, just like everything else in your note. Hover over it and drag the handle that appears in its bottom-right corner to change the table's display size; double-click the handle to reset it.

And then there is the table's real superpower: you can make cells do the math. Sums, averages, conditional results... We walk through all of it step by step in the Calculate with formulas in tables guide.


Frequently asked questions

Can I change the table's size later?
Yes. Add or delete columns from the arrow menu in the column header, and rows by right-clicking a row number. The size you first picked is only a starting point.
Can a note hold more than one table?
Yes. A table is a block like any other content in your note; add as many as you need and put text and other blocks between them.
Will my rows get mixed up when I sort?
No. Sorting moves whole rows, not individual cells: the 40 next to "Fuel" always travels with "Fuel". Rows with empty cells settle at the bottom either way.
What does Z→A mean, biggest to smallest?
Z→A means reverse alphabetical order in text columns: entries starting with Z at the top, entries starting with A at the bottom. If the column holds numbers, the label becomes Sort 9→1 and it sorts from the biggest number down. In both cases the whole row travels together.
#Table#Notes#Cell#Sorting#Pumpynotes
Was this article helpful?
Get started

Pumpynotes is free. Your plans, notes and budget. Finally together.

Create free account