Please I needed to delete a cell to align work well but I saw option to delete a whole row, which would mess up what I want to achieve. Help Please!
Upload a sample file for better checking.
Be aware that neither columns nor rows can be “deleted”, but only emptied and moved.
Because cells are organized in columns and rows, and every spreadsheet in Calc has (virtually) the same number of columns (2^10=1024) and of rows (2^20=1048576), you cannot literally delete a cell. The cleared space mandatorily needs to be filled with something.
If you use the menu item described in the place @gabix linked in his answer, you actually move the contents of other cells to the “deleted” ones. You may think of this process as a combination of deletion and creation of the needed new (“virgin”) cells.
Without one or another kind of replacing movement the deletion would result in a completely (contents, formats and all) cleared cell leaving a blank cell of ‘Default’ style without any direct formatting.