Oh, forgot one. If you select a range of rows starting above and ending beneath the invisible ones, try Format/Row/Unhide. The button is the Format button on the Home ribbon. Keystrokes "ALT+ O, R, U" (holding down the ALT key, typing and releasing O, then R, then U for unhide [H for hide to reverse the command]) is how I usually do it.