Forum Discussion
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 +...
Hi,
There is no way to change the default action of Copy command, but you can automate the extra steps to copy only the visible cells through Macros.
To learn more about Macros, follow these links:
Haytham Amairah I have 2 excel files (2016). One selects only hidden cells by default, the other selects all cells. I cannot figure out what setting is different in two files. Hidden cels in both files are grouped cells.
