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
Watch video Insert Blank Rows in Excel | How to Add Rows in Excel? online without registration, duration hours minute second in high quality. This video was added by user Yoda Learning Academy 06 January 2015, don't forget to share it with your friends and acquaintances, it has been viewed on our site 433,934 once and liked it 3.2 thousand people.