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.
Showing only few rows & columns in Excel. Step 1: Select the column from which you want to hide. Step 2: Press CTRL+Shift+Right Arrow to select all the columns till XFD. Step 4: Select the row from which you want to hide. Step 6: Hide the rows too.