In a chart, click the category axis that you want to change, or do the following to select the axis from a list of chart elements: Click anywhere in the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
9 Answers. Since Excel 2007 (Windows) and Excel 2008 (Mac), the number of rows in a .xlsx, .xlsm or .xlsb worksheet is fixed at 1,048,576. That is 2^20. Excel only stores the data and formatting actually used, so there is no penalty for having such a large number of rows in every worksheet.
Supposing you have 2 tables of data and you want to find duplicate rows based on 3 columns - Date, Item and Sales: 1  Step 1. Assuming that you have the Duplicate Remover for Excel installed, select any cell within the 1st table, and click the Compare Two Tables button on the ribbon to start the wizard.