Missing Excel Rows

[John Doe]

The Excel Spreadsheet I am working on suddenly has
disappeared rows 631 to 671. If I search for the entries
within those rows, (I know word Knowles was in there),
Excel finds the word, and gives the correct row number,
but I cannot see it, nor access it. Whats up with that?

 

[Frank Kabel]

Hi
you have probably hidden the rows. Try the following:
- select rows 630-672 (highlight them)
- goto 'Format - Rows - Unhide'

 

[Norman Harker]

Hi John!

Check if you have a filter applied (Data > Filter)

Or you might simply have hidden rows.

Select rows ether side and use:

Format > Row > Unhide

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.