I have an Excel 2003 workbook with a nunber of hidden columns. I need to
select and copy everything in colums A-J, colums C-H are hidden, but I sill
want to select the content when using Ctrl+C to copy. When AutoFilter is not
applied, I can select the cell in column A of the row I wish to copy, then
Ctrl+Shift+Right to column J and hit Ctrl+C (or click 'Copy') and Excel
copies ALL cells in columns A-J of the row selected.

Now when I apply an AutoFilter to the same worksheet, say column I, and
perform the exact same procedure, the hidden cells in columns C-H are NOT
copied, it's like the "Select Visible Cells" button is automatically applied.

How can I select ALL cells, including hidden one when AutoFilter is applied?
This is driving me crazy, because it is only happening in this one
particular workbook. Thanks

Hi,

This is the intended behaviour for the AutoFilter. Microsoft figures if you
want to copy from a range where you have applied an autofilter you only want
to copy the visible cell. Why, because if that was not the case you would
would just unhide the rows and choose copy.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"west8100" wrote:

I have an Excel 2003 workbook with a nunber of hidden columns. I need to
select and copy everything in colums A-J, colums C-H are hidden, but I sill
want to select the content when using Ctrl+C to copy. When AutoFilter is not
applied, I can select the cell in column A of the row I wish to copy, then
Ctrl+Shift+Right to column J and hit Ctrl+C (or click 'Copy') and Excel
copies ALL cells in columns A-J of the row selected.

Now when I apply an AutoFilter to the same worksheet, say column I, and
perform the exact same procedure, the hidden cells in columns C-H are NOT
copied, it's like the "Select Visible Cells" button is automatically applied.

How can I select ALL cells, including hidden one when AutoFilter is applied?
This is driving me crazy, because it is only happening in this one
particular workbook. Thanks

Why, because if that was not the case you would
would just unhide the rows and choose copy.


I'm using AutoFilter to filter out rows of data that I don't want to copy,
however in the rows I do want to copy, I want all of the columns, even if
they are hidden.


"Shane Devenshire" wrote:

Hi,

This is the intended behaviour for the AutoFilter. Microsoft figures if you
want to copy from a range where you have applied an autofilter you only want
to copy the visible cell. Why, because if that was not the case you would
would just unhide the rows and choose copy.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"west8100" wrote:

I have an Excel 2003 workbook with a nunber of hidden columns. I need to
select and copy everything in colums A-J, colums C-H are hidden, but I sill
want to select the content when using Ctrl+C to copy. When AutoFilter is not
applied, I can select the cell in column A of the row I wish to copy, then
Ctrl+Shift+Right to column J and hit Ctrl+C (or click 'Copy') and Excel
copies ALL cells in columns A-J of the row selected.

Now when I apply an AutoFilter to the same worksheet, say column I, and
perform the exact same procedure, the hidden cells in columns C-H are NOT
copied, it's like the "Select Visible Cells" button is automatically applied.

How can I select ALL cells, including hidden one when AutoFilter is applied?
This is driving me crazy, because it is only happening in this one
particular workbook. Thanks