Whether you’ve used a filter that hides certain cells, collapsed an outline, or hidden specific rows or columns, sometimes you want to work just with the data you see. You can select the visible cells with a keyboard shortcut or with the Go To Special menu.

Select Only the Visible Cells with Alt+;

  1. Select the range of cells in your worksheet.
  2. Press Alt+; (hold down the Alt key and then press the semicolon key). On a Mac the shortcut is Cmd+Shift+Z. Excel will exclude all the hidden data from your selection and then you can copy (Ctrl+C) and paste (Ctrl+V) only the visible cells.

Select Visible Cells Only with the Go To Special Menu

The keyboard shortcut is the quickest way to select visible cells only, but if you don’t use this feature often, you can instead use the Go To Special menu.

  1. Select the range of cells in your worksheet.
  2. Click the Find & Select button on the Home tab, then click Go to Special…
  3. Select Visible cells only…
  4. Click OK. Now you can copy and paste without worrying about the hidden data being pasted also.

How to Freeze Rows and Columns in Excel 2016How to Lock Cells in Excel 2016How to Create a Waterfall Chart in Excel 2016