Re: Slicer vs Filter Yes the slicer on a pivot table does the summary, but wanted it on a data table where I can edit data as required, I will try the helper column as you suggested. The screen shot is a pivot table from the same data table. Does anyone know a way to view slicers in an Excel file on a Mac? Maybe some online viewer, a 3rd party app, or an add-on someone developed? Honestly, at this point, cost is not much of a factor as so many man-hours have been put into the PC implementation as is.

Hi You don't have to create a Pivot Table if you don't want to, but you must convert your data to a Table at least. Place your cursor anywhere within your data and Choose Insert > Table Excel will show what it thinks the range is and prompt whether your data contains Header. How to format the wd passport for mac.

Just click OK. You can let the table take the default name of Table1 or give it a new name yourself. With your cursor within the table, you will see a new tab called Design.

Click on that and you will see the option in the Tools section to Insert Slicer.