Naming Sheets

As easy as it is to insert, delete, and rearrange sheets, it’s even easier to rename them. Double-click the tab, and when the existing name turns black, simply type the new name and press ENTER or click in a cell on the sheet when you’re finished typing the name. Here you can see Sheet1 is being renamed:

If in the renaming, your sheet tabs no longer fit within the space allocated for them on the bottom of the window, you can use the sheet-navigation buttons to move to a sheet with a tab that’s not currently visible, clicking the appropriate button to move to the first tab in the book, the last tab in the book, or between the next and previous sheets.

Grouping and Ungrouping Sheets to Create Identical Worksheets If your workbook will contain two or more sheets that have common layouts and content, you can save yourself a lot of time by grouping the worksheets before entering any data into them or applying any formats. Once the sheets are grouped, anything you do in any one of the sheets in the group is done to all of them. This includes entering Office 2010 text and numbers, creating formulas, applying any formatting, and changing column and row dimensions. For this reason, don’t group the sheets until you’re ready to build the content and formatting that are common to all the grouped sheets. You’ll want to plan ahead of time. Think about the layout and content and know what you want before you start typing and applying formats to the worksheets.