Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Thanked 0 Times in 0 Posts

    Unusual 'visible cells only' in Excel 2007

    I have often used the 'go to visible cells only' to cut and paste between Workbooks/Worksheets without problems.
    THis time, I have a Worksheet which has a bar for various controls, macro buttons etc. as well as the column headers. This worksheet has many hidden columns.
    I am using a laptop with a separate monitor as an extended desktop.
    Due to the ribbon, my header and control bar (and my eyesight), opening a second workbook and arranging them horizontally didn't really work too well.
    So, I opened a second instance of Excel and had one instance on each display.
    It seems that the 'copy visible cells only' is impossible in this Situation.
    I tested this by opening a new workbook in the instance of Excel that I wanted to copy from. Pasting into this copied the cells I wanted correctly, but going immediately to the other instance copied all the hidden cells as well.
    Last edited by dyfedg; 2011-04-21 at 09:46.

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    New York, New York, USA
    Thanked 20 Times in 20 Posts

    I am not a big fan of 2 seperate Excel instances running. However, On Excel 2003 I had no problems doing a visible cells only copy and paste.

    You could try the following:

    1. Just copy a very small area and see if it works.
    2. Make sure there is no problems with Merged Cells getting in the way.
    3. Don't try to copy the entire workseet, but rather just the area you need.
    4. Lastly, open a new blank workbook in Excel and try the copy visible cells from the source data to the new WB. By using the lower status bar in Excel its easy to switch between open books.

    Hope this helps.

    Tom D

Tags for this Thread

Posting Permissions

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