Go Back   Talk Microsoft > Microsoft Operating Systems & Software > Microsoft Office Family

Reply
     Is there a function in Microsoft Excel that allows you to insert the number...  
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 10-31-2007, 09:33 PM
Junior Member
 
Join Date: Oct 2007
Posts: 1
Default Is there a function in Microsoft Excel that allows you to insert the number...

...of rows you'd like to insert? say I want to insert 200 rows... do I really have to select a row, double it... double that... double that all the way to 200.

And if there is not a function like that - it seems a smart program made a stupid mistake. I might be wrong... that would be great!
Forgot to add an important detail.

The documents I work on have sections... sections need different amounts of rows added daily... so selecting a certain number of rows wouldn't work... the next section down would be covered by the new rows.

F1 does not tell me what I'm looking for.
So maybe that's a large oversight after all.
Reply With Quote
Links
  #2 (permalink)  
Old 10-31-2007, 09:53 PM
Junior Member
 
Join Date: Oct 2007
Posts: 2
Default

if you customize your toolbar buttons and put the insert/delete rows/columns buttons at hand, addition or deletion of rows and columns is just a click(s).
for your problem, select the number of rows you want to add from the row you want to start inserting.(don't worry about the datas in the rows you're selecting, they'll be moved down)
-then click the insert rows button.
the number of rows you've selected will be inserted. (if you find selecting 200 rows a bit cumbersome; select 10 rows and click the insert button 20 times etc.etc.)
Reply With Quote
  #3 (permalink)  
Old 10-31-2007, 10:43 PM
Junior Member
 
Join Date: Oct 2007
Posts: 1
Default

yes, instead of inserting row one by one, you just select the row insert option, hold the shift key and move the cursor down as many rows u want, then select insert
Reply With Quote
  #4 (permalink)  
Old 10-31-2007, 10:44 PM
Junior Member
 
Join Date: Oct 2007
Posts: 1
Default

To insert multiple rows, select the rows above which you want to insert rows. Select the same number of rows as you want to insert. For example, to insert three new rows, you need to select three rows.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 01:30 PM.