Hi Niko

Just click on the tab of the first sheet, hold the shift button down whilst
clicking on the tab of the last sheet you want included.
This groups the worksheets, and any action you take on one, will be applied
to all.
Click on an individual sheet again to Un-group them.

--
Regards

Roger Govier


"ncikusa" wrote in
message ...

Hi there,

I was wondering how you can insert an empty row the same place in
different sheets at the same time...


E.g.: If you have 2 (and up, of course) sheets with the exactly same
stuff, and you want to put in an empty row after row 6 (or any other
row for that matter), is there any function you can use?

I tried finding out if there was a function for inserting a row, but
apparently you just use "insert..." while clicking on a row, else you
could just use that function and make it run on all sheets....


Can anyone help me?


Best Regards

Niko


--
ncikusa
------------------------------------------------------------------------
ncikusa's Profile:
http://www.excelforum.com/member.php...o&userid=23600
View this thread: http://www.excelforum.com/showthread...hreadid=392820