Identical worksheets are needed prior to using the Consolidation feature, creating a sum across worksheets or using the Paste Special Math features to create summary worksheets. By grouping the worksheets first and then adding rows or columns, changing headings and other formatting operations, you ensure that the spreadsheets remain uniform.
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.