Put just one thing in a cell
The cells in your spreadsheet should each contain one piece of data. Don’t put more than one thing in a cell.
For example, you might have a column with “
plate position” as
plate-well”, such as “
13-A01”. It would be better to separate this
plate” and “
well” (containing “
13” and “
A01”), or even
well_row”, and “
well_column” (containing “
Or you might be tempted to include units, such as “
45 g”. Better to
45 and put the units in the column name, such as
body_weight_g. Even better: leave the column as
put the units in a separate data dictionary.
Another common situation is to include a note within a cell, with the
data, like “
0 (below threshold)”. Instead, write “
0” and include a
separate column with notes.
Finally, don’t merge cells. It might look pretty, but you end up breaking the rule of no empty cells.
Next up: Make it a rectangle.
(Previous: Fill in all of the cells.)