<p>I have an excel file which has more than 65536 rows. However, I can see only first 65536 of them. Is it possible to see all of them in Excel 2007?</p>

According to
this MSDN entry
, the limit is 1 million rows.  You could be running in compatibility mode, which would limit you to the old standard of 65k.  Does your excel say compatibility mode in the title?  If so, you can save the file as a new style file under the "save as" menu, or change your default to always use the 2007 file standard.