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!

When you need to print only a limited range of worksheet data, Microsoft Excel 2010 offers a "Set Print Area" option to help you manage your print content. Adjust the page setup to mark the cells ...

Click "OK" to filter the Excel data. Repeat the process for all columns that contain cell values of zero until all rows with zero cell values are hidden. Press "Ctrl-P" on your keyboard.

A common use of data validation is to create a drop-down list. Use it to restrict the type of data that users enter into an Excel cell.