The best way to do this is by converting your data to an Excel table. Select your data range (A1:E11), press Ctrl + T, and ...
Hosted on MSN
7 simple tips to clean up your datasets in Excel
Handling hundreds of rows, columns, and pivot tables usually results in a less-than-perfect dataset. A massive Excel workbook is often riddled with inconsistencies, errors, missing values, duplicates, ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback