How to make a table in “Notes” on Mac

Apple Notes Table
Updated : Sep 11, 2021

I will explain in detail how to create / edit / delete a table in “Notes” app on Mac using illustrations.

I will also explains how to sort, add / delete rows and columns, and exchange data with other apps.

The following explanation is given in the following environment.

Please note that there are some differences depending on the version of macOS.

  • macOS Big Sur 11.4

Add a table

▶ In the “Notes” app, click where you want to add a table.

Mac "Notes" Add a table

 

▶ To add a table, do one of four things:


①. From the toolbar, click the “Add a table” icon

Macの「メモ」で、ツールバーの「表を追加」をクリック


②. Select “Add Table” from the right-click menu

Mac "Notes" Add a table


③. Select “Format” – “Table” from the menu bar

Mac "Notes" Add a table


④. Use the keyboard shortcut option ⌥ + command ⌘ + T

Mac "Notes" Add a table


 

▶ When the table is added, it displays a 2 row x 2 column table by default.

Mac "Notes" Add a table

 

Enter / edit data in cells

  • To enter / edit data in a cell, click inside the target cell.

Mac "Notes" Enter / edit data in cells

 

  • You can move between cells in the following ways:
Keyboard operation Operation result
tab You can move to the right,
if at the right end,
move one line down to the left end
shift + tab You can move to the left,
if it is the left end,
move to the right end one line up
enter You can move down one line
shift + enter You can move up one line
or or or The movement is the same as tab
and enter in the direction
of the arrow.

 

It may be difficult to understand if it is only letters, so I will give an example.

The figure shows the cells in the table with 2 rows and 2 columns, but if you press tab continuously from the cell from the upper left, the movement will be as shown in ① to ④ below.

Macの「メモ」で、tabキーの連続した動き

 

Restrictions on data entered in cells

Unlike typing elsewhere in the “Notes” app, the data you enter in a table cell has the following restrictions:

Things possible Things impossible
New line
(Hold down option and return)
Indent
(Lower line)
Add URL link Paragraph style
(Title / Heading / Subheading)
Font
(Type / Size / Color)
List
(Bullets / Dashed /
Numbered / Checklist)
Font style
(Bold / Italic /
Underline / Strikethrough)
Paste / attach images and files
Text alignment
(Left / Center /
Justified / Right)

By the way, to input a line break, perform the following keyboard operations.

  • option ⌥ + return(enter)

Mac "Notes" app New line with keyboard

 

Copy the table (copy and paste)

▶ Leaves the entire table selected.

The method is to do one of the following two operations.


①. With the mouse / trackpad, drag the entire table from the left or right edge of the table


②. Click inside any cell and execute the keyboard shortcut command ⌘ + A once or twice
(Twice for cells with characters, once for empty cells)

Mac "Notes" app Select table

The following video shows the keyboard shortcut executed.


 

▶ When the entire table is selected, the cell background color changes.

【The entire table is not selected】

Mac "Notes" app Select table

【The entire table is selected】

Mac "Notes" app Select table

 

▶ Copy the table to the clipboard.

The method is to do one of the following two operations.


①. Execute the keyboard shortcut, command ⌘ + C

Mac "Notes" app Select table


②. Select “Edit” – “Copy” from the menu bar

Mac "Notes" app Select table


 

▶ Click directly where you want to paste or move the cursor.

Mac "Notes" app Copy & Paste the table

 

▶ Paste the table from the clipboard.

To do this, do one of the following three operations.


①. Execute the keyboard shortcut, command ⌘ + V

Mac "Notes" app Copy & Paste the table


②. Select “Edit” – “Paste” from the menu bar

Mac "Notes" app Copy & Paste the table


③. Select “Paste” from the right-click menu

Mac "Notes" app Copy & Paste the table


 

Cut and paste the table

“Cut and paste the table” and “move the table” are very similar.

However, the difference is that the former can be pasted into another note, while the latter is only in the same note.

▶ Leaves the entire table selected.

The method is to do one of the following two operations.


①. With the mouse / trackpad, drag the entire table from the left or right edge of the table


②. Click inside any cell and execute the keyboard shortcut command ⌘ + A once or twice
(Twice for cells with characters, once for empty cells)

Mac "Notes" app Select table

The following video shows the keyboard shortcut executed.


 

▶ When the entire table is selected, the cell background color changes.

【The entire table is not selected】

Mac "Notes" app Select table

 

【The entire table is selected】

Mac "Notes" app Select table

 

 

▶ Cut the table to the clipboard.

The method is to do one of the following two operations.


①. Use the keyboard shortcut, command ⌘ + X

Mac "Notes" app Cut & Paste the table


②. Select “Edit” – “Cut” from the menu bar

Mac "Notes" app Cut & Paste the table


 

▶ Click directly where you want to paste or move the cursor.

Mac "Notes" app Copy & Paste the table

 

▶ Paste the table from the clipboard.

To do this, do one of the following three operations.


①. Execute the keyboard shortcut, command ⌘ + V

Mac "Notes" app Copy & Paste the table


②. Select “Edit” – “Paste” from the menu bar

Mac "Notes" app Copy & Paste the table


③. Select “Paste” from the right-click menu

