ChatterBank1 min ago
Microsoft Excel Query
Is it possible to copy and paste a selection where it ignores hidden columns ? All the methods I can think of result in it pasting the hidden columns.
I have tried pasting the results in Notebook which doesn't paste those hidden columns but I'd rather find a solution within Excel.
Cheers
I have tried pasting the results in Notebook which doesn't paste those hidden columns but I'd rather find a solution within Excel.
Cheers
Answers
Best Answer
No best answer has yet been selected by Gerb. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Just as an afterthought, if you are going to be doing this a lot, you can actually make the Select Visible Cells command visible on your Edit toolbar.
Just go to Tools/Customize/Commands. If you highlight Edit in the left window, this will give you a list of commands in the right window. Just drag Select Visible Cells from here onto your Edit toolbar.
Just go to Tools/Customize/Commands. If you highlight Edit in the left window, this will give you a list of commands in the right window. Just drag Select Visible Cells from here onto your Edit toolbar.