Select visible cells only > ok Select copy (or press ctrl+c) Conclusions selecting only the visible cells from a range is an important first step if you want to copy and paste values from a range that contain hidden rows or columns You can quickly reduce your selected range to only the visible cells with a shortcut, the go to menu, or the quick acess toolbar. Copy only visible cells using the ribbon menu copying visible cells is easy, but by default, excel copies all cells present on the screen This includes visible and hidden cells both
For instance, we copy the data range a1 B8, where rows three and six are hidden in the data set below. By default, excel copies both visible and hidden cells However, it is possible to copy visible cells only.
OPEN
