Friday, November 19, 2010

How can you add multiple rows to an Excel 2003 Worksheet without using the VB editor or other programming?

highlight multiple cells, and click the ';insert row'; icon.

if you dont have the icon...then highlight multiple rows (by clicking on the numbers on the left), then right click in your highlighted area and click insert.



add the insert row icon, i use mine all the time.How can you add multiple rows to an Excel 2003 Worksheet without using the VB editor or other programming?
select a cell, press Shift key and down arrow to select how many rows we would like to added %26gt; Enter, then

Ctrl C (shortcut for copy)

Alt I

Enter



This should give us multiple rows without VBA or mouse pointer. Good luck.

No comments:

Post a Comment