Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy visible cells
Help please: I selected "go to-special-visible cells only", but the problem
is the selection does not stay. This is what I mean: 1. I selected the entire worksheet with the filter on, only 200 out of 800 records are visible; 2. I select "go to-special-visible cells only" And then I do it again just to make sure the selection is there, however, I find that after I "go do-special", the tab still shows "comments" being selected, NOT "visible cells only". Does this sound right to you? When I copy and paste, sometimes the visible ones are copied, but most times, I will get message saying Excel does not have enough resources to complete this task, when I'm only copying 8 rows of data. Do you know what problem I'm experiencing? Thanks much! Sunny |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy visible cells
Hi,
There is no problem here! First, don't select the entire sheet before choosing Visible Cells Only, that means you are selecting a billion cells. Visible < Populated Second, you don't need to use the Go To Special command with filtered data, just select the cells which are visible in your data area (not the whole spreadsheet) and choose Copy... Third, when you use Go To Special it always opens the default window, that is, with the first option, Comments, selected. If you think about it visible cells only might be the case but what if all visible cells have comments, and all visible cells also contain text. Then three options should be selected when you open the dialog box but since they are option buttons only one can be selected. Microsoft just chose to have it open with comments which is just as logical as opening with any other random choice selected. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Sunny" wrote: Help please: I selected "go to-special-visible cells only", but the problem is the selection does not stay. This is what I mean: 1. I selected the entire worksheet with the filter on, only 200 out of 800 records are visible; 2. I select "go to-special-visible cells only" And then I do it again just to make sure the selection is there, however, I find that after I "go do-special", the tab still shows "comments" being selected, NOT "visible cells only". Does this sound right to you? When I copy and paste, sometimes the visible ones are copied, but most times, I will get message saying Excel does not have enough resources to complete this task, when I'm only copying 8 rows of data. Do you know what problem I'm experiencing? Thanks much! Sunny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
Copy visible cells on Filtered data | Excel Discussion (Misc queries) | |||
Copy and paste visible cells to outlook | Excel Discussion (Misc queries) | |||
Copy/Paste Visible cells only | Excel Discussion (Misc queries) | |||
Copy visible cells only | Excel Discussion (Misc queries) |