![]() ![]() This is useful only when you need to insert a single blank row and cannot be followed to insert multiple blank rows in Excel. Next right click on the selected row and click on ‘ Insert’ option and this would insert a single blank row in Excel. So, I hovered the mouse pointer on row 4 and you could see a black arrow, then click on it to select the row. Here, I want to insert a single row at row 4. Hover the mouse on the row number where you want to insert a blank row. ![]() Normal way of inserting single blank row in Excel First, let us see how we can insert a single blank row in Excel which most of us know. In this article, I will let you know how to insert multiple blank rows in Excel at once easily and with less effort. 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. 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. Microsoft Excel always fascinates me with its awesome features which help us do lots of stuff easily. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |