| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How can I delete similar rows in excel workbook with many sheets?
I have similar sheets within my workbook (same info) different clients. I
need to mass (globaly) edit the sheets taking out similar columns. Any help? |
|
#2
|
|||
|
|||
|
Your subject says rows and your question says columns. This should work
either way, PROVIDED you are going to delete the same things in each sheet. Right click on any sheet's tab and choose 'Select All Sheets.' Now, any row or column you delete from the active sheet will be deleted FROM ALL SHEETS. Be sure you have a backup copy, and remember to ungroup the sheets as sson as you finish (I never remember to), otherwise you'll be making changes to all the sheets you want to make only to one. "JSchrader" wrote: I have similar sheets within my workbook (same info) different clients. I need to mass (globaly) edit the sheets taking out similar columns. Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Rows based on criteria in excel | Excel Discussion (Misc queries) | |||
| How can I delete rows from Pivot Tables in Excel 2000 as in 97 | Excel Discussion (Misc queries) | |||
| change excel row height without showing hidden rows | Excel Worksheet Functions | |||
| how do i delete empty rows in excel? | Excel Discussion (Misc queries) | |||
| Delete contents of unprotected cells in workbook | Excel Worksheet Functions | |||
Hybrid Mode
