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
Medium Priority
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 41

Accepted Solution

Eoin OSullivan earned 1000 total points
ID: 36957096
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

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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
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…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

807 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