Missing Excel Rows

  • Thread starter Thread starter John Doe
  • Start date Start date
J

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?
 
Hi
you have probably hidden the rows. Try the following:
- select rows 630-672 (highlight them)
- goto 'Format - Rows - Unhide'
 
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.
 
Back
Top