Select rows 3 to 6 and right-click on the row number column: no more "Insert Rows Above" and "Deleted Selected Rows" in the pop-up menu. Note that from now on, when current cell is B4, B5, B6, B7 or B8, formula in formula bar is shown within curly brackets (""). Check step: select rows 3 to 6 and right-click on the row number column: "Insert Rows Above" and "Deleted Selected Rows" are part of the pop-up menu items. Check step: select rows 2 to 4 and right-click on the row number column: "Insert Rows Above" and "Deleted Selected Rows" are part of the pop-up menu items. How to reproduce the issue, starting with an empty spreadsheet: When the spreadsheet contains a matrix of several hundreds cells (or worse, several such matrices), this is quite painful and user-unfriendly. To perform the row insertion/deletion, you have to select every matrix of cells, delete their contents (especially the matrix formulas), do the insertion/deletion, and recreate the matrices from scratch (assuming you copied the matrix formulas somewhere else before deleting them). You cannot even insert several rows at once right above a cell matrix (as soon as the selection before the insertion makes you select some rows of the matrix). Once you have created one or several matrices of cells in a spreadsheet, you cannot add or delete rows anywhere between the first and the last row of any of the matrices.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |