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?
Bookmarks