Excel: Inserting Multiple Rows

Have you ever needed to insert more than one blank row into an Excel sheet?

To insert one row, just right click on the row you want to insert a row and choose the Insert option.

To insert multiple rows, highlight as many rows as you need to insert and then right click on one of the rows and choose insert. This will add as many rows as you have highlighted into the spreadsheet, starting at the first highlighted row.

MS Excel Tricks: Insert Multiple Rows

MS Excel Tricks: Insert Multiple Rows

This will work even if you have data that you need to insert into multiple rows, but you actually don’t have to highlight the same number of rows first. Let’s say you have 3 rows worth of data stored in the clipboard. All you have to do it right click on the row you want to insert the data and choose Insert. It will automatically insert however many rows worth of data you had.




Joe Austin

Joe Austin is the founder of Potentials Unleashed. He is currently an IT Professional Manager in the Financial Industry and has been using computers since 1978. While mostly self-taught, he is proficient in several computing areas, such as Programming , Web Development, most Microsoft Office programs, Internet Marketing, Spyware / Malware Removal and even 3D Animation & Modeling.

Click Here to Leave a Comment Below 0 comments
%d bloggers like this: