W
west8100
I a worksheet with data in all cells of columns A-J, but columns C-H are
hidden. I need to copy ALL cells in columns A-J into another worksheet, not
just the visible ones. When AutoFilter is turned OFF, I can select a cell in
column A of the row I want to copy and CTRL+SHIFT+RIGHT to column J, then hit
CTRL+C (or click ‘Copy’) and ALL data of the row (including hidden cells) is
copied, just like I want.
Now when I apply an AutoFilter, say to column I, and perform the same
procedure as above, it only copies the visible cells and omits the data in
columns C-H, it’s like the “Select Visible Cells†button is always applied
with AutoFilter is on. How do I turn this off and select ALL the cells?
This is driving me crazy because it’s only happening with this particular
workbook.
hidden. I need to copy ALL cells in columns A-J into another worksheet, not
just the visible ones. When AutoFilter is turned OFF, I can select a cell in
column A of the row I want to copy and CTRL+SHIFT+RIGHT to column J, then hit
CTRL+C (or click ‘Copy’) and ALL data of the row (including hidden cells) is
copied, just like I want.
Now when I apply an AutoFilter, say to column I, and perform the same
procedure as above, it only copies the visible cells and omits the data in
columns C-H, it’s like the “Select Visible Cells†button is always applied
with AutoFilter is on. How do I turn this off and select ALL the cells?
This is driving me crazy because it’s only happening with this particular
workbook.