How do I find the last active cell in a range in Office for Mac 2011 on a Macbook without the end key?

Posted on 2011-10-12
Last Modified: 2012-05-12
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.
Question by:MorefieldIT
    LVL 39

    Accepted Solution

    I don't have a laptop to test these but have you tried ..

    ctrl+fn+left arrow for HOME and ctrl+fn+right arrow for END

    These work on my Excel on my Mac keyboard

    Author Closing Comment

    I still have an issue but I think it has to do with excel thinking deleted cells are still active.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    This collection of functions covers all the normal rounding methods of just about any numeric value.
    Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
    This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now