Cell contents spilling into next empty cell on spreadsheet.
There is no special option concerning the issue (afaik).
-1- For the respective cells enable (
context menu)>Format Cell...>>Alignment>>>Shrink to fit cell size.
-2- Similar: (
context menu)>Format Cell...>>Alignment>>>Wrap text automatically.
-3- Put a space into the unused cells so they are no longer blank.
-3a- If you want to allow formulas easily to find these cells “empty”, fill in there the formula
="" instead of the space.
-4- If you are not afraid of a probable repetition (only for the view), you can also set (
context menu)>Format Cell...>>Alignment>>>Horizontal >>>>Choose 'Filled'.