Display the Active Cell

April 27, 2013

0 comments

active cell   How Excel Skin Works   Mac Excel Shortcuts   mac shortcuts for excel   Mastering Excel   Scroll to active cell  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

Scroll to display active cell


When you start working with Microsoft Excel spreadsheets that have data filled in through the BA column you know how difficult it is to find the cell you have selected.  Thankfully MS Excel for Mac has provided a shortcut that scrolls to your active cell so you never get lost in the sea of data again. 


Step 1: The purpose of this shortcut is to be able to find your selected cell without having to search the spreadsheet manually.  Therefore a selected cell is required.  This is a tricky shortcut to explain but first we will select a cell, then we will scroll away from it.  Here we go:

 


I have selected 3B.  Now I am going to scroll so it is not on my screen:



3B is no longer visible so we need to execute the shortcut to scroll back to 3B.  The shortcut can be found on the “delete” key and is written in yellow as “Display Active Cell.”  The yellow text corresponds to only 1 modifier key, the “control” key.  Our shortcut is:

⌃Delete


After executing this shortcut Microsoft Excel scrolls to my active cell. 




One thing to remember with this shortcut is you have to keep the initial active cell active, meaning you cannot click any other cells while scrolling through your spreadsheet.  If you do click a different cell, the active cell we had in the beginning is no longer active, and this shortcut will not scroll you back to it.  





Leave a comment

Comments will be approved before showing up.