TheExcelAddict .com
Microsoft Excel 'Quick Tip'

Easily Duplicate A Worksheet

Many times you will need to create a workbook that is made up of two or more identical sheets. Many Excel users create each worksheet from scratch. Others, insert a new worksheet and copy and paste using the original worksheet. The problem with this is that the print settings have to be manually duplicated - which can often be tedious and frustrating.

You can save yourself a lot of work by properly designing the first worksheet and then simply duplicating it (print settings and all) by holding down the CTRL key while dragging the sheet tab of the original. As you drag, you will notice a small sheet icon with a plus sign (indicating copying) and a small black arrow (indicating where the duplicated sheet will be inserted). Let up on the mouse button and CTRL key and you will have an identical copy of your original sheet.

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the TheExcelAddict.com/Newsletter.htm and you could win a really cool prize.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright All Rights Reserved by

Close this window