Select visible cells only in Excel

Hi reader,

Perhaps you already want to select only the visible cells in a Excel sheet and you just do not know how to do it. Lets find the solution in the following example.

Assuming you just want to select the "Mobile Phone" from the list, filter the column B with that option, and then to select only the visible cell from the table, just select all the table and press on your keyboard the following sequency:

• Alt +Shift + ;

Having the selection made, you can, for instance, copy it to another sheet.

Hope it makes your spreadsheets easier.