Like most things in Excel, there is more than one way to select a column or row in Excel.
Working with Excel means working with cells and ranges in the rows and columns.
And if you operate with large datasets, selecting entire rows and columns is quite a common task.
In this tutorial, I will guide you on selecting a column or row using a simple shortcut and some other easy methods.
Select Entire Column/Row Using Keyboard Shortcut
Suppose you have a dataset, as shown below, and you enjoy selecting an entire column (say column C).
The foremost thing to do is select any cell in Column C.
Once you keep any cell in column C selected, use the below keyboard shortcut:
CONTROL + SPACE
Maintain the Control key, and then press the space-bar key on your keyboard
In subject you’re using Excel on Mac, use COMMAND + SPACE
The above shortcut would instantly select the entire column (as you will see, it gets highlighted in gray – indicating that it’s select)
You can operate the same shortcut to select multiple contiguous columns as well. For example, suppose you desire to select
both columns C and D.
Select two adjacent cells (one in column C and one in Column D) and then use the same keyboard shortcut.
Selecting the Entire Row
If you want to select the entire row, select any cell in the row you want to be selected, and then use the below keyboard shortcut.
SHIFT + SPACE
Keep the Shift key and then press the Space-bar key.
You will furthermore see that it gets selected and highlighted in gray.
If you want to select multiple contiguous rows, select multiple adjacent cells in the same column and then use the keyboard shortcut.
Select Entire Column (or Multiple Columns) Using Mouse
Select One Column (or Row)
If you want to select an entire column (say column D), hover the cursor over the column headers (where it says D). You will detect that the cursor changes to a black downward-pointing arrow.
Select Multiple Contiguous Columns (or Rows)
Imagine you want to select multiple columns that are next to each other (say columns D, E, and F)
Follow the below steps to do this:
- Place the cursor on the left-most column header of column D
- Press the left mouse key and keep it pressed
- With the left key pressed, drag the mouse also to cover columns E and F
The above steps would automatically select all the columns chosen between the first and the last column.
Select Multiple Non-Contiguous Columns (or Rows)
The most common scenario is where you need to select multiple columns that are not next to each other (say columns D and F).
Below are the steps to do this:
- Place the cursor at the column heading of one of the columns (say column D in this case)
- Click the mouse left key to select the column
- Press and hold the Control key
- With the Control key pressed, choose all the other columns you want to select
Way cool! Some very valid points! I appreciate you penning this article and the rest of the site is also really good. Elliot Mulberry
Awesome! Its actually awesome piece of writing, I have got much clear idea regarding from this article. Teddy Hyams
I cannot thank you enough for the article post. Much thanks again. Fantastic. Josue Vu
This is my first time pay a visit at here and i am really impressed to read everthing at one place. Jonathan Dobles
Sweet internet site, super design, rattling clean and employ genial. Timmy Mchaffie
Great article post. Really looking forward to read more. Want more. Wm Cassem
Itu tadi cara analisa bandar judi poker qq terpercaya. Brant Heyes
I am really delighted to glance at this web site posts which consists of lots of helpful facts, thanks for providing such statistics. Keneth Pastor
Amazing things here. I am very happy to peer your post. Jamey Aroche
Plus accounts via subscription their legitimate owner without any risk. Willian Hamersly
I am sure this article has touched all the internet visitors, its really really good piece of writing on building up new web site. Raymundo Priebe
Hello mates, its fantastic piece of writing regarding tutoringand entirely explained, keep it up all the time. Porfirio Tamlin
What a data of un-ambiguity and preserveness of valuable experience concerning unexpected emotions. Chauncey Jenaye
You can definitely see your enthusiasm in the work you write. Earnest Hallin
I love your writing style really loving this web site. Valentin Balk
Some really nice and useful information on this internet site, too I think the pattern has wonderful features. Alden Moua
At this moment I am ready too do my breakfast, later than having my breakfast coming gain to ead more news. Dennis Nolte
There is definately a lot to find out about this subject. I really like all the points you have made. Marco Varos
Hello mates, how is the whole thing, and what you want to say regarding this article, in my view its actually remarkable in support of me. Quinn Gianni
Hello, I think your web site may be having internet browser compatibility problems. Les Beaulac
I really like your writing style, great info , thankyou for posting : D. Marcelo Pluta
Thankfulness to my father who stated to me concerning this blog, this blog is actually amazing. Laurence Gerhauser
There is certainly a great deal to find out about this subject. I love all of the points you have made. Riley Casarz
These are generally probably the most awesome and fashion chanel bags I ave actually had. And really fashionable. Worth every single cent. Erin Tacconi
Major thankies for the blog article. Much thanks again. Keep writing. Desmond Schaunt
I got what you intend,saved to my bookmarks, very nice website. Dusty Brunsvold
Having read this I thought it was rather enlightening. Marty Chiu
My family every time say that I am wasting my time here at net, however I know I am getting experience daily by reading thes pleasant articles. Christoper Staton
Hello colleagues, its enormous article concerning educationand entirely explained, keep it up all the time. Josh Kerlin
Very good article! We are linking to this great content on our website. Keep up the good writing. Columbus Plambeck
Fantastic bike, solid brakes and also comfortable riding setting. Merrill Avirett
Estoy interesada en solicitar la tarjeta de credito olimpica, me gustaria saber como hacerlo atravez de la pagina en internet. Robin Frohwein
This will allow you to provide relevant links to anyone that is reading your blog, and will also make you a little extra money. Raleigh Niebaum
Enjoyed every bit of your post. Really looking forward to read more. Fantastic. Garrett Schandel
Excellent post! We will be linking to this great article on our site. Keep up the good writing. Napoleon Miao
Great service good people clean store. all employees very nice and had smiles. Mack Knell
Speaking of gullible, there were no, no lock down states. Some more locked down than others. Alonso Tzeremes
I really liked your blog. Really looking forward to read more. Want more. Domenic Cascio
Howdy, I do think your site could be having internet browser compatibility issues. Lavern Michelsen
This page certainly has all the info I needed concerning this subject and didn at know who to ask. Doug Sitz
Nice response in return of this maatter with real rguments and describing all on the topic of that. Adan Vannoy