Excel Sheet Groups - Web to group all the worksheets in a workbook, this is what you need to do: Grouped worksheets appear with a white. Click select all sheet s to group all the worksheets in the current workbook. Now, suppose you want to add the same formula to cell b7 on both. Choose select all sheets in the context menu. Web group selected worksheets press and hold down the ctrl key, and click the worksheet tabs you want to group. Web to group worksheets together, press and hold the ctrl key and click each worksheet you want to group together at the bottom of the excel window. If you want to group consecutive. Web another quick way to group all the worksheets in excel is to use the shift key:
Web another quick way to group all the worksheets in excel is to use the shift key: If you want to group consecutive. Web to group worksheets together, press and hold the ctrl key and click each worksheet you want to group together at the bottom of the excel window. Web to group all the worksheets in a workbook, this is what you need to do: Web group selected worksheets press and hold down the ctrl key, and click the worksheet tabs you want to group. Grouped worksheets appear with a white. Click select all sheet s to group all the worksheets in the current workbook. Choose select all sheets in the context menu. Now, suppose you want to add the same formula to cell b7 on both.