You should be able to add more than one column or row at the time

[Mitako]

when you add columns and rows in exel you can add only one. can add more than
one column or row? Can you determine somewhere the number of rows you want
to add?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

[Jamie Furlong]

"Mitako" <[email protected]> wrote in message
news:[email protected]...
> when you add columns and rows in exel you can add only one. can add more
> than
> one column or row? Can you determine somewhere the number of rows you
> want
> to add?

Or you could hold down CTRL-Y (repeat last action, IIRC) until you have the
correct number.

[Bryan Hessey]

Highlight 6 columns, then do your Insert to insert 6 more columns (or Rows) etc

also select 2 (or more) Worksheets and Insert Worksheet, same (multiple) result.

"Mitako" <[email protected]> wrote in message
news:[email protected]...
> when you add columns and rows in exel you can add only one. can add more
> than
> one column or row? Can you determine somewhere the number of rows you
> want
> to add?

Or you could hold down CTRL-Y (repeat last action, IIRC) until you have the
correct number.

[ancharwashere]

Bryan, thank you. I was looking for something like that. But I would still
like to control the number of rows in another way. Because in my work I
actually have to insert 237 rows every now and then and I would like to avoid
troublesome arithmetic. So it might be nice if excel had an insert menu with
before e.g. rows a textbox with by default the number 1 but that could be
changed by the user.

"Bryan Hessey" wrote:

>
> Highlight 6 columns, then do your Insert to insert 6 more columns (or
> Rows) etc
>
> also select 2 (or more) Worksheets and Insert Worksheet, same
> (multiple) result.
>
>
> Jamie Furlong Wrote:
> > "Mitako" <[email protected]> wrote in message
> > news:[email protected]...
> > > when you add columns and rows in exel you can add only one. can add
> > more
> > > than
> > > one column or row? Can you determine somewhere the number of rows
> > you
> > > want
> > > to add?
> >
> > Or you could hold down CTRL-Y (repeat last action, IIRC) until you have
> > the
> > correct number.
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=395269
>
>

[Jay]

>> Highlight 6 columns, then do your Insert to insert 6 more columns (or
>> Rows) etc ...

> Bryan, thank you. I was looking for something like that. But I would
> still like to control the number of rows in another way. Because in my
> work I actually have to insert 237 rows every now and then and I would
> like to avoid troublesome arithmetic. So it might be nice if excel had
> an insert menu with before e.g. rows a textbox with by default the
> number 1 but that could be changed by the user.

To avoid troublesome arithmetic, you might:
- select rows 1 to 237 (starting at 237 and dragging up to 1)
- use Bryan's method to insert rows at the top of the sheet
- select the new empty rows, and use "cut/insert cut cells" to move
them where you want.