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.
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)
If you missed my last newsletter, you can click here to view it online.
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 a single-row selection, pressing Enter moves the active cell one cell to the right.
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).
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.
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.
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.
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. When 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.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630