Deleting empty rows

<< Click to Display Table of Contents >>

Deleting empty rows

To delete all empty rows in a certain range of rows, select the range from which you want to remove empty rows.

Then choose the ribbon command Data | group Edit | delete_empty_cells_icon Remove empty rows.

PlanMaker scans this range for rows that are completely empty, (i.e. where none of its cells is filled with a value). It then deletes all matching rows.

Note

Normally, you use this command with a range of entire rows selected. However, you can also select a cell range that doesn't consist of entire rows. In that case, PlanMaker will first ask you if you want it to delete matching rows entirely:

If your answer is Yes, the entire row will be deleted for all matching rows.

If your answer is No, only cells inside the selection will be deleted. The cells left and right of the selection are not affected.