Auto move cells

[Winehouse]

Hi

I'm fairly new to Google Sheets.

I'm making an annual leave sheet for employees.

If someone cancels their leave (in the example, person c in column A, row 3), I'd like to be able to auto-move the names directly below the person who cancels, when the cell becomes empty, rather than delete then copy & paste.

Is this possible?

TIA

 

[arthurbr]

Select the empty row - Press Delete - In the drop down that appears select " Shift cells up" - Done

 

[Winehouse]

Great. Thank you!

 

[arthurbr]

You're welcome