Note that doing either method will not change the actual contents of the selected sheet(s). In both cases, hold down Shift to highlight all subsequent sheets. There are two ways to do this: by clicking the name of the active sheet in the upper left corner, or by holding down Ctrl while going across the tabs in order. If you don't want to waste time managing groups of worksheets, another option is simply selecting and deselecting each tab separately. For more options, check out our guide to using the Quick Access Toolbar in Office 2016. Now whenever you go back to editing your worksheets, you won't see those pesky little panes anymore! If you ever decide you'd rather use them again, double-clicking anywhere in the pane brings it back, which also lets you add more rows and columns to it if necessary. The pane disappears automatically after a few moments. When you've finished organizing your content, click OK and then Close Grouping Area.

We recommend dragging everything over before selecting anything because otherwise you may end up accidentally moving things around. You will now see a new pane appear above the worksheets where you can drag and drop rows and columns between them. You should see something similar to the screenshot below. To get started, right-click any empty area of the ribbon menu (the buttons along the top edge of the screen) and choose Group Selection Pane ' New Group. This allows other people who have access to the same spreadsheet to open up only what they need instead of having to scroll through tons of extra tabs. The first step when working inside an Excel file is grouping all related information together. Thankfully there are some tools that let you easily create groups of cells within an Excel file, as well as separate specific sheets from the rest of the document so they act like their own standalone documents. How do I send only certain sheets in Excel?Įxcel is great for creating spreadsheets with data and calculations, but sometimes it can be useful if you're on someone else's computer or you want to share your workbook without sending every cell individually.How do I send one Excel worksheet as a PDF?.Enjoyed learning this interesting article? Do share it with friends!.How do I save just one page of an Excel document?.Can I save an Excel sheet as a separate file?.Can I send a single sheet of an Excel workbook?.Can you send just one sheet of an Excel workbook?.Can you split Excel sheet into multiple files?.How do I split an Excel worksheet into individual files?.How do I select just one sheet in Excel?.How do I group certain sheets in Excel?.When you save a workbook that contains grouped sheets and then close the workbook, the sheets that you selected remain grouped when you reopen that workbook.

It's important to ensure that only one sheet is selected before you copy or move data to another worksheet. These changes might replace data on the active sheet and-perhaps unintentionally-on other selected sheets.ĭata that you copy or cut in grouped sheets cannot be pasted onto another sheet, because the size of the copy area includes all layers of the selected sheets (which is different from the paste area in a single sheet). If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.ĭata that you enter or edit in the active worksheet will appear in all selected sheets. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. TIP: After choosing multiple sheets, appears in the title bar at the top of the worksheet. Right-click a sheet tab, and then click the Select All Sheets option.

Repeat the arrow and Ctrl+Space steps to select additional sheets.Ĭlick the tab for the first sheet, then hold down CTRL while you click the tabs of the other sheets that you want to select. Next, use the left or right arrow keys to select the sheet you want, then you can use Ctrl+Space to select that sheet. You can add a sheet by pressing the Add Sheet button to the right of the sheet tabs.Ĭlick the tab for the first sheet, then hold down SHIFT while you click the tab for the last sheet that you want to select.īy keyboard: First, press F6 to activate the sheet tabs. If you don't see the tab that you want, click the scrolling buttons to locate the tab. The active sheet will be a different color than other sheets. You can also format or print a selection of sheets at the same time.Ĭlick the tab for the sheet you want to edit. To enter or edit data on several worksheets at the same time, you can group worksheets by selecting multiple sheets. By clicking the sheet tabs at the bottom of the Excel window, you can quickly select one or more sheets.

Sheets for excel