View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Finding total # of records in an Excel file without scrolling

CTRL-End will take you to the cell that Excel thinks is the last used
cell (though this might be beyond the last record). CTRL-Home will
take you back to the first cell.

Hope this helps.

Pete

On Nov 5, 9:25*pm, LQ wrote:
I am new to Excel 2003 and would like to know how I can find the total number
of records / rows in a particular file without scrolling down until I see the
last row entered. Is there someplace that gives me a total?