What Can I do with SciNote Tables?

Within a SciNote Task Protocol Step or Result, you can insert the 'Table' content block in order to record and store your data in a tabular format. Tables can be created in Protocol Templates, too.

Adding Tables to SciNote Tasks 

In SciNote Tasks, users with the 'Owner' or 'User' role can add content blocks, including 'Tables,' to Task Protocols or Results. Tables support formatting, locking, and calculations similar to Excel. (Learn more about user roles and creating task protocols.)

Formatting and Working in Tables 

Within a table, you are able to change the text font, text size, text color, update the horizontal and vertical alignment of cell text, change the cell color, merge cells, add a cell border, and more!

Resizing SciNote Tables 

To change the size of the table:

1. Right click on a column or row header.
2. Click an option to insert or delete a column or row.

A quick way to add new rows or columns is to:

• Click the Enter key on your keyboard when you're in the bottom row of the table. This will add a new row to the bottom of the table. 
  • Hold the Enter key to add multiple rows at once.
• Click the Tab key when you're in the far right column of the table. This will add a new column to the right of the table. 

SciNote also allows users to resize how much area the table is taking up on the Task page.

1. Click and hold the resize table icon (in the bottom right corner) to expand the table area.

Explore these other SciNote Table actions:

• Merge/Split cells by selecting the cells and clicking the merge icon in the table menu
• Update the border color and styles for cells in your table
  
  • If you wish to remove an applied border, highlight the cells and click the option to have no cell border.

• Search for cells that contain keywords if you have a lot of data within one table

• Download/Save your SciNote table as an Excel (.xlsx) file format or Import an Excel table to be converted into a SciNote table. 
  

How to Rename a Table Sheet

When you create a new table in SciNote, the sheet is auto-populated with a sheet name/number.

Right click on the Sheet Name in the upper left and select 'Rename this worksheet' to give the table sheet a new custom name. Click 'Save' once you are finished.

• *Note – If a cell is referenced (e.g., in a formula) in a sheet that's been renamed, SciNote will automatically update the cell references to the new sheet name.

Moving table columns and rows around by dragging and dropping them

In SciNote tables, it's possible to move entire rows or columns to reorder the table columns and rows. To do so:

• Moving Rows: Click on the right edge of a row header cell (e.g., Row 6) and drag the row up or down (using the red line to guide placing the row in a new location)
• Moving Columns: Click on the bottom edge of a column header cell (e.g., Column C) and drag the column left or right (using the red line to guide placing the column in a new location)

SciNote Tables – Right-Click Options

1. When you right click on a column header, you can...

• • Rename the column (note this is only possible for columns and not rows)

  • Hide or Show that column

  • Insert a new column before or after the selected column
  • Delete the selected column

  • Sort the column

    • This can be done either by double clicking on the column header, or by right clicking and then selecting 'Order ascending' or 'Order descending' (note, the column sort is NOT permanently applied) 

2. When you right click on a row header, you can...

• • Hide or Show that row

  • Insert a new row before or after the selected row
  • Delete the selected row

3. When you right click on both (columns/rows/other cells), you can...

• • Show all (for any previously hidden cells)

  • Lock and Unlock table cells

    • Anyone with edit permissions ('User' or 'Owner' role on the Task) can unlock locked table cells)

Adding Smart Annotations in Tables

Read more on the smart annotations/# feature here.)

• • In the pop-out, type the hashtag or @ symbol and proceed as normal. Once finished, click save. 

    • 

  • View all supported formulas (for tables) in SciNote

 

Referencing cells from another Table (cross-table formulas) 

As long as the tables are within the same protocol or the same results tab, you can reference cells from different tables.

 

• Start by entering your formula in the desired cell, then click on a cell from another table to include it in the formula.

Supported formulas in Tables 

We support over 400 formulas and can be found here. 

Keyboard Shortcuts in SciNote Tables

1. ENTER key
   1. Moves down in the table to the cell directly below (Shift+ENTER = move up)
   2. Inserts a new row if you're already at the bottom of the table
2. TAB key
   1. Moves right in the table to the cell directly to the right (Shift+TAB = move left)
   2. Inserts a new column if you're already at the right side of the table
3. CTRL+Minus (on selected row header) = deletes an entire row when the row is selected 
   1. Command + Minus (when a row is selected) for Mac users
4. CTRL+Minus (on selected column header) = deletes an entire column when the column is selected
   1. Command + Minus (when a column is selected) for Mac users
5. CTRL+C / V / X = copy / paste / cut text in the table
   1. Command  + C / V / X for Mac users
6. CTRL+A = select all cells in the table
   1. Command  + A for Mac users
7. CTRL+F = search through the table
   1. Command  + F for Mac users
8. CTRL+Z = undo last action/change
   1. Command  + Z for Mac users
9. CTRL+Y = redo last action/change
   1. Command  + Y for Mac users

---

 If you have any additional questions, contact us at support@scinote.net. For more info. about the Premium plans, please request a quote.