+ Reply to Thread
Results 1 to 5 of 5

Problem with worksheet Move/Copy function and Paste Special/Columns widths in Excel 2010

  1. #1
    Registered User
    Join Date
    06-20-2011
    Location
    Reston, VA
    MS-Off Ver
    Excel 2007
    Posts
    19

    Problem with worksheet Move/Copy function and Paste Special/Columns widths in Excel 2010

    I am trying to copy one worksheet using the "move/copy" function that is available when you right click a tab name and want to copy the worksheet in the same workbook

    The steps I'm using are:

    1. Right click the tab name
    2. Select Move or Copy,
    3. Select Create a Copy
    4. Click OK

    Doing all of the above does not work. When the new worksheet opens, all columns are the same width. It seems to be stuck on "autofit column width" setting of 8.5. The original worksheet is several columns wide all with different width settings.

    I've also used Copy, Paste Special and selected column widths and that does not work either.

    Can anyone help?

    Thank you

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Problem with worksheet Move/Copy function and Paste Special/Columns widths in Excel 20

    • Do as you have done by creating a copy.
    • Go to the original and click the Upper Left of the spreadsheet to select everything
    • Click the Format Painter in the upper left Toolbar
    • Navigate to the copy, and click the Upper Left of the spreadsheet to paint formats to everything

    Simply selecting all cells manually and painting formats applies to cells only. Choosing the coordinate above 1 and left of A copies the formats of all Rows and Columns as well.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    06-20-2011
    Location
    Reston, VA
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Problem with worksheet Move/Copy function and Paste Special/Columns widths in Excel 20

    Thank you for your solution daffodil11. I Now have problem solved and appreciate your spending the time to help me.


  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Problem with worksheet Move/Copy function and Paste Special/Columns widths in Excel 20

    Thanks for the feedback, glad I could help out.

  5. #5
    Registered User
    Join Date
    01-15-2016
    Location
    Hamburg
    MS-Off Ver
    2007
    Posts
    1

    Re: Problem with worksheet Move/Copy function and Paste Special/Columns widths in Excel 20

    Back with this problem again...
    I have copied a worksheet
    I selected the top left to "select all"
    I pressed format painter
    Column widths are not copied (nor rows of course).
    There must be some other setting affecting this. Any idea what?

+ 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. Paste special problem Excel 2010
    By Paul Shuey in forum Excel General
    Replies: 4
    Last Post: 06-06-2013, 01:41 PM
  2. Copy and Paste Special in filter mode excel 2010?
    By tantcu in forum Excel General
    Replies: 6
    Last Post: 01-23-2013, 05:52 AM
  3. Excel 2010 copy and paste problem
    By skyline-mis in forum Excel General
    Replies: 0
    Last Post: 09-19-2012, 01:29 PM
  4. [SOLVED] Paste special problem Excel 2010
    By nurer in forum Excel General
    Replies: 4
    Last Post: 06-13-2012, 09:44 AM
  5. For dates, copy/paste special/values for 2006 gives me 2010--Why
    By geraldjoh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-22-2006, 08:15 PM

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