top of page
Search

Shortcut of the Week: Alt + ; – Select Only Visible Cells in Excel

Quote on dark background: Ever copied filtered data with hidden rows? Use Alt + ; to select visible cells only. Credit: @excelwizardd.

You’re copying filtered data in Excel and end up pasting unwanted rows?

The solution is simple:

Alt + ; → Selects only visible cells.

Why it matters:

  • Avoids pasting hidden rows

  • Keeps your reports clean

  • Saves time while working with large datasets



🎯 Use this in reports, dashboards, and filtered exports. Master shortcuts with Excel Wizardd every week.


Shortcut of the Week

Comments

Rated 0 out of 5 stars.
No ratings yet
Add a rating
bottom of page