Delete Row This shortcut will delete rows that are selected. Windows shortcut Ctrl- Mac shortcut ⌘- Excel 2013 Shift+Spacebar to select the row. Ctrl+-(minus sign) to delete the row. Excel
Delete Blank Rows Blank rows aren’t bad, but in most sheets, they’re definitely undesirable. Excel uses blanks to determine data ranges, and a blank row in the wrong place
Row Differences Have you ever had to find the cell whose value did not match those of other cells in the same row? Rather than checking manually, Excel Row Differences allows you to
Copy Visible Cells Only If some cells, rows, or columns on a worksheet do not appear, you have the option of copying all cells—or only the visible cells. By default, Excel copies
If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest
Hiding and showing columns and rows can be very helpful when, for example, you want to hide parts of your spreadsheet that are distracting, and if you want to hide them temporarily. To
Adjusting column widths and row heights in Excel can make for a much nicer looking spreadsheet. No need for cells that get cut off! And if you learn to quickly use AutoFit, you
If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to
it depends on the Excel version you are using. The number of cells, columns, rows, and sheets supported by a spreadsheet depend on the software being used, and the data contained in the