![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |