+ Reply to Thread
Results 1 to 2 of 2

Pasting excel sheet into sheet 2 identically

  1. #1
    Registered User
    Join Date
    10-31-2017
    Location
    England
    MS-Off Ver
    2010
    Posts
    1

    Pasting excel sheet into sheet 2 identically

    Hi all,

    I am looking to make a rota for work and am having a bit of trouble duplicating worksheets identically.
    With this I am meaning column/row width, boarders and also words/numbers.
    I know it can be done as, well, Excel is magical, but also I have seen it done, but cannot work it out.

    Also, as a sub question, the numbering in row A is representing the date.
    Is there a formula and formatting option that allows me to have 1st, 2nd, 3rd, 4th etc. show with out having to type out across all the sheets (as I am looking to have this represent the whole year's rota).

    I have added a picture to try and help explain any miscommunication.Rota.png

  2. #2
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Pasting excel sheet into sheet 2 identically

    For your first question, right click on the tab, click move or copy, check the box that says Create a copy and click OK.

    For your second question, you can type in the same cell in multiple worksheets at the same time by clicking on a sheet, holding the CTRL button and clicking on whatever sheets you want. {or click on the first sheet, hold SHIFT and click on the last sheet to select all the sheets.} Then just type in the cells you need.
    Last edited by Raphaelp; 10-31-2017 at 02:25 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 02-19-2016, 06:17 PM
  2. Replies: 8
    Last Post: 02-01-2016, 09:30 AM
  3. Finding a column in one sheet and pasting in another sheet- ones I found dont work
    By alirizvi1 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 06-05-2015, 04:12 PM
  4. Excel 2007 - VBA to copy data from one sheet and pasting to another sheet
    By abhimails in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2014, 07:40 AM
  5. Replies: 9
    Last Post: 05-13-2013, 05:43 AM
  6. Copying All the visible Rows in the current sheet and pasting it to another sheet
    By vickyyar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2012, 08:46 AM
  7. Replies: 2
    Last Post: 02-25-2009, 02:09 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1