how can i make 'global' changes to all worksheets in a workbook?
R Rowan Aug 25, 2005 #2 Depends what you want to change. Somethings eg formatting you can do by selecting all the sheets. Select first sheet, hold shift key and select last sheet. Make changes and then right click any sheet and select Ungroup Sheets. Hope this helps Rowan
Depends what you want to change. Somethings eg formatting you can do by selecting all the sheets. Select first sheet, hold shift key and select last sheet. Make changes and then right click any sheet and select Ungroup Sheets. Hope this helps Rowan
