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
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
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks