-- You can select all the sheets in a workbook by pressing --> Right click a sheet tab --> click 'Select All Sheets' on the shortcut menu.
Apr 29 2014 03:46 PM
-- Ctrl-click the tabs of the sheets that you want to group together, and the grouped tabs will all turn white.
Now format any sheet and similar formatting will be applied to all selected sheets. While sheets are grouped, anything you enter in one sheet also gets entered into the others.