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.

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 ...

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.

To lock your cells in Microsoft Excel, you just need to head into the program's "Protection" tab. Locking a cell in Excel will make it so viewers can't change the data inside of that cell, which ...

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.