Format table text and use keyboard shortcuts
Format part of a cell's text, fill cells by dragging, hide rows and columns, and move around a Table content block with Excel-style keys.
These tools work in a Table content block. A cell works like a small text block: you can format any part of its text.
Format part of a cell
Make one word bold
3 steps
Edit the cell
Double-click the cell, or select it and press Enter.
Select the text
Select the word or words you want to change.
Format it
Press Cmd+B on a Mac or Ctrl+B on Windows, or use the toolbar. The rest of the cell keeps its own style.
You can change the bold, italic, underline, strikethrough, font, size, weight, text colour and highlight of any part of the text. You can also add a link or make text superscript or subscript.
If you select whole cells instead of editing one, the formatting applies to all the text in those cells.
A cell with a formula, or a number shown in a number format, can only be formatted as a whole cell.
Fill cells by dragging
Select one or more cells.
Drag the small square at the bottom-right corner of the selection across the cells you want to fill.
Let go. Numbers, dates, months and weekdays continue as a series. Formulas are copied with their references moved, as in Excel.
Press Cmd+D to fill down or Cmd+R to fill right instead. On Windows, use Ctrl.
Hide rows and columns
Select cells in the rows or columns you want to hide, right-click, and choose Hide Row or Hide Column. Hidden rows and columns stay in the editor, shown faded. Your customer doesn't see them in the viewer or the PDF.
To show them again, select a faded cell, right-click, and choose Unhide Row or Unhide Column. To show everything, open the Table menu and choose Unhide All Rows and Columns.
Paste from Excel or Google Sheets
Copy cells in Excel, Google Sheets or another spreadsheet, select a cell in the table, then paste. The table keeps:
formulas, with their references moved to where you pasted
formatting inside cells, fills and borders
number formats
merged cells, where they fit
The table grows to fit, up to 200 rows and 30 columns. If something can't be pasted, such as images, charts, comments or formulas the table can't calculate, a message lists what was left out. Formulas the table can't calculate are pasted as their values.
Press Cmd+Shift+V on a Mac or Ctrl+Shift+V on Windows to paste values only.
Keyboard shortcuts
Press Cmd+/ on a Mac or Ctrl+/ on Windows to see every shortcut. On Windows, use Ctrl wherever this list says Cmd.
Moving and selecting:
Arrow keys move between cells. Hold Shift to extend the selection.
Tab and Shift+Tab move to the next or previous cell.
Shift+Space selects the row. Ctrl+Space selects the column.
Cmd+A selects all cells. Esc selects the whole table.
Editing:
Enter or F2 edits the cell. Delete clears the selected cells.
Option+Enter (Alt+Enter on Windows) starts a new line in a cell.
Cmd+Enter writes what you typed into every selected cell.
Cmd+; inserts today's date.
Rows and columns:
Cmd+Shift+= inserts rows or columns. With one cell selected, you're asked which.
Cmd+− deletes the selected rows or columns. With one cell selected, you're asked which.
Cmd+Shift+L turns the filter on or off.
Formatting:
Cmd+B, Cmd+I and Cmd+U make text bold, italic or underlined.
Cmd+Shift+X strikes text through.
Cmd+K adds a link.
Cmd+\ clears formatting.
Related guides
- Use formulas in a tableAdd up, multiply and compare values in a Table content block with spreadsheet formulas, format the results, and link to other tables, spreadsheets and pricing tables.Smart Tables
- Sort, filter and highlight table rowsSort the rows of a Table content block, filter out rows your customer doesn't need to see, and colour cells by their values with conditional formatting.Smart Tables
- Resize table columnsDrag a column divider to change the width of two neighbouring columns, in a Table content block or a table inside a text block. The other columns stay where they are and the new widths are saved with your document.