| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"ignoring" hidden cells in a copy/paste operation
I seem to remember in past versions that I could specify that I wished only
to select values in visible cells for the purpose of copying/pasting elsewhere. It doesn't seem to be an option anymore so how is it to be done now? For example, values may be invisible because the column or row is hidden, or because outlining is being used. How do I in that case, select only the values that are visible please? TIA ... Greg |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"ignoring" hidden cells in a copy/paste operation
What version of excel are you using?
In xl2003 and below, you can select the range to copy edit|goto special|visible cells only Then do the copy|paste. There are a couple of shortcuts to that edit|goto dialog. You can use the F5 key or ctrl-g. gvm wrote: I seem to remember in past versions that I could specify that I wished only to select values in visible cells for the purpose of copying/pasting elsewhere. It doesn't seem to be an option anymore so how is it to be done now? For example, values may be invisible because the column or row is hidden, or because outlining is being used. How do I in that case, select only the values that are visible please? TIA ... Greg -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"ignoring" hidden cells in a copy/paste operation
Thanks again Dave, that solved my problem and btw, I'm using 2003
cheers Greg "Dave Peterson" wrote: What version of excel are you using? In xl2003 and below, you can select the range to copy edit|goto special|visible cells only Then do the copy|paste. There are a couple of shortcuts to that edit|goto dialog. You can use the F5 key or ctrl-g. gvm wrote: I seem to remember in past versions that I could specify that I wished only to select values in visible cells for the purpose of copying/pasting elsewhere. It doesn't seem to be an option anymore so how is it to be done now? For example, values may be invisible because the column or row is hidden, or because outlining is being used. How do I in that case, select only the values that are visible please? TIA ... Greg -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
| Odd error - "This operation requires merged cells..." | New Users to Excel | |||
| Can't copy & paste - "merged cells must be identically sized" | Excel Discussion (Misc queries) | |||
| Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Linear Mode
