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.
Insert or delete cells, rows, and columns. You can insert blank cells above or to the left of the active cell on a worksheet. When you insert blank cells, Excel shifts other cells in the same column down or cells in the same row to the right to accommodate the new cells.Similarly, you can insert rows above a selected row and columns to the left of a selected column. You can also delete cells, rows, and columns.Note Microsoft Office Excel 2007 has more rows and columns than ever before, with the following new limits: 16,384 (A to XFD) columns wide by 1,048,576 rows tall.imilarly, you can insert rows above a selected row and columns to the left of a selected column. You can also delete cells, rows, and columns. Note Microsoft Office Excel 2007 has more rows and columns than ever before, with the following new limits: 16,384 (A to XFD) columns wide by 1,048,576 rows tall.