Set Default to Copy and Paste Visible Cells Only
Hello, Does anyone know if we can set the Copy and Paste Function to default into copying and pasting only the visible cells? I'm using Excel 2016 in Windows 10. I've been doing the Alt + ; and then copying it way but when copying, I never want the hidden cells anyway. So I'm wondering if this could be set as default to avoid the extra step. Thanks!
copying from excel to text goes wrong, how to solve
As seen in the screenshot, I selected the blocks on the left using ctrl and shift. If pasted in excel, it is all going well, but when copied to another textfile (or the sent to box of my email), it goes wrong. How can this be solved? And will this bug be removed in an update?
