Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

DROP

TAKE DROP

By Jeff Lenning | February 10, 2026 |

Sometimes we want to grab just the latest few rows of a report, remove some headers, or extract a specific section of data—like Q2 sales—from a larger table. Excel’s TAKE and DROP functions are perfect for these tasks. In this post, we’ll walk through real examples (based on our sample file) to see how these…