inserting rows in linked worksheets

G

Guest

i have worksheet "1" as my master worksheet with other worksheets linking to
its data. When i instert a new row in worksheet "1" i dont see the new row in
the other worksheets that are linked to it....how can i accomplish inserting
new rows in worksheet "1" so that all other worksheets get the same new row
inserted???
 
F

flummi

If the sheets are all in the same workbook, select sheet 1, select the
line where you want to insert a line, select all the sheets and perform
the insert. Excel will insert a line at the same point in all selected
sheets. If you right click a sheet tab you can select "select all
sheets".

Hans
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting in multiple worksheets 1
Linked cells between worksheets and sorting 2
Linking worksheets, rearranging rows. 1
Inserting Rows into multiple worksheets 2
Stop linked cells from changing when insert new row? 1
Deleting blank rows with formulas in them 7
Paste Values in linked Cells Only 4
Excel-Adding rows to master sheet that will be inserted on following worksheets 1

Top