In Excel, when I have some rows hidden but then select rows around them, What happens to the hidden rows?
1) The hidden rows remain hidden
2) The hidden rows are automatically unhidden
3) The hidden rows are selected along with the visible rows
4) The hidden rows are deleted
