multi-sheet

Many times you make the same changes to multiple sheets in an Excel Workbook. Perhaps you would like to change the column widths or apply special formatting to a range of cells in several sheets. Creating a group of selected sheets allows you to ... perform the task just once, thereby saving time and narrowing the margin for errors. There are several ways to select several sheets to create a multi-sheet selection: To select contiguous sheets, follow the steps below: Click a sheet tab. Click Shift and keep it depressed while clicking a second sheet tab. Excel will select both clicked sheets and ... (view more)