How to insert an empty row at the same time in more than one sheet?

N

ncikusa

Hi there,

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


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

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


Can anyone help me?


Best Regards

Nik
 
K

Karthik

Hi Niko

Select all the sheets where you want to insert the row or column. You
can do this by clicking the sheet tabs where you want to make change
while holding down the Ctrl Key.

Now insert the row as you normally do. The row will get inserted in all
the selected sheets.
You can do this not only of inserting or deleting cell/rows/columns but
also to enter data, formats and host of other functions across various
sheets simultaneously.

Thanks
Karthik Bhat
Bangalore
 
R

Ragdyer

Group your sheets, so that *exactly* what you do to the main sheet, is
duplicated to all the others in the group.

Click in the tab of your main sheet.
Hold <Ctrl>, and click in the tabs of all the other sheets you wish to
group.
The tabs are White, and the main sheet tab is also bold.
You'll also notice that "Group" is now appended to the Sheet name in the
title bar.
If you want to group *all* the sheets in the WB, right click in the tab of
the main sheet and choose "Select All Sheets".

Now, make your changes and / or revisions.

When finished, don't forget to "Ungroup" the sheets, or you could cause
yourself a lot of trouble.
 
R

Roger Govier

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.
 
B

Bryan Hessey

In the sheets tab, hold the CTRL key and select other sheets, then
Insert your row (it inserts into all selected sheets)

Un-select the other sheets before continuing.
 
B

Bryan Hessey

The things you know are always simple, . . . . . it's the other 99.998%
that escape me

Thanks for the response.
 
N

ncikusa

Thanks for all the replies people :)




Damn i love excelforum - helpful people all around :)





Regards,

Nik
 
Top