Overview
A Table is a spreadsheet created on a Page which can be used to store and work with data that is in context with the other information related to it on the Page. For example, you can create a Page for a meeting agenda and post financial information in the table that relate to the discussion, or you can create a Page for a project and then store customer or vendor contact information in the Table.
Create a Table on a Page
- Inside the Page where you want the Table to reside, click on the floating plus sign
- Select to add a Table
- Samepage will create the Table and highlight cell A1 so that you can begin to adding data
Chat about content in a Table
Please see our help article on Chat Threads for how to have contextualized conversations about content in a table.
Editing a Table
The “edit column or row” toolbar button allows you to:
- insert a row above or below
- insert a column before or after
- delete a selected row
- delete a selected column
You can also right-click in the cell to prompt this menu to appear.
Formatting Text in a Cell
Click the “text overflow” toolbar button to display the drop-down menu. From here, you have the option to select:
- Overflow Text – text will flow over to adjacent cell(s)
- Wrap Text – row height will expand to fit text
- Hide Overflow Text – overflow text will not display into adjacent cell
Merging Cells
To merge cells together, select the cells you want to merge. Then, click the “merge cells” button on the toolbar.
Quick Tip: You can highlight cells by using the keyboard shortcut Shift+Arrow keys.
Resizing Columns
To resize one column:
Hover cursor over the column heading, then drag blue handle to desired width.
To resize multiple columns:
Select the columns you want to resize. Drag any of the blue handles to change width of selected columns.
Sorting Rows and Columns
Select the rows or columns you want, then click the “sort” toolbar button to sort the content:
- Ascending
- Descending
If the cells include text, they are sorted alphabetically. If the cells include numbers, they are sorted from the lowest or highest number.
Using Functions
Click the “functions” (fx) toolbar button and select the function you want.
You can also select a cell, type the equal sign and the function name. Samepage offers you a list of available functions as you type, along with a description of the action.
NOTE: when writing cell functions, arguments are separated by semicolons. For example, =roundup(3.14;1).
Importing and exporting .csv files
To access the import and export options on Tables, hover over the table and click the 3-dot menu that appears to the right of the table.
Hiding Table Headings and Gridlines
Click the “table layout” toolbar button to display menu options. From here, you can select the box(es) to:
- hide column heading
- hide row heading
- hide gridlines
