|
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
|