How do I insert rows in more than one worksheet at a time?

G

Guest

I have a "master" spreadsheet which consolidates information from multiple
sheets in the workbook. I need to insert a line in all the sheets, including
the master, and have all the other rows retain their formulas in all the
sheets. How can I do that?
 
G

Guest

If the row is at the same location for all sheets, for example row 20, select
all the worksheets by holding down the Ctrl key and clicking on the worksheet
tab (there are other ways to select - this is one of them).

Then insert a row. This will insert on all the tabs selected. Be careful -
anything you do will be done on all the sheets! To unselect, right click on
a tab and select Ungroup.
 

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

Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Insert lines in more than one worksheet at a time... 3
Excel shortcut options 0
Exclude worksheet from loop. 0
All sheets in workbook have same rows to repeat at top 1
Copying worksheets with formulas in hidden columns 2
Export row depending on column to various sheets 6
how do i select all cells in a worksheet 3

Top