Results 1 to 2 of 2
2011-04-21, 09:24 #1
- 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.
2011-04-22, 11:31 #2
- Join Date
- Nov 2002
- New York, New York, USA
- Thanked 17 Times in 17 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.