Be careful when using groups because if you forget that your spreadsheets are grouped and then proceed to add or change figures on a worksheet, all of the worksheets in the group will have the same figures. To remove a group, simply click on a sheet that is not in a group. If all of the worksheets are grouped, right_click on any tab and choose Ungroup Sheets. Keep an eye on the title bar prior to making changes and Excel will tell you if the sheets are grouped.
Insert a New Worksheet _ Just press [Shift] + [F11] to create a new worksheet. Fast Worksheet Copy _ How do you copy a worksheet with a master format such as a quarterly or monthly layout? Please don't say copy and paste! This choice does not give you an exact copy and you'll waste tons of time trying to re_format columns and re_create other formatting. Although the worksheet tab shortcut menu is one way to copy, especially across workbooks (the Move or Copy option), a fast and easy approach is to hold [Ctrl] while dragging a worksheet tab to a new location in the workbook. Your mouse pointer will look like a page with a plus (+) sign. Release the mouse first and then [Ctrl] to see the new worksheet. Finish by renaming the copy. Bonus Tip: When you drag a worksheet tab without the [Ctrl] key, you are moving a worksheet to a new location in the workbook.