Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I highlight all cells in an Excel row?

I'm using Excel 2010 on Windows.

share|improve this question
I tightened up the question. As it where it had 3 close votes. – Nifle Jun 28 '12 at 20:41
up vote 13 down vote accepted

The shortcut to select a complete row is ShiftSpace.

Similarly, in order to select a complete column, press CtrlSpace.

share|improve this answer
I just want to ctrl-a one row of data from a column so I can ctrl-c – Shades Jun 28 '12 at 15:21
@Shades what do you mean by just one row of data with Ctrl+A? If I understand you correctly then you want to use this shortcut for this particular task then you need AutoHotKey (I think?). – avirk Jun 28 '12 at 15:25
Well, I'm sorry, in your case I'd be happy that Microsoft was so consistent as to make Ctrl-A select everything and not just a row :P @Shades – slhck Jun 28 '12 at 15:25
I have 3 columns: Firstname, lastname, id. I need to copy out each individuals lastname only and paste into a separate file. So I just wanted to know if i could ctrl a and ctrl c individuals rows from "Fx" box instead of having to click and drag to highlight and then hit ctrl c from the Fx box – Shades Jun 28 '12 at 15:30
@Shades Have you thought about using Ctrl-Space to select the entire column, then copy it with Ctrl-C? I mean, that's what I already wrote in the answer, but … – slhck Jun 28 '12 at 15:32

Similarly, to select only the contiguous cells with data in them, i.e. not every cell on the current sheet...

CtrlShift+right arrow will select the row


CtrlShift+down arrow will select the column

Incidentally, choose up, down, left, or right depending on where you are on the sheet. The keyboard combinations above will select in the direction you hit from the selected cell as the starting point.

share|improve this answer
Thank you for the tip – Shades Jun 28 '12 at 15:37

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .