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" wrote in message
...
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