sheets

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)

Working with multiply sheets concurrently is how MS Excel power users create and format a complex workbook with the least amount of effort expended. Follow the steps below to make working with multiple sheet a piece of cake and you will be on your ... way to becoming a power user! Hold down the CTRL key as you click each tab top select multiple worksheets. To select a contiguous group of worksheets, click the first one in the group and then hold down the Shift key and click the last one in the group. To select all the worksheets in the current workbook, right-click any worksheet tab and choose ... (view more)