| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I insert rows in more than one worksheet at a time?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I insert rows in more than one worksheet at a time?
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. "Ohio accountant" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert a new row between exsisting rows on entire worksheet | Excel Discussion (Misc queries) | |||
| Insert rows | Excel Worksheet Functions | |||
| INSERT ROWS WITHOUT SCREWING-UP FORMULAS! | Excel Worksheet Functions | |||
| Display specific rows from table on other worksheet | Excel Discussion (Misc queries) | |||
| How do I add rows to a completed worksheet? | Excel Worksheet Functions | |||
Linear Mode
