To copy only visible cells in Excel or Google Sheets, use the 'Visible cells only' feature, or apply filters to hide data. We show you how!

By default, Excel copies hidden or filtered cells in addition to visible cells. The key is to select just the visible cells before you click Copy. HOW TO: Select the cells.

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows.

I have a work sheet, it has 10,000 rows.2,000 of those are for the state of New York.So I add a filter, then drop down on the state column and select New York.I then have 2,000 rows displayed.I ...

How to Filter Every 5th Item in Excel. When manipulating large amounts of data in an Excel spreadsheet, it can be challenging or time-consuming to select specific items by hand.

Here’s how to lock cells in Excel, whether you’re on Windows 10 or macOS, and it's easy as pie. Learn how to lock cells in Excel and keep vital information on your spreadsheets secure.