Copying or moving cells is probably one of the most common activities in excel. Here is how to quickly select cells and adjacent cells containing values. The selection ends when there are blank rows or columns.

This is useful when working with large ranges. Keep in min that the selection might also contain blank cells. See examples below.

Example 1

  1. Select a cell somewhere in the range.
  2. Press F5
  3. Click "Special.."
  4. Click "Current region"
  5. Click "OK"

Example 2

  1. Select a cell somewhere in the range.
  2. Press CTRL + SHIFT + * (shortcut)