Hi,

When I select an area in a table using Excel 2010 and copy it, it copies all cells in the area including those in hidden rows and columns

In Excel 2016 it will only copy visible cells by default. How can I copy all cells in Excel 2016?

Thanks
raf