Copy & Paste VISIBLE CELLS ONLY

Copy & Paste VISIBLE CELLS ONLY

If some cells, rows, or columns on your worksheet are not displayed, you have the option of copying all cells or only the visible cells. By default, Excel copies hidden or filtered cells in addition to visible cells. If this is not what you want, follow the steps in the video to copy visible cells only.