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
Navigate to the protocol/experiment entry of your choice
Type / (slash)
Select which type of Table you need
Click on 'Untitled Table' to rename your new Table (interactive Table only)
Start adding elements (interactive Table only)
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
Navigate to the content of your choice
Click on 'Notes' in the right-hand side menu
Click on the +
Select 'Table'
Click on 'Untitled Table' to rename your new Table
Start adding elements
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:
Click on one of the cells
Click on the Table icon in the toolbar
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
Click on the 'Import from XLSX' icon (far-left side of the menu)
Select the file of your choice
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
Click on the 'Save as XLSX' icon (far-left side of the menu)
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:
Select the cell where you want an adjacent column or row to be added
Click on the 'Insert Rows/Columns' button on the left-hand side of the menu
Select from either 'Row above', 'Row below', 'Column left' or 'Column right'.
To remove a column or row:
Select a cell on the column or row you wish to be removed.
Click on the 'Delete Rows/Columns' button on the left-hand side of the menu.
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
Still need help?
Contact us here or start a conversation with a member of our team using our in-app chat.