To insert multiple rows in your Excel data table, you don’t have to insert them one by one. You can do this with just a few mouse clicks…
There are two places where your Excel program keeps the temporary save files. Try looking for your unsaved Excel files there.