Insert Blank Rows in Excel | How to Add Rows in Excel?
Are you tired of scrolling up and down to find the right cell to insert a blank row into your spreadsheet? Well, say goodbye to that because I'm going to show you how to insert a blank row into any Excel table in just a few seconds.
0:00 Introduction of Insert Blank Rows after every data
0:10 Challenge for the Excel users
0:30 Traditional Method of Inserting Blank Rows
0:38 Press Excel Shortcut keys Ctrl + Shift + + (to insert a row)
0:48 Repeat Last action press Excel Shortcuts keys F4
1:20 What Happened Did you try it
Solutions for Inserting Blank Rows & Columns
1:32 Copy this Data (Ctrl + C)
1:41 Add another Row in Data [Dummy serial number]
1:51 Add Serial number in that Dummy Column
2:20 Go to Data then Sort [Sort by dummy serial number] - smallest to largest format
2:43 Woohh Amazing super special tricks
👉 Check out Excel tutorial Playlist - • Excel Tips & Tricks
Let's Connect:
👉 Follow us on Instagram / yodalearning
👉 Follow our boards at / pins
