May 3, 2016
Hi fellow Excel Addict,
My tips are often inspired by people who have been using Excel for years and, as I'm helping them, I hear "What did you just do!? I didn't know I could do that."
What's interesting is that many of these 'eureka' tips are so simple that I assume everyone already knows them. Today's tip is one of those simple shortcuts that everyone SHOULD know but apparently many don't. If you already know it, show it to others around you and I'll bet there are some that don't.
If you missed last Thursday's 'Excel in Minutes' newsletter, I showed how to 'Quickly Find All Values Not Rounded To Nearest Cent'. 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.
Shortcuts To Quickly Select Entire Rows Or Columns
I believe it is important to know both a keyboard method and a mouse method for the tasks you perform most frequently in Excel.
With your hands already on the keyboard, you may find it quicker to use a keyboard shortcut than having to reach for your mouse and then point and click.
Here are a couple of easy-to-remember keyboard shortcuts for something that I'm sure you do multiple times every day...selecting entire rows and columns.
To select the entire row where the active cell is located, hold down the key SHIFT and press the SPACEBAR.
To select the entire column where the active cell is located, hold down the key CTRL and press the SPACEBAR.
If cell B4 is selected, pressing Shift+Spacebar will select the entire row 4.
If cell B4 is selected, pressing Ctrl+Spacebar will select the entire column B.
You can keep your hands on the keyboard AND select multiple rows or columns by using the Shift and arrow keys before pressing the keyboard shortcuts.
So, to select rows 4 to 7, use the arrow key to move to any cell in row 4. Then hold down the Shift key and press the down arrow to select down to row 7. Now, when you press Shift+Spacebar, the entire rows 4 to 7 will be selected.
To select columns B to D, use the arrow key to move the active cell to column B. Then hold down the Shift key and press the arrow key to select over to column D. Now, when you press Ctrl+Spacebar, the entire columns B to D will be selected.
Note that if the row(s) or column(s) you select intersect with merged cells, that could affect your intended selection because the entire row(s) or column(s) that intersect the merged cells will be selected as well.
A strange Name Box shortcut
Interestingly, if you type a 'c' in the Name Box and press Enter, the entire column where the 'active cell' is positioned will be selected. If you type an 'r' in the Name box, the entire row where the 'active cell' is positioned will be selected. And if you type 'r,c' (i.e. r comma c), the entire row and column that intersect at the active cell will be selected at the same time. Also, these Name Box shortcuts work only on one row or column, so you cannot use them to select multiple rows or columns.
I'm not sure if there is any practical use for this since the Shift+Spacebar or Ctrl+Spacebar seem to be much better options.
| '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