FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

April 26, 2016

Hi fellow Excel Addict,

Just back from a 10K run this morning. It was cold starting out but the sun made for a fantastic morning for a run.

So far my training is going better that I expected. Only two months ago I was wondering of I would ever get back running again after an 18-month layoff, but my slow and steady training pace seems to be working. In February I began running 30 seconds for every 5 minutes of walking. Now I'm up to 5 minutes of running and 2 minutes of walking. I'm more than pleased with that.

Despite those weather extremes we have seen here in the past few months, thankfully there's been much more good than bad. Mostly it's been great for biking and running. As you can see in these pictures, last Wednesday's big snowstorm was just a brief interruption to an otherwise decent spring.

20160420_weather_pic1 20160425_weather_pic1

If you missed last Thursday's 'Excel in Minutes' newsletter, I showed how to 'Force All New Workbooks to Print 1 Page Wide'. You can 
read it here.

If you have a favourite tip that you'd like to share, or a problem that you've been trying to solve, that I could possibly include in my newsletter, please send it along to me.

Wishing you an AWESOME week,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)


TheExcelAddict.com Quote of the Day

"Confidence is what you have before you understand the problem."

-- Woody Allen --




If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

Moving the Active Cell Around in a Selected Range

Once you have selected a range of cells, sometimes you will need to move the active cell within the range but still keep the range selected.

Here are some keyboard shortcuts you can use to move around in any direction in a selected range of cells.


Moving within a selected range
Once you have a range of cells selected...

Enter: Pressing the Enter key moves the active cell down one cell. When it gets to the bottom of the selection, it jumps to the top of the next column to the right. In single-row selection, pressing Enter moves the active cell one cell to the right.

Move Active Cell Down in Selected Range in Microsoft Excel 2007 2010 2013 2016 365
Shift+Enter: Pressing Enter while holding down the Shift key moves the active cell one cell up. When it gets to the top of the selection, it jumps to the bottom of the next column to the left. In a single-row selection, pressing Shift+Enter moves the active cell one cell to the left).

Move Active Cell Up in Selected Range in Microsoft Excel 2007 2010 2013 2016 365
Tab: Pressing the Tab key moves the active cell one cell to the right. When it gets to the right it jumps to the leftmost cell in the next row down. In a single-column selection, pressing the Tab key moves the active cell one cell down.

Move Active Cell Right in Selected Range in Microsoft Excel 2007 2010 2013 2016 365
Shift+Tab: Pressing the Tab key while holding down the Shift key moves the active cell one cell to the left. When it gets to the left of the selection, it jumps to the rightmost cell in the next row up. In a single-column selection, pressing Shift+Tab moves the active cell one cell up.

Move Active Cell Left in Selected Range in Microsoft Excel 2007 2010 2013 2016 365
CTRL + (period): Pressing the period (.) key while holding down the Ctrl key moves the active cell clockwise from corner to corner within the selected range.

Move Active Cell Up To Cornjers in Selected Range in Microsoft Excel 2007 2010 2013 2016 365

Moving within multiple selected ranges
If you have multiple ranges selected, the when the active cell is in the bottom right corner of one range, moving down (Enter) or right (Tab) will jump it to the top left corner of the next range. W
hen the active cell is in the top left corner of one range, moving up (SHIFT+Enter) or left (SHIFT+Tab) will jump it to the bottom right corner of the previous range.

Now, at first glance, these shortcuts may not look all that interesting, but as I always say, 'you need to practice each tip before you can know if it is something that will help you.'

Just take a minute to try moving the active cell around a selected range using the above keyboard shortcuts. If you are entering data, and want to move in a different direction than down, press one of the other keyboard shortcuts at the point you would normally press the Enter key.

You may not need to use this tip every day, but I'll bet there will be times when these shortcuts will come in handy for you.



Thanks for supporting this newsletter and website

FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630