To clear contents in Microsoft Excel but keep the formula within the cell, follow the steps below: Press the F5 key on your keyboard. The Go To dialog box will open.

Let’s use it to delete all of the beverage records (column E) in the simple data set shown in Figure A. First, select the data range that you’re deleting rows from; in our case that’s E3:E47 ...