Nov 29 2017 07:35 AM
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!
Nov 29 2017 09:26 AM
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:
Jul 05 2019 04:29 AM
@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.
Sep 16 2020 08:15 AM - edited Sep 16 2020 08:19 AM
I just found a workaround that someone explains which is pretty easy to apply.
https://a4accounting.com.au/select-visible-cells-only-hack/
The basic of it is that by default excel pastes only visible cells in case of a filter present in the worksheet (Anywhere) which is pretty logical seeing that filters are mostly applied to tables.
So when you make a small filter somewhere in an empty space of the worksheet than it will apply the default anywhere in the sheet.
for example:
A300 Num
A301 1
A301 2
Then put a filter on Num and just put the filter for one (right click A300 and choose: filter / Filter by selected cell's value)
Leave the filter on the worksheet and from then on excel by default will only paste to visible cells.