48+ How To Add Filters In Excel New. Click any single cell inside a data set. The filter menu will appear. Show Excel Filter Criteria Using VBA • Productivity Portfolio from www.timeatlas.com This formula also can help you sum only the visible cells if there are hidden rows in your worksheet. To create filter buttons, …