You will again see that it gets selected and highlighted in gray. Hold the Shift key and then press the Spacebar key. If you want to select the entire row, select any cell in the row that you want to be selected and then use the below keyboard shortcut To do this, select two adjacent cells (one in column C and one in Column D) and then use the same keyboard shortcut. For example, suppose you want to select both columns C and D. You can use the same shortcut to select multiple contiguous columns as well. The above shortcut would instantly select the entire column (as you will see it gets highlighted in gray – indicating that it’s selected)

In case you’re using Excel on Mac, use COMMAND + SPACE

Hold the Control key and then press the spacebar key on your keyboard Once you have any cell in column C selected, use the below keyboard shortcut: The first thing to do is select any cell in Column C. Suppose you have a dataset as shown below and you want to select an entire column (say column C).

So let’s get started! Select Entire Column/Row Using Keyboard Shortcut # I will also show you how to do this when you’re working with an Excel table or Pivot Table. In this tutorial, I will show you how to select a column or row using a simple shortcut, as well as some other easy methods. Just like with most things in Excel, there is more than one way to select a column or row in Excel. And if you work with large datasets, selecting entire rows and columns is quite a common task.

Pivot table excel shortcut keys