Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Insert multiple rows/columns in Excel

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 268

PostPosted: Wed Jan 18, 2017 9:16 pm    Post subject: Insert multiple rows/columns in Excel Reply with quote

Let's say, I would like to add 5 rows between cells A6 and A7.





So select cell A7 > right mouse click > Insert... > select Entire row. It will add a single row between the cells while moving the original cell A7 content down. Now press 'F4' key four times (or more per your demand).

So now I have 5 rows inserted. But now I decided to insert 15 more rows (total = 20 rows).

So highlight the five rows you just inserted > press 'Ctrl + ' > select Entire row from the Insert window > click OK. It adds additional 5 rows. So now you have 10 rows.





Press again 'Ctrl + ' > the Insert window opens again > select Entire row > click OK. Now you have 15 rows.

Repeat the procedure!!


By the way, to insert multiple columns, follow the same steps. In this case, you have to only select Entire Column from the Insert window Smile




*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.

For comments of suggestions, please contact us: info@shamskm.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group