Press the Control-C keyboard combination to copy the data. Alternately, select the 'Copy' button on the Excel toolbar. Click on the spreadsheet, file, or other document where you wish to paste the filtered data. Press the Control-V keyboard combination to paste. The filtered data is pasted into the new file. I did, however, figure out how to COPY from visible cells only and yet when I apply the same technique to pasting—highlighting the section you want, using the Mac shortcut (command + shift + Z) and then pressing paste—it fails.
Hi Kam, Thanks for sharing your experience with us. Based on your description, my understanding is that you are not able to copy from visible cells/paste into visible cells in Excel. If you are using windows, you may try the followings to select the visible cells, and see if you can normally copy from visible cells and paste into visible cells: 1.Use Select Visible Cells command in Quick Access Toolbar.
You can refer to to add the command to Quick Access Toolbar. 2.Or you may try going to Home tabEditing groupFind & SelectGo To SpecialVisible cells only. If above doesn't help and the issue persists, please provide the following information for troubleshooting: 1.Which device are you using? Windows or Mac? Please also provide the OS version.
2.If you are using Windows, please go to FileAccount capture a full screenshot of Product Information and share it with us. (note to mask your email address) If you are using Mac, please go to Excel menu in upper left cornerAbout Microsoft Excel, share Office version information with us. 3.Did you get any error message? If yes, please share a related screenshot with us. 4.Does the issue happen in a specific file or all files? 5.What did you do before the issue happens? (Update Office or Windows/Mac?) Regards, Tina.
I'm trying to copy data from column A in a filtered list to the next column B. As column B is of course also filtered, I want to copy the visible cells (no problem) but then paste them to the visible cells (problem). I've checked through earlier questions on this subject to find an answer but it seems there isn't one - at least not a straightforward one. I did find a possible solution in the form of a 'Code' as follows: Worksheets('Sheet Name').Activate Range('A2').Select Selection.Copy Range('A3:N1000').Select ActiveSheet.Paste Application.CutCopyMode = False Is this a macro thing? If so, how do you use it? I'm afraid I'm a macro virgin Can anyone help? Hi, Here is another way: Assign this code to Button on your worksheet: Assumptions: List in Cloumn A is Named CopyRange and that in column B PasteRange Sub CopyFilteredCells Dim SourceRange As Range, TargetRange As Range Dim Cell As Range If ActiveSheet.FilterMode = True Then Set SourceRange = Range('CopyRange') Set TargetRange = Range('PasteRange') With Application.ScreenUpdating = False For Each Cell In SourceRange.SpecialCells(xlCellTypeVisible) Cell.Copy TargetRange.Cells(Cell.Row) Next.CutCopyMode = False End With End If End Sub Hope this helps.
I was trying to apply GorD solution posted on May 14th 2004, yet it doesn't work for me I expected it to work since it did for lichfields, so I thought I was missing on smth. I suspect it is the 'bit paste' part from: 'Copy cell B2, select the rest of colb down to the bottom of your data, do the Alt; bit paste.' I get the Alt+;, which is a shortcut for selecting only visible cells, still what's the deal with bit paste? Could anyone elaborate on this, please? I've got a 2007 MsExcel btw, in case this is relevant.