In this tutorial, I will show you three ways to select visible cells only in Excel. Then I can copy and paste these visible cells only. The workaround to this is to make sure that Excel only selects the visible cells. In the above example, I selected the visible cells, but when I paste these cells into another location, it copied the visible as well as the hidden cells. Now see what happens when I try to copy these cells and paste it somewhere else. Note that there are hidden rows in this dataset (look at the row numbers). Suppose you have a dataset as shown below: Let me show you what happens when you try to copy cells that have hidden rows/columns in it. Then – these above three steps are not enough.
Select the destination cell and paste these cells (Control + V).īut what if you have some hidden cells in the dataset?.Select the cells that you want to copy.In most cases, the below three steps get the work done: What do you do when you have to copy a range of cells in Excel and paste it somewhere else?
Watch Video – 3 Ways to Select Visible Cells in Excel
