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.
In rows 1â20, you can merge across (not merge cells) 4 columns and go back to what you had before (sort of!). In rows 21â30 you can merge 3 columns and have a new column width 3/4 that of what the top ones are. In rows 31â40, you can merge 2, etcâ¦. But please, donât do this! As an analyst, I cry a little inside when someone drops an Excel to me with merged cells.