+ Reply to Thread
Results 1 to 7 of 7

Cutting and pasting Filtered Rows

  1. #1
    Registered User
    Join Date
    02-14-2018
    Location
    SOUTHERN CAL
    MS-Off Ver
    2016 FOR MAC
    Posts
    8

    Cutting and pasting Filtered Rows

    I am trying to cut and paste some filtered rows from one spreadsheet in a workbook to another spreadsheet in the same workbook and tried the CMD, Shift Z for MAC, and then the cut function. On the paste or insert cut rows function I continue to get the hidden rows after the paste. I know I have successfully attempted this before but for reason it is not working today. By chance would it have anything to do with what type of excel extension I am using (e.g., xlsm, xlsb, xls, xltm etc.)? Can someone offer some insight into what I am doing wrong, I am using Excel 2016 for MAC?

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Cutting and pasting Filtered Rows

    Try copy and paste, not cut and paste.

  3. #3
    Registered User
    Join Date
    02-14-2018
    Location
    SOUTHERN CAL
    MS-Off Ver
    2016 FOR MAC
    Posts
    8

    Re: Cutting and pasting Filtered Rows

    Ok, but then how to I delete the visible rows from the worksheet I initially copied and pasted from without deleting the hidden rows?

  4. #4
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Cutting and pasting Filtered Rows

    Delete rows. This will only delete the filtered rows.

  5. #5
    Registered User
    Join Date
    02-14-2018
    Location
    SOUTHERN CAL
    MS-Off Ver
    2016 FOR MAC
    Posts
    8

    Re: Cutting and pasting Filtered Rows

    Thanks but it didn't work, the paste still brought over the hidden rows?

  6. #6
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Cutting and pasting Filtered Rows

    I just tried on windows and it works as expected.

    When I use cut the marching ants are in a single rectangle shape over the filtered data (will include hidden rows).

    When I use copy the marching ants are many rectangles over the data (excludes the hidden rows).

  7. #7
    Registered User
    Join Date
    02-14-2018
    Location
    SOUTHERN CAL
    MS-Off Ver
    2016 FOR MAC
    Posts
    8

    Re: Cutting and pasting Filtered Rows

    Yes I know that's what appears on the youtube videos also but I am just not getting the marching ants only an outllne around the entire area not each row ? Keep in mind, I am using Excel for MAC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Trouble cutting and pasting rows
    By BrianSells in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-06-2015, 02:53 PM
  2. Cutting and Pasting rows loopwise as per the same value in Proposal(Column E)
    By mvneema in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2014, 04:40 PM
  3. ** Selective Cut and Paste - Cutting and Pasting Rows if a Row has Key Word in Column
    By brad70989 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2011, 06:04 PM
  4. Cutting the same data from different rows and pasting them into the same rows
    By Sal1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 05:22 PM
  5. Inserting, Cutting, and Pasting Rows Based on What's in a Cell
    By 4EverLearning in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2010, 04:42 PM
  6. Cutting/Pasting Rows based on content PT 2
    By Lmsloman in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-21-2006, 06:36 AM
  7. [SOLVED] cutting and pasting rows from one sheet to another generates error
    By JT Spitz in forum Excel General
    Replies: 7
    Last Post: 02-14-2006, 03:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1