Copy all cells including hidden ones in Excel 2016
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?
Re: Copy all cells including hidden ones in Excel 2016
Is the stuff you're copying in a filtered range or a range where the row heights are zero.
Copying a range which includes zero row height rows will copy ALL cells. Copying a filtered range will only copy the visible cells.
I don't believe there's any difference in this treatment between 2010 & 2016
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By sal-1 in forum Excel General
Last Post: 03-31-2021, 04:24 PM
By Neilesh Kumar in forum Excel Programming / VBA / Macros
Last Post: 04-17-2018, 08:28 AM
By ioswoody in forum Excel Formulas & Functions
Last Post: 05-26-2015, 02:28 AM
By whitwoo in forum Excel Formulas & Functions
Last Post: 12-22-2014, 10:33 AM
By FallingDown in forum Excel Programming / VBA / Macros
Last Post: 12-12-2014, 04:17 AM
By finny388 in forum Excel General
Last Post: 09-28-2011, 03:08 PM
By EI-ALEX in forum Excel General
Last Post: 08-09-2010, 03:52 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1