How to select two cells in Excel

You can watch a video tutorial here.

Excel is a popular spreadsheet application in which the workspace is arranged in rows and columns. Each intersection of a row and column is a cell. You may need to select two cells to format them or to move them to another location.  The cells could be contiguous or could be in different locations. 

Option 1 – Use the mouse

Step 1 – Select the cells

  • Click on the first cell 
  • Hold down the mouse key and drag to select the second cell

Option 2 – Use the keyboard

Step 1 – Select the first cell

  • Select the first cell

Step 2 – Select the cells

  • Hold down the Ctrl key
  • Select the second cell