RSS
Quick Excel Tips: Inserting Multiple Rows At One Time
When working in a spreadsheet, nine times out of ten you’ll end up inserting a row. In fact, you’ll more than likely be inserting multiple rows at a time. However, if you just highlight where you want to insert and use the Insert command, only one row will be inserted. This can be annoying if you are trying to insert multiple rows at one time. Fortunately, you aren’t consigned to “one row at a time” hell just yet. Microsoft Excel does allow you to insert multiple rows in a single click.
It’s quite simple to accomplish this by following these steps:
1. Let’s start with the spreadsheet shown below.
2. Now, say we want to insert three rows above row three. To do this, you would first highlight rows three through five as shown in this picture:
3. Finally, right-click and select Insert from the pop-up menu. Three blank rows will be inserted above row 3 and below row 2. The result is shown here:
Try it out, I think you’ll find that this little trick saves you not only time, but on frustration as well (and consequently Advil costs).
Tags: excel, free-excel-tutorial, free-excel-tutorials, how-to-insert-multiple-rows, insert, inserting-multiple-rows-in-excel, inserting-rows-into-spreadsheet, Microsoft Excel, microsoft-office, microsoft-office-free-tutorials, microsoft-office-quick-tips, rows, spreadsheet, tips-on-microsoft-excel
This entry was posted on Thursday, July 6th, 2006 at 10:59 pm and is filed under Microsoft Excel, Microsoft Office Help. You can leave a response, or trackback from your own site.
