| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy visable cells only
i've fitered to unique records only - how do I paste visable cells only?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy visable cells only
press Ctrl + G then special and select Visible cells only -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=565516 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy visable cells only
Should be able to just select and copy/paste.
Excel will leave the non-visible rows.cells. If not, F5SpecialVisible cells onlyOK Copy and paste. Gord Dibben MS Excel MVP On Thu, 27 Jul 2006 03:41:02 -0700, paulajo wrote: i've fitered to unique records only - how do I paste visable cells only? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy visable cells only
If you have filterd and are left with non-contoguous cells then you cannot
paste to visible cells only unless you are pasting a single value, because you cannot paste multiple selections. If you have filtered and want to copy what you see and then paste that to a single polace then that works fine, and just use Edit / Go To / Visible cells only, then copy and paste where you want. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "paulajo" wrote in message ... i've fitered to unique records only - how do I paste visable cells only? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy visable cells only
If you do this often, you can place an icon on your toolbar.
Right click in the toolbar and choose "Customize", then "Commands" tab. In the left window click on "Edit", Scroll almost to the bottom of the right window, and click on "Select Visible Cells" Drag it to your toolbar. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "paulajo" wrote in message ... i've fitered to unique records only - how do I paste visable cells only? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
| How to copy block of cells and keep grouping? | Excel Discussion (Misc queries) | |||
| Using Command Button to copy cells | Excel Discussion (Misc queries) | |||
Linear Mode
