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)

Share and Enjoy:
  • Share/Bookmark

Related posts:

  1. Insert a new row at the top every time a value has been entered
  2. Highlight unique values and unique distinct values in a range using conditional formatting in excel
  3. Filter text values existing in range 1 but not in range 2 using array formula in excel
  4. Highlight duplicate values in a range using conditional formatting in excel
  5. How to create excel macro to color every second row
  6. Create a unique distinct list of a long list without sacrificing performance using vba in excel
  7. Filter common text values in range 1 and in range 2 using array formula in excel
  8. Sort cell values into categories, part 2
  9. Extract a unique distinct list sorted alphabetically removing blanks from a range in excel
  10. Highlight dates within a date range using conditional formatting