On Labstep, you can add tables to your protocols, experiments and notes. You can choose between a Basic Table for simple tabulations or an Interactive Table for more complex actions such as calculations. Interactive Tables contain the majority of functionalities you can find in spreadsheets such as Microsoft Excel and Google Sheets. If you'd like to know how to add an Excel or Google Sheets to your entry, click here. For the Conditions table, click here.

Creating a Table:

From a protocol/experiment entry

1. Navigate to the protocol/experiment entry of your choice

2. Type / (slash)

3. Select which type of Table you need

4. Click on 'Untitled Table' to rename your new Table (interactive Table only)

5. Start adding elements (interactive Table only)

6. Click on 'Done' once you're finished (interactive Table only)

Labstep team tip: You can always add/remove or edit elements of your Table later on. Click on your Table's name to view and edit it freely. However, make sure you are in 'Edit' mode.

From notes

1. Navigate to the content of your choice

2. Click on 'Notes' in the right-hand side menu

3. Click on the +

4. Select 'Table'

5. Click on 'Untitled Table' to rename your new Table

6. Start adding elements

7. Click on 'Done' once you're finished

Labstep team tip: You can add a comment to the Table (within the Notes) by clicking on the chat conversation bubble icon. You can create threads or comments and mention other workspace members.

Editing a Basic Table:

1. Click on one of the cells

2. Click on the Table icon in the toolbar

3. Make the necessary changes

Labstep team tip: You can select the number of rows and columns you want to add when creating a Basic Table.

Importing/Exporting Tables:

Please note this is only for Interactive Tables. However, if you wish to import data to a Basic Table, you can copy-paste it.

Import a .xlsx file

1. Click on the 'Import from XLSX' icon (far-left side of the menu)

2. Select the file of your choice

3. Click on 'Open'

Labstep team tip: We currently do not support graphs within the Table feature. If you have a graph you wish to add to your experiment/protocol/notes, you can import it as a file or image.

Export as a .xlsx file

1. Click on the 'Save as XLSX' icon (far-left side of the menu)

2. The download will automatically start

What can you do with our Interactive Table feature?

Undo/redo

• Undo changes by clicking on the left-pointing arrow (far-left side of the menu)

• Redo changes by clicking on the right-pointing arrow

Add/remove column or row 

To add a column or row:

1. Select the cell where you want an adjacent column or row to be added

2. Click on the 'Insert Rows/Columns' button on the left-hand side of the menu

3. Select from either 'Row above', 'Row below', 'Column left' or 'Column right'.

To remove a column or row:

1. Select a cell on the column or row you wish to be removed.

2. Click on the 'Delete Rows/Columns' button on the left-hand side of the menu.

3. Select from either 'Delete column(s)' or 'Delete row(s)'.

Formatting cell text

• Format text to bold, italics, underlined or strikethrough

• Change cell or text colour

• Increase or decrease the number of decimal places that are displayed

Text alignment

Adjust both vertical and horizontal alignment of the text to align text to the cell's left, centre, right, top, middle, or bottom.

Cell border options and merging cells

• Add or remove borders outlining the cells

• Merge or un-merge selected cells

Resizing cells or wrapping text

By default, the text will overflow into the adjacent cell. To enlarge the cell, either click and drag the cell border or double-click to expand the size of the cell automatically. Alternatively, you can click on the wrap text button to fit your text into the cell.

Showing formulas

To show formulas in your interactive table, press CTRL and ` (backtick/accent grave key). You'll need to do this before you can copy-paste your table if you want to also paste the formulas.

Carrying our calculations using formulas

• Basic: http://help.labstep.com/en/articles/5519994-carrying-out-calculations-on-labstep

• Advanced: http://help.labstep.com/en/articles/3107598-carrying-out-advanced-calculations-on-labstep

Still need help?

Contact us here or start a conversation with a member of our team using our in-app chat.