Dragging to select a large table means either overshooting past the last row, or losing your place halfway down a long scroll.
Excel already knows where your table starts and ends — you just have to ask it.
Here's the trick:
Ctrl+Shift+8 grabs the whole current data region — no dragging, no missed rows.
How to use it
- Click any single cell inside your table.
- Press Ctrl+Shift+8 (or Ctrl+* depending on your keyboard).
- Excel selects every contiguous cell of data around that point, stopping at the first fully empty row or column.
Where it helps most
Copying, formatting, or building a chart from an entire table without manually dragging to select it — especially useful when part of the table is scrolled out of view.
One thing to watch for
A single blank row or column anywhere inside your data will stop the selection early. This works best on tables that are genuinely contiguous, with no gaps.
Found a faster way to do this, or a version that works differently on Mac? That's what the comments are for — this section connects to your comment system of choice (Disqus, giscus, etc.) once the site is live.