How can I learn more about Worksheets and find Tutorials? _ I have created a website to teach as much about Excel as I can possibly learn. I will be offering valuable advice, knowledge and tutorials about many different features of Excel Worksheets as well as many other aspects of Excel.
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.