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.
Excel 2010 - how to Select or display rows if column C has specific values? No VB. I have a huge spreadsheet and column C contains IDs such as 1, 99, 732387, 28. I have a separate list of IDs such as 23, 87, 902 and I only want to display the rows whose column C value belongs to my list.