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

If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter customization tools to limit the number of rows included in your filter results.

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.