How to insert Multiple Blank Rows in Excel at once

preview_player
Показать описание
If you are dealing with a lot of data and as it keeps on changing, you might come across a situation where you need to insert multiple blank rows in Excel at once. You might know a single way to insert one or two blank rows in Excel, but what if you want to insert multiple blank rows in Excel between data? We cannot follow the process of inserting single row multiple times as it is very tedious.

Рекомендации по теме
Комментарии
Автор

This is excellent! Thank you very much.

eneadastavri
Автор

what if we want to insert 5-5 blank rows after every row

sactemp