Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2006
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Duplicating a spreadsheet entirely (Excel 2003)

    I have a spreadsheet that has all the formatting exactly as I want it.
    I need to duplicate the spreadsheet 5 times and then change one cell in the 5 copies.
    HOW DO I get an exact duplicate of a spreadsheet?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Duplicating a spreadsheet entirely (Excel 2003

    Hi there welcome to the Lounge

    The non-code solution is:

    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 go of the mouse button and CTRL key and you will have an identical copy of your original sheet.
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Duplicating a spreadsheet entirely (Excel 2003)

    You can drag the sheet tab of the worksheet with the Ctrl key held down to make a duplicate.
    Or select Edit } Move or Copy Sheet..., tick the Create a Copy check box, and if desired specify where the copy will end up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •