Or when you have hidden rows or columns from a collapsed group in an outline. This commonly happens when you are working with a range that has filters applied to it. Sometimes we only want to copy and paste the visible cells, and exclude the hidden rows & columns. This is actually a nice feature, but it's not always what we are expecting to happen.

When you go to paste the range, all the cells in the selection will be pasted. It does not matter if they are visible or hidden. When you copy a range of cells that contains hidden rows or columns, Excel includes ALL of the selected rows. Why Are My Hidden Rows & Columns Being Pasted? Please leave a comment below with any questions. The shortcut will select the visible cells only in a range, ignoring the hidden rows and columns. This problem can be frustrating and time consuming! In this post and video I will explain how to solve this problem with a very simple shortcut. Have you ever tried to copy and paste a range with hidden rows or columns and didn't get the results you expected? Have you ever tried to copy and paste a range with hidden rows or columns and didn’t get the results you expected? This problem can be frustrating and time consuming! In this post and video I will explain how to solve this problem with a very simple shortcut to select the visible cells only.

Excel 2016 select visible cells