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

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)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)


TheExcelAddict.com Quote of the Day

"Experience is simply the name we give our mistakes."

-- Oscar Wilde --




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



Excel in Seconds with TheExcelAddict.com

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.

Keyboard Shortcut Select Entire Row in Microsoft Excel 2007 2010 2013 2016 365

If cell B4 is selected, pressing Ctrl+Spacebar will select the entire column B.


Keyboard Shortcut Select Entire Column in Microsoft Excel 2007 2010 2013 2016 365

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.

Keyboard Shortcut Select Entire Rows in Microsoft Excel 2007 2010 2013 2016 365

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.

Keyboard Shortcut Select Entire Columns in Microsoft Excel 2007 2010 2013 2016 365

Merged Cells
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.


Hospitals Are #NotATarget

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