Then, press Ctrl+C to copy the data, including formulas. Next, keep the data range selected and right-click on it. After that, choose the Paste Special menu and select the Values option.

This article show you how to delete multiple rows in Microsoft Excel in one go which are extremely useful. There are four ways to do this!