Insert multiple blank rows in Excel at once easily using these three ways. You can insert any number of multiple blank rows in Excel between data.

Let's say you're working in an Excel worksheet and realize that you need to insert additional rows of data. Luckily, Excel has a built in feature to allow users to insert multiple blank rows.

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.

Extending the Functionality to Multiple Rows Once you have successfully created dependent drop-down lists in a single row, you can easily extend this functionality to multiple rows.

How to insert multiple rows in Microsoft Excel on your Mac or PC Laura McCamy Laura McCamy is a freelance writer based in the San Francisco Bay Area.