no answer on 1st post..how to add rows to more then 1 worksheet...

  • Thread starter Thread starter Bill L.
  • Start date Start date
B

Bill L.

I know how to add a new row on the work sheet I am working on but I can one
add that same row to more then 1 sheet at the same time? I need to be able
to add a row or rows to 12 of the 13 work sheets with out having to repeat
the steps on each worksheet.

Is it even possible to setup so you have a 1 key short cut to add a row or
have 3 cells like this that would add rows on 12 of 13 sheet? (example is
set up the 1st cell so you enter the number of rows you want to add, 2nd
cell is where you want it entered (enter at row 35), 3 you click and it add
the rows) Any short cut idlea would be great.

Once again thanks to all who helped in the past any any who may help on
this.
 
Click on the first sheet, then hold down the control key and click on each
additional sheet. You will see all the sheet tabs you want, selected. Then
insert the row on one sheet. Now right click on the sheet tab and ungroup.

What you describe beyond that sounds like it could be done with a macro.
Are you looking for a macro?
 
Hi Bill,
Do you know about Grouping Worksheets. If you group
your worksheets any damage you do to one sheet
will be repeated on the others just like you did the same
to each.

To group sheets. Use Ctrl+ select another sheet,
or select and use Shift to add a consecutive range
of sheets.

After finishing making your changes. Ungroup the
worksheets. Right click on a worksheet tab and
choose "ungroup sheets".

Macros do not recognize grouped sheets unless
programmed to do so.

I said damage because if you leave the sheets grouped
then you be causing unseen damage by repeating same
changes to the other sheets. So be very careful and
practice first in a copy of the workbook.

Grouping sheets is powerful, but should be used
with caution.

You should be doing backups on a regular bases.
http://www.mvps.org/dmcritchie/excel/backup.htm

BTW, I don't see a question like this posted in this group,
are you using exactly the same email address and subject..
 
Bill

Manually..........select the 12 sheets(select sheet1 then SHIFT + Click on
Sheet12).

Enter a row or rows on sheet1. All 12 sheets will have the row or rows
entered.

DO NOT FORGET to right-click and "ungroup sheets" before proceeding further.
What is done to onw sheet is done to all.

One-click shortcut would involve VBA macro.

Gord Dibben Excel MVP
 
Back
Top