I recently started using a macbook pro with Office for Mac 2011. How do I find the last active cell in a range without the end key? I have searched the net and tried combinations of fn, command, shift and arrow keys to no avail! I have workbooks where I have data sheets containing thousands of lines of data which feed pivot tables. When I update the data I need to change the range of the source data for the pivot tables and it takes entirely to long to grab the data manually with the mouse.