Mac "Notes" app Copy & Paste the table


 

Move the table

“Cut and paste the table” and “Move the table” are very similar, except that the former can be pasted into another memo, while the latter is only in the same memo. there is.

▶ Leaves the entire table selected.

The method is to do one of the following two operations.


①. With the mouse / trackpad, drag the entire table from the left or right edge of the table


②. Click inside any cell and execute the keyboard shortcut command ⌘ + A once or twice
(Twice for cells with characters, once for empty cells)

Mac "Notes" app Select table

The following video shows the keyboard shortcut executed.


 

▶ When the entire table is selected, the cell background color changes.

【The entire table is not selected】

Mac "Notes" app Select table

【The entire table is selected】

Mac "Notes" app Select table

 

▶ Click and hold the colored part of the selected table with the mouse / trackpad, then  drag and drop it to the destination.

The following is explained in the video.

 

Delete the table completely

“Delete the table completely” and “Erase the cell contents” are very similar, but the former deletes the table itself, while the latter does not delete the frame of the table but only the contents of the cell.

▶ Leaves the entire table selected.

The method is to do one of the following two operations.


①. With the mouse / trackpad, drag the entire table from the left or right edge of the table


②. Click inside any cell and execute the keyboard shortcut command ⌘ + A once or twice
(Twice for cells with characters, once for empty cells)

Mac "Notes" app Select table

The following video shows the keyboard shortcut executed.


 

▶ When the entire table is selected, the cell background color changes.

【The entire table is not selected】

Mac "Notes" app Select table

【The entire table is selected】

Mac "Notes" app Select table

 

▶ Press delete on your keyboard to delete the table.

Mac Us Keyboard "delete"

 

Erase the cell contents

“Delete the table completely” and “Erase the cell contents” are very similar, but the former deletes the table itself, while the latter does not delete the frame of the table but only the contents of the cell.

▶ If there are multiple cells to be deleted, click in one of the upper left / lower left / upper right / lower right cells.

Mac "Notes" app Click inside the cell

 

▶ Hold down shift on your keyboard and press / / / to select the area you want to erase.

 

▶ When the cell content is selected, the table border color changes to yellow.

【The entire contents of the cell are not selected】

Mac "Notes" app contents not selected

 

【The entire contents of the cell are selected】

Mac "Notes" app contents selected

 

 

▶ Pressing delete once on your keyboard deletes the contents of the cell.

By the way, pressing it again will delete the table itself.

キーボードのdelete

 

The following is the state where the cell contents are deleted by pressing delete only once, but the border of the table still remains.

If you press it again, the table will also be deleted.

Mac "Notes" app table frame without cell contents

 

Sort table rows and columns

▶ Click inside the cell that contains the row or column you want to sort.

Mac "Notes" app Click inside the cell

 

▶ A small icon called a “handle” appears on the far left or top of the cell you clicked, so click the handle of the row or column you want to sort.

Mac "Notes" app Sort table rows and columns

 

▶ Now that the row or column is selected, click and hold the handle and drag and drop it to the destination you want to swap.

Mac "Notes" app Sort table rows and columns

 

The following is a video of the actual operation.

 

Add / remove table rows and columns

▶ Click in the cell just before or after you want to add a row or column.

Alternatively, click inside the row or column cell you want to delete.

Mac "Notes" app Click inside the cell

 

▶ A small icon called a “handle” will appear on the far left or top of the cell you clicked, so click on the handle just before or after you want to add a row or column.

Alternatively, click the row or column handle you want to delete.

Mac "Notes" app Sort table rows and columns

 

▶ Now that the row or column is selected, click the down arrow near the hand.

Alternatively, click the down arrow near the row or column handle you want to delete.

Mac "Notes" app Sort table rows and columns

 

▶ Menu items for adding and deleting rows and columns are displayed, so select one of them as necessary.

Mac "Notes" app Sort table rows and columns

 

Copy and paste data with other apps

Calculation formulas and formats cannot be copied between the Mac “Notes” app and other apps, but the text and number data itself are compatible.

Specifically, you can paste the data copied in Excel or Google Sheets into a “memo” and vice versa.

Furthermore, if you copy and paste from Excel or Google Sheets to “Notes”, the table will be created automatically.

【Copy source Excel】

MacのExcelで表をコピー

【Copy destination “Notes”】

Macの「メモ」で、Excelからペーストした結果

 

FAQ

In addition to this item, see “Restrictions on data entered in cells”.

Question Answer
How to break
a line in a cell?
Press option ⌥ + return on your keyboard

Mac "Notes" app New line with keyboard

Can cell column widths
and row heights
be changed?
It cannot be changed with standard functions.

Alternatively, you can do the following:

① Column width: Input several blank spaces
at the end of the character
in the cell continuously

② Height: Input several brek lines
at the end of the character
in the cell continuously

Mac "Notes" app Heights and width of cells

Standard state of cell

Mac "Notes" app Heights and width of cells

Adding some spaces

Mac "Notes" app Heights and width of cells

Adding some line breaks

 

Reference information

Add a table in Notes on Mac
In Notes on your Mac, add a table to your note to present information in an organized way.

 

This is the end of the article on this page.

 

コメント

タイトルとURLをコピーしました