How do I do this (I am new to Excel)

That looks like a great job for the macro recorder
Select the cell one cell above the point you want to start the macro
Hit the macro recorder and just do exacactly what you described, when you are finished doing the actions select the cell where you want it to be when the macro finishes.