Excel DROP function to remove rows or columns from range or array

When analyzing huge datasets, you may sometimes need to pull only the data without a total row/column, headers, or footers. In earlier Excel versions, you’d have to rely on the good old copy/pasting technique. In Excel 365, we have a special function to dynamically extract the desired part of the array by “dropping” irrelevant data.

This tutorial introduces you to the brand-new Excel 365 function that can drop unwanted rows and columns to return a relevant subset of data.

When analyzing huge datasets, you may sometimes need to pull only the data without a total row/column, headers, or footers. In earlier Excel versions, you’d have to rely on the good old copy/pasting technique. In Excel 365, we have a special function to dynamically extract the desired part of the array by “dropping” irrelevant data.

• Excel DROP function
• How to use DROP function – examples
  • Drop rows from start of the array
  • Remove columns from start of array
  • Drop rows and columns
  • Remove last N rows
  • Remove last N columns
• Sort and drop
• Drop rows / columns from multiple ranges
• DROP vs. TAKE
• Excel DROP function not working