Use Shift + Arrow key to select the cells you wish to select.
To select a list, you can also use Ctrl + A.
In this state, hidden cells are also selected.
Alt + H + F + D + S to display the Go To Special dialog box.
Press Y to select Visible cells only.
Press Enter selects only visible cells.
Please send us your comments on this article